The General Legder Code Import allows GL accounts to be imported from a CSV file into Microsoft Dynamics GP; it allows the codes to be imported into multiple companies from one CSV file reducing the need for running it multiple times.
The order of the columns in the file are preset, with the following order required:
The accepted values for the Posting Type are:
- Balance Sheet or BS or 0
- Profit and Loss or PL or 1
The accepted values for the Typical Balance are:
- Debit or 0
- Credit or 1
If any other values are supplied, the code will be rejected with a warning.
Once you have the data in the required format, the import is available from the menu in Microsoft Dynamics GP ():
use the lookup to select the file, mark the First Row Contains Headers checkbox, if required, and click the process button on the action pane:
The import will process and report the number of successful and total rows attempted:
In the same location as the import file, with the same name but with the extension of rjt, an error log containg the accounts with an error along with the error reason will be created:
All of the successful accounts will have been created in the company designated on the import file; the Intercompany ID column is option; if it is not supplied, the accounts will be loaded into the company into which the user is logged.