Open topic with navigation

Import sales and purchase accounts

To use import account

Within Sales or Purchase Ledger: 

Open: Utilities > Import > Import Accounts.

1. Choose to:
   • Validate records only, to just check the import file.
   • Validate and import records, to both check the import file and apply the data to the Sales Ledger.
2. Specify the account Default values, if required.
• Nominal code
• Payment terms
• Account history (Keep transactions for)
• Country code
• Payment group (purchase accounts only)

If you leave these values blank in the import file, the specified defaults you now specify are automatically applied to the imported account records for you. This can save you time when preparing the import file.

A report is generated , listing the records which imported successfully during import and those which failed. Use the report to identify problems.

3. Select Ignore Invalid Analysis Code to import analysis codes and values that do not exist in Sage 200. The codes will be imported in one of the following ways:

   • If the value does not exist in Sage 200, and the analysis code allows free text, then the value is imported.
   • If the value does not exist in Sage 200, the analysis code does not allow free text and the code is mandatory, the default value is used on the account.
   • If the value does not exist in Sage 200, the analysis code does not allow free text and the code is not mandatory, a blank value is used on the account.

   Clear this option to report invalid analysis codes and values on the error log. The analysis codes and values will be imported in one of the following ways:

   • If the analysis code does not exist in Sage 200, it is not imported.
   • If the value does not exist in Sage 200, the value will be imported if the code allows free text.
   • If the value does not exist in Sage 200 and the code does not allow free text, the value will not be imported.
4. Click OK and specify the file path.

Go to top