jmcfarland
Member since
05/10/16
Points: 400

1/18/2019 1:53:23 PM

A/P Distribution to GL - when using Intercompany

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

On the forum today, a user asked:

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?

My query for that is below
4Penny.net
Version: All
Section: 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
3