Share
ReportIs there a way to create a payables report for a time period that includes the GL account(s) that were posted to the GL? Version GP 2016
*This post is locked for comments
You’re offline. This is a read only version of the page.
Is there a way to create a payables report for a time period that includes the GL account(s) that were posted to the GL? Version GP 2016
*This post is locked for comments
Elizabeth,
I believe the general ledger tables will have all of the information you need. The Vendor, document number, GL accounts, everything.
I caution against using any report that gets the GL accounts from the distribution tables in the subsidiary ledger. Those tables merely tell you the accounts that were presented to the GL at the time the payable was posted. It does not reflect the actual accounts that were used. The GL accounts could have been changed before it was posted. If they have been, those changes are not reflected in the subledger distribution tables.
Kind regards,
Leslie
Elizabeth,
Victoria Yudin has a very useful site, with a ton of valuable information. As I suspected, Victoria has a SQL Script, which can be used to create a View, which could then be used as a source for a report designed in SQL Server Reporting Services (SSRS) or SmartList Builder, etc.
victoriayudin.com/.../sql-view-to-show-all-gl-distributions-for-ap-transactions
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,401
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
