V9 Invoice Detail GL detail

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

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


---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]