GL Export for DMT

Epicor ERP 10
1

Our accounting Department made a lot of GL changes. I would like to pull the data and use DMT to put it back in when I restore the DB.

They added GLs to the following but I know it is not in those tables…
Part Class
Product Group
Reason Code

I know there are new Segment Values and GL Account and GL Control Codes…

I guess I need to know what order too.

2

GL Account
GL Control Codes
Then… PartClass/Reason/etc.

3

You trying to just recreate the GL changes, including new GL controls?

Do you have a good understanding of GLC? It can be confusing to wrap your head at first.

One thing to let the accounting folks know, is that introducing a new GLC can leave dollars orphaned.

For example, if a Part Class has a GLC added to it that affects the inventory account, existing QOH is in the Inv GL, but future trans will CR/DB the new acct specified by the GLC.

  1. Inv acct (1230-00) has $10,000 in it.
  2. Part XYZ (has no Part Class GLC) and accounts for $1,000 of Inv value.
  3. XYZ’s part class is changed to use acct (321-00)
  4. All QOH of XYZ is issued.
    a. Acct 321-00 is CR $1,000. And is understated by $1,000
    b. Acct 123-000 remains at $10,000. And is over stated by $1,000

After the GLC change, a JE should have been done for the 1,000 between 123-00 and 321-00. Before any use of that part happened.