Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Accounting Periods
  2. G/L Accounts

  3. CMC Extract Program
  4. GL Year End Balance
  5. 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

Image Added

  1. 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.

Image Added

After fixing the errors go to the next step, which is insert data.

...

9. Click Insert Data.
10. Access ERP and perform the Recalculate GL Balances function. 


You would also need to compare GL Trial balance reports from ERP to CMC and then send both reports to customer for sign off on that period. Below is step by step to get GL Trial Balance report from CMC.

Run CMC program.

Image Added

Select option 1 for GL

Image Added

Select option 31 for Balance reports.

Image Added

Select option 01 for Trial Balance

Image Added

Provide period data that you want the report for.

Image Added

Select default options for rest of the prompts.

Image Added

Image Added

Image Added

Save the report.

Image Added