Skip to main content
Question

A/R Aging List Filter

  • November 20, 2025
  • 3 replies
  • 24 views

KellyDixon
Forum|alt.badge.img+2

I’m trying to filter my list to only show accounts with balances. I have tried the advanced filter with both Greater than 0 and Greater than 1. Still showing accounts with no balance.

 

3 replies

Forum|alt.badge.img+12
  • Employee
  • November 20, 2025

Try just making the filter Open Balance greater than zero. 

 

Otherwise, there are a few other places where you can see this information.  Invoicing → Receivables Tab will have a few options in the drop down.  You’re able to list build here and in the invoices tab as well for invoices with an open balance.  


KellyDixon
Forum|alt.badge.img+2
  • Author
  • New Participant
  • November 20, 2025

I tried the filter for Open Balance greater than zero, it did not remove the accounts with a $0 balance. I also tried to build the list in invoices, it doesn’t show aging (30+, 60+, etc). I ended up downloading the report as an Excel file and manually removing the accounts without a balance. 


Forum|alt.badge.img+12
  • Employee
  • November 20, 2025

You can add the aging days as displays when building an invoicing list or use or build a list in the receivables tab of the invoicing module.  

In invoices, you would use a filter of amount remaining greater than zero OR unpaid balance greater than zero and then display aging days as a display column.  

Receivables tab will give you a few options out of the box, i.e. HSC - A/R Aging, Open Balance.  You are also able to list build here and display the aging days.