Here's the logic for getting that info for a PO, albeit starting with the TranGLC table first. But you should be able to extrapolate your situation. It's finding those PO Releases using the Suspense Account.
for each TranGLC no-lock where TranGLC.COACode = 'MainCOA' And TranGLC.GLAccount = '9903|000' And TranGLC.RelatedToFile = 'PORel' , each PORel no-lock where (TranGLC.Company = PORel.Company and TranGLC.Key1 = PORel.PONum and TranGLC.Key2 = PORel.POLine and TranGLC.Key3 = PORel.PORelNum ) , each POHeader no-lock where POHeader.OpenOrder = yes and (PORel.Company = POHeader.Company and PORel.PONum = POHeader.PONum ) , each Vendor no-lock where (POHeader.Company = Vendor.Company and POHeader.VendorNum = Vendor.VendorNum ) , each PurAgent no-lock where (POHeader.Company = PurAgent.Company and POHeader.BuyerID = PurAgent.BuyerID ).
for each TranGLC no-lock where TranGLC.COACode = 'MainCOA' And TranGLC.GLAccount = '9903|000' And TranGLC.RelatedToFile = 'PORel' , each PORel no-lock where (TranGLC.Company = PORel.Company and TranGLC.Key1 = PORel.PONum and TranGLC.Key2 = PORel.POLine and TranGLC.Key3 = PORel.PORelNum ) , each POHeader no-lock where POHeader.OpenOrder = yes and (PORel.Company = POHeader.Company and PORel.PONum = POHeader.PONum ) , each Vendor no-lock where (POHeader.Company = Vendor.Company and POHeader.VendorNum = Vendor.VendorNum ) , each PurAgent no-lock where (POHeader.Company = PurAgent.Company and POHeader.BuyerID = PurAgent.BuyerID ).
----- Original Message -----
From: "Keith Mailloux" <keith.mailloux@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, December 29, 2010 6:15 PM
Subject: [Vantage] V9 Invoice Detail GL detail
> Prior to V9 the invcdtl table contained the GL distribution info (div/dept/chart). In V9 that no longer is available (I think). What table and join sequence can provide this info? I can't seem to get a join that works.
>
> Thanks
>
>
> Keith Mailloux
> Fergsuon Perforating
[Non-text portions of this message have been removed]