Versions Compared

Old Version 1

changes.mady.by.user Ekaterina Marchenko

Saved on

compared with

New Version 2

changes.mady.by.user Ekaterina Marchenko

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. If you need to transfer only dictionaries when upgrading:
    1. In SH4, perform a backup recovery using DELDOC
    2. Check the SH4 database for errors and fix them if there are any
    3. Make a backup before upgrading.
  2. If you need to transfer all the delivery notes:
    1. Check the database for errors and fix them if there are any
    2. Make a backup before upgrading.
  3. If you need to transfer the dictionaries and opening balance as of the required date:
    1. Check the database for errors and fix them if there are any
    2. If the SH4 version is lower than 4.107.362, upgrade it to this version or later
    3. Make a backup of the working database. The original database will become unavailable in SH4.
    4. Copy the shv4cut2.exe file from the upgrade file package to the folder containing the SH4 client
    5. Run the app:
    6. Indicate the stocktaking date:
      • If no data is specified, in the morning of which the balance is generated, the current balance is used and receipt notes are created for the date preceding the current date. All other documents will be deleted.
      • If the date is indicated, receipt notes are generated for the date preceding the specified date.
    7. Specify the correspondent for whom Opening balance receipt notes will be generated
    8. Check the box if you need to process secondary delivery notes
    9. Press Start Processing. The system will warn you about changing the SH4 database structure. Press Yes to create a database for SH5.
    10. When the operation is completed, the system will offer to make a backup for further upgrading. Press Yes.
      A backup can be made later via the Sdbman.

...

Expand
titleThe solution is to compare the existing UOMs with the basic settings in the created Store House 5 database and restore the base.
  1. Open the Sdbman app and log in
  2. Go to Maintenance > Execute procedure
  3. Select the shsrv64.dll library:
    1. In the window that appears, double-click with the left mouse button in the Library field
    2. In the next window, go to the StoreHouse 5 installation folder and open the Server folder
    3. Select the shsrv64.dll file
    4. Click Open

  4. In the Procedure field, enter MUnits and click Execute

  5. In the table that appears, take the values ​​from the first column for G, Liter and Portion

    In a specific case, G — 0, Portion — 2, Liter — 4
  6. Next, in the Procedure field, enter SetAlcMUnit. If an error occurs, click OK
    Fill in the table in accordance with point 6:
    • in column 206#10 enter a value for Portion. In our case, it is 2
    • in column 206#20 enter a value for G. In our case, it is 0
    • in column 206#30 enter a value for Liter. In our case, it is 4
      Click Execute

  7. On the parameters tab, you can see which parameters the units of measure refer to:
    • Object 206#10 — Rid UOM Liter
    • Object 206#20 — Rid UOM G
    • Object 206#30 — Rid UOM Portion
  8. To test the parameter changes, in the Procedure field, enter ShParams and click Execute.
    In the table that appears, you will see the specified values:
  9. In the Procedure field, enter RebuildB and click Execute
  10. Make a backup of the already fixed database:
    1. Go to Maintenance > Backup
    2. Click Yes in the confirmation window

      After a while, a message about the successful backup of the database will appear 
  11. Run the ShUpg utility. Fill in the required fields for restoring and upgrading the database.
  12. Then click Restore and upgrade StoreHouse db

  13. The upgrade procedure will start.
    The Operation completed successfully message indicates a successful upgrade.

...