I can provide some steps to exclude zero balances from the Supplier Balance Detail report, @Havana.
You can start by customising the report and filtering the A/P Paid drop-down to Unpaid. In this manner, you'll only see open bill balances.
Let me show you how:
- From the Supplier Balance Detail report window, select Customise.

- Go to the Filter section.
- From the A/P Paid drop-down, select Unpaid.
- Once done, hit Run report.
Well done! You can also memorize this report by clicking the Save customisation button and save it. Then, you can just run this under the Custom reports tab in the Reports menu.
Additionally, I've included some articles that can help you with running reports. Especially when you want to send them to your email or export them to excel to include some data, filtering, and remove some columns:
Always remember you have us here if you other concerns about running reports. My peer and I will love to help you. Take care always!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
