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