Announcements
Hi All,
Currently I've tried to print customer statements. But in my printed report, it still shows $0.00 amount in Balance column.
I used "Exclude Fully Applied Payments" in Print For options.
Any suggestions why my report still showed me those transactions with $0.00 balance.
Thanks in advance!
Rotchine
*This post is locked for comments
Arman is correct. The Paid Transaction Removal is an important part of month end procedures. It should be done either directly before or directly after you run your statements, depending on the detail you want to show on the statement. The process moves the document status from open to history for all documents that have a remaining balance of zero.
If you want to show only transactions that have a remaining balance as at statement date, then run it before.
If you want to show a customer all their activity for the month (i.e. opening invoices, payments since received and new transactions) then run it directly after.
As well as keeping the statements tidy, it also will assist with making some processes in the system faster e.g. looking up transactions as you can exclude History.
Hope that helps clarify.
Cheers
Heather
The problem is not with the paramaters of your statement bu the status of your transactions. You need to run "PAID TRANSACTION REMOVAL" (Tools>Routines>Sales>Paid Transaction Removal) to convert "open" items to historical items. Below is a video I found on how to perform this routine.
https://www.youtube.com/watch?v=SBu5IgUvnBI
I'm having the exact same problem. What combination of parameters will create a customer statement that only shows documents with balances?
Hi Michael,
Thanks for that.. I've tried that combination but this gave me "No records to show"
In the Print For section, you may also want to exclude Zero Balance Due and No Activity in addition to Exclude Fully Applied Payments.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
