Language:


Conversions - Master, Conversions - Locations

This page describes the Conversions - Master and Conversions - Locations settings in the System module.

---

The Conversions - Master and Conversions - Locations settings together allow you to change the Location Code in a Location record. For example, you can change Location Code "WHS" to "WHS_1", and the Location Code in all transactions such as Quotations, Orders, Invoices, Deliveries and Goods Receipts will be changed as well. Follow these steps:

  1. Change to the System module and open the Conversions - Locations setting. Enter each pair of old and new Location Codes as shown in the illustration below. In the example illustrated, we will change "WHS" (the old Location Code) to "WHS_1" (the new Location Code):

    The new Location Code does not have to exist in the Locations setting. In this example, if "WHS_1" is not an existing Location, Location "WHS" will be changed to "WHS_1" by the conversion process and so "WHS" will no longer exist. If "WHS_1" is an existing Location, Location "WHS" will be deleted. In effect, this will mean that you are merging "WHS" with "WHS_1".

    Although it is possible to merge Locations as just described, it is not recommended that you do so. The FIFO/LIFO queues for the Items in the merged Location will not be correct, and the Weighted Average setting will be corrupted. This will mean that the valuation in the Stock List will not be correct.

  2. Remaining in the System module, open the Conversions - Master setting and select the Convert Locations option:

  3. Make a text or timed back-up of your database and quit Standard ERP.

  4. Remove the Standard ERP database file (named "Hansa.HDB") from the folder or directory containing your Standard ERP application.

  5. Launch Standard ERP again. Because there is now no "Hansa.HDB" file, the 'Welcome to Standard ERP' window will appear. Select the [Restore from Backup] option.

  6. When the 'Import files available' window appears, choose to import the back-up file that you created in step 3.

  7. During the import process, Location records will be updated as required. In the example, the Code of Location WHS will be changed to WHS_1. References to Location WHS will be replaced with WHS_1 in all records (including Sales and Purchase Ledger transactions and Stock records).

    The Location and Service Location fields in Person records, the Purchase and Via Location fields in Location records and the Main and Service Location fields in the Stock Settings setting will not be updated.

    The Default Location and Default Return Location fields in the Local Machine setting in the User Settings module will not be updated. This is because the Local Machine setting is stored locally in the databases on each client machine, and the conversion routine is not able to access these local databases.

  8. Return to the Conversions - Master setting in the System module and turn off the option to Convert Locations.

  9. Return to the Conversions - Locations setting and delete everything line by line.
If you have more than one Company in your database, you must repeat steps 1 and 2 above in every Company in which the conversion is to take place. In all other Companies, leave the Conversions - Locations setting empty and do not tick any of the options in the Conversions - Master setting. If you want a different conversion to take place in another Company, enter old and new Location Codes in the Conversions - Locations setting in that Company as necessary, and select the option to Convert Locations in the Conversions - Master setting in that Company as well.

If the Locations setting is shared, you should repeat steps 1 and 2 above in every Company that shares it. For example, if you have three Companies and Companies 2 and 3 are sharing the Locations setting, follow steps 1 and 2 in Companies 2 and 3.

If the Locations setting is shared and is stored in Company 0 (i.e. in the Shared Registers setting in the Technics module, the In Company field is empty), you should again repeat steps 1 and 2 above in every Company that shares the register. Then, follow the procedure described above, but replace steps 5 and 6 with the following:

  1. Launch Standard ERP again. Because there is now no "Hansa.HDB" file, the 'Welcome to Standard ERP' window will appear. Then:

    1. Close the 'Welcome to Standard ERP window using the close box .

    2. You will be prompted to enter a new Company: a Code and Name will be sufficient. Press [Save].

    3. You will be presented with a blank screen: quit Standard ERP and restart.

    4. Repeat steps 1 and 2.

  2. Ensure you are in the System module and use the 'Automatic' or 'Manual file search' import functions to import the back-up file that you created in step 3.
Steps 1 and 2 will cause the old Location Code to be replaced by the new one in every register in the relevant Companies. The new step 5 will cause the old Location Code to be replaced by the new one in the Locations setting in Company 0.

---

Settings in the System module:

Go back to: