Hi,
I need to get a report with following columns.
Payment date |
Payment amount | Invoice no. | Invoice amount | Invoice distribution codes | ||
Thanks
*This post is locked for comments
Hi,
I need to get a report with following columns.
Payment date |
Payment amount | Invoice no. | Invoice amount | Invoice distribution codes | ||
Thanks
*This post is locked for comments
Rahul,
You could combine some views I have posted on my blog to create this report:
Payables Apply information: http://victoriayudin.com/2008/10/22/sql-view-ap-apply-in-gp/
Payables GL distributions: http://victoriayudin.com/2008/11/28/sql-view-to-show-all-gl-distributions-for-ap-transactions/
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156