Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
lcarness 1/18/2019 9:33:28 AM

A/P Distribution to GL - when using Intercompany

I have an SQL query that shows me the GL distribution for all invoices. But the problem I have is that for invoices that were posted using the Intercompany  functionality, it just shows me that the item was posted to the Intercompany Account, not the GL distribution from the other side of the transaction.

Does anyone know how to get it to return the G/L where the item is posted to in the other company, and not the Intercompany account in the ledger where it is posted?

Any help would be greatly appreciated. 




Version: GP 2013
Section: Dynamics GP, SQL Scripts

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables