A program is available to Import General Ledger Account Balances from multiple data accounts into one consolidated data account. Each location in the consolidated data account will represent All locations from another data account. This requires a setup to map the location numbers to the data accounts, created from TCL in:

MASTER ACCOUNT.IMPORT.SETUP

Once the setup is in place, the program can be used.

                                       Loc Account         Import                                        

Import Location from Account        :        1 PM                        Y

Accounting Period or Year        :        2 PM.VMI                Y

Import Budget Information        :

Enter <I> to Import                :

Note that the budget import will not be limited to the requested year or period that is being imported. All budget data for all G/L account numbers will be brought over for all valid accounting years present in the consolidated data.

Users cannot change the location number or data account, they can only indicate which locations to import, and the Accounting Period or Year to import. To initialize the account balances, the user should specify which year-end to import when running for the first time. Thereafter, each accounting period would be imported to keep the consolidated account up to date.

The program validates the account numbers first, checking Description, Account Type, and Parent Accounts. They must all match the consolidated account or an error report will be displayed. The import will create journals, which must then be posted or reversed if necessary.

This program can be setup in the Custom User Menu.