Language:

HansaManuals

Introduction to Settings in the System Module
Access Groups
Active Users
Auto Actions
Backup Settings
Bank Holidays
Base Currency
Base Currency Rates
Cloud Security
Company Date and Numeric Format
Company Info
Configuration
Conversions - Master, Conversions - Accounts and VAT Codes
Conversions - Master, Conversions - Activity Types
Conversions - Master, Conversions - Contact Classifications
Conversions - Master, Conversions - Contacts
Conversions - Master, Conversions - Currency Codes
Conversions - Master, Conversions - Items
Conversions - Master, Conversions - Locations
Conversions - Master
Conversions - Master, Conversions - Suppliers
Conversions - Master, Conversions - Tags/Objects
Conversions - Master, Conversions - Users
Countries
Countries Regions
Currency Round Off
Days and Months
Departments
Discount Options
Display Groups
Exchange Rates Settings
Form Settings
Global Locking
Global Warnings on UnOKed Records
Internet Enablers
Journaling
KPIs
Languages
Locking
Locking Exceptions
Nature of Business
Number Series Defaults
Opened Record History
Optional Features
Password Security
Printers
Remote Backups
Reporting Periods
Round Off
Sales Groups
Single Functions
Special Days
Styles
Sub-ledger Control Accounts
Task Manager Access
User Warnings on UnOKed Records
Values in Text
   - Header and Card 1
   - Card 2
   - Including Amounts in Words in Forms
   - Fields that use the Values in Text setting
VAT Reg. Number Masks
Weeks

Tutorials for Standard Accounts

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: