I just noticed that my TranGLC table does not relate to tables after PODetail. Where it use to link to PORel, Receiving, Project, etc, it no longer has the “related to” for any table after POdetail alphabetically. Is anyone else aware of this issue? I am getting zero help from service.
All I can offer you is the TranGLC Map
https://epiusers.help/uploads/default/original/2X/a/a91b446efcd9fc6a5819e0340600ca05acc1a7c3.xlsx
So if you make a simple BAQ for the TranGLC table, grouping by “RelatedTo”, and throw in a SortBy “RelatedTo”
what do you get?
Hmmm … Mine don’t go past PORel either. (not that I think that is wrong)
I believe TranGLC records are only created when GLControls are used. So you wouldn’t see any records for tables that aren’t being used for GLC.
For example, we’ve got WAY more than 200,000 PartTran records, but only the ones that have some sort of GLC end up creating a TranGLC record. (typically PartClass which overrides the inventory GL account for us)
So double check that any GLC’s that you think should be firing, are actually doing what you expect.
True, might be just that they don’t have any other records.
What are you trying to do here? The RCVDTL will relate to PARTTRAN records which should relate to TRANGLC records. That is how you would trace it through. RCVDTL does not get posted the related PARTTRAN records is what gets the posting if I am not mistaken. You tie it together by sysdate, systime, and trandate related to key1 key2 and key3 in TRANGLC I think.
Further info:
TranGLC won’t have every PartTran item, for it to be posted to TranGLC there has to be a PartTran.ExtCost value. Zero cost items and such won’t show up, even if they have a GL code somewhere. I found this out when troubleshooting average cost jobs, the MTL-STK transactions don’t show up if the cost in the job was totally relieved.
Also make sure you run the COS/WIP capture process if you think something should be on TranGLC but isn’t. !! Consult your accounting department before running this in your live environment !!