DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
jmcfarland 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