Link GL control from TranGLC

Epicor ERP 10
1

Is there a way to find the GL control used in a given transaction?
I can see there is a SysGLControlCode column in the TranGLC table, but I cant see how that links out to the GL control.

End goal is to see which GL control users need to edit when a transaction goes to the wrong account.

Brett

2

You might try to link the master table with the GlControlCode.
Something like the below

image
image801×505 23.8 KB

3

Thanks for the reply Prashanth.

We are looking to find how to join from TranGLC to the GLCntrl table. To me it seems like the TranGLC table is a copy of the GL control at the time the transaction occured.I want to know what GL control the copy came from.

image
image946×320 45.9 KB

Thanks
Brett

4

As per my understanding, relationship can’t be established.
TranGlc is more of a transaction table where as the GLCntrl table is bridge to associate GL control code with a master data (warehouse / part class).
I believe this is handled by Posting rule.

5

I was afraid that I might be trying to do the impossible. Thanks for the help.

Brett