90
how can i print statements that will include the original amount, applied amount, and that invoice balance amount. i do not want the far right column to continuously add the outstanding totals, line by line. i want the total owed on the last line.
*This post is locked for comments
Are you a balance forward or open item firm?
Are you purging fully paid items to history?
This type of report can be generated but I recommend doing it in SSRS. You also need a VERY GOOD understanding of the tables with the Open Items and Apply Tables relationships. While it is too detailed to go into here (or I would), we have that information in our Information Flow and Posting manual. Check it out on our website.
You will need to list on your report any invoice, and then for those invoices, any related adjustments (payments, debits, credits) that are linked to the invoice through the Apply Table entries.
#1
André Arnaud de Cal...
292,489
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
