...
- Accounting Periods
G/L Accounts
- CMC Extract Program
- GL Year End Balance
- Populate GL Conversion Table in ERP (part of GL template: you will need old cmc gl account, new erp gl account, new division code, ERP Gl account ID) OR you can make isUseGLConversionDivision = 0 in ClientSetting table in ERP, this will make the process use glacctxref field in glacct table.
Step-by-Step Guide
- Make sure year end GL balance are imported and GL account conversion table is populated prior to running the steps below for rest of the accounting periods. Access the CMC Extract program.
...
If there are any errors, they will display in a pop-up message. Most of the time the errors are of missing map for GL account.
Selecting the row in the grid (bottom grid) where GLSeqNo field has -1 value will highlight the top grid rows that has errors.
After fixing the errors go to the next step, which is insert data.
...