I have made a number of updates to my SQL view to show all GL distributions for AP transactions since I first published it. Some of these were in response to comments asking for additional fields, others were added when I came across new data to test with. Rather than publish another post with the latest revisions, I have updated the code in my original blog post, but I wanted to let everyone know it’s there. Some of the updates are:
- Added Due To and Due From distribution types for anyone using Intercompany transactions.
- Added Realized Gain and Realized Loss distribution types for Multicurrency transactions.
- Added Currency ID, Exchange Rate and Originating Debit/Credit fields.
- Added Distribution Reference, Batch ID and Transaction Description fields.
- Added Voucher Number.
As always, if you find any issues or would like any additional updates, please let me know.
There are also enough Payables SQL scripts that I have moved them to their own page. The page can also be accessed from the main navigation menu on this blog under GP Reports and on my GP Reports page.