|
|
|
|
|
Navigator > Setup > General Ledger > Chart Of Accounts
Options for setting up a GL Chart Of Accounts. You can:
Import
Load a Chart Of Accounts without having to enter each account individually. Use this to load the standard Chart Of Accounts provided or to load a Chart Of Accounts file created by the Export option (see below).
Import Format |
Select the file type to import:
|
File Name |
Click |
Excel Worksheet |
When the Import Format is Excel Worksheet, select the name of the worksheet to import from. Note: Do not use apostrophes (') in worksheet names, as this can cause problems. |
Errors found during Import are reported when the import completes.
After successful import run Validate Ledger to check the chart.
Delete
Delete the file, including details, transactions and balances, then enter a new Chart Of Accounts.
Warning: You will be prompted to back up your data before running this, as this deletes the GL including all posted transactions, and is not reversible. Restrict permission for this for all Users except the Master User. Permission is found under GL > Chart Of Accounts; set the Permission to a level other than Control to prevent access to the Delete option.
Export
To create a current Chart Of Accounts file, you can copy the COA to be used in another system.
Format |
Select the file type to export to:
|
File Name |
Similar to Import, specify the export file name or click |
The first row and column position must contain the following signature: "MGL13". The remaining items in the first row are ignored for import, and are filled with headings for export.
Columns exported are:
Select File