Import CMC GL J/E's

Owned by Keith Mangold
Last updated: Jun 13, 2024 by Himanshu Shah
3 min read

Use the CMC Extract program to import Journal Entries from CMC (Aeros Classic).

  • The CMC Extract program ONLY processes CMC G/L data, not the sub ledgers. 

  •  CMC sub-ledgers should be posted in the CMC system before using the Extract program.

Pre-Requisites

  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

  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. 

2. Click G/L Conversion.
3. Specify a Year.
4. Select a Beginning and Ending Period # from the drop-down listings.
5. Specify a Division.
6. Click Load Data.
7. Click Scrub Data.

 

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.

 

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.

Select option 1 for GL

Select option 31 for Balance reports.

Select option 01 for Trial Balance

Provide period data that you want the report for.

Select default options for rest of the prompts.

Save the report.