Print Receivables Statements

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Michael Burk 330 on at

Like (0)

Report

In the Print For section, you may also want to exclude Zero Balance Due and No Activity in addition to Exclude Fully Applied Payments.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Michael,

Thanks for that.. I've tried that combination but this gave me "No records to show"

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I'm having the exact same problem. What combination of parameters will create a customer statement that only shows documents with balances?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Heather Roggeveen 9,146 on at

Like (0)

Report

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

Was this reply helpful? Yes No