Need closed ar report for the past 6 months, please help.
The aged trial balance>fully paid transaction below shows all open and closed, how to eliminate the open ones.

THANK YOU
Need closed ar report for the past 6 months, please help.
The aged trial balance>fully paid transaction below shows all open and closed, how to eliminate the open ones.

THANK YOU
Hi Devi.Yonasis,
uncheck the "customers with a Zero Balance" option..
Regards,
DCrampton
Use the Customer Transactions report instead.
If its unchecked, the report will not include any closed items belong to zero balance account currently. And the report still shows open items, instead of closed items only.
Tried. Report also include the open items. I only need the closed ones.
OK.. sorry. I was assuming when you were running the Aged Receivables, you wanted to just see your open receivables.. but instead it's the reverse of that.. you don't want to see your aged receivables.. you essentially want to only see invoices that were paid.. I'm not sure if there is a report that strictly shows that.
so if a customer has had several invoices (say, they have 10 invoices in the year, 9 of which have been paid).. you want to show only the 9 invoice totals with their applied payment and not the 10th invoice that wasn't paid?
I think you'd need to customize the report and setup a record filter..
the standard reports (be it the aged receivables, and customer transactions) will always by default include open receivables.
Correct! is there anyway to customize the report or setup the filter? I saved the report to excel but it requires so much manual edit. Thank you.
*Community Hub is the new name for Sage City