I need to get Customer Balance Detail report but need to Omit the customers with zero balance. I have over 6000 customers and 80% have zero balance.

Hello there, omar7,

The zero balance is usually caused by an invoice that isn't linked to a payment or credit.

What you need to do is link the invoice to its payment. This is to clear up the zero balance on the Customer Balance Detail report.

Let me show you how to accomplish this:

1. Click the Create (+) icon at the right top.
2. Select Receive Payment under Customers.
3. For the Payment Date, enter the date you'd like to use for an invoice closing date for your reports.
4. Under Outstanding Transactions, mark the invoice.
5. Under Credits, mark the payment or credit memo.
   
6. Click Save and close.

Another way of omitting the zero balance is to export the report to Excel. Then, delete the line item from there. Please see the attached screenshot below for your guidance.

You can also run the A/R Aging Summary report if you want to find out which invoices are overdue and how long.

Should you need anything else, please let me know. I'd be glad to help you out.