Skip to main content
April 25, 2022
Solved

Can i exclude zero balances from the supplier balance detail report?

  • April 25, 2022
  • 1 reply
  • 0 views
Original commenter did not share additional details
Best answer by mv32

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:

  1. From the Supplier Balance Detail report window, select Customise.
  2. Go to the Filter section.
  3. From the A/P Paid drop-down, select Unpaid.
  4. 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!

1 reply

April 25, 2022

Hello Havana, 

 

Welcome to the Community page, 

 

Yes you can if you are referring to transactions that were zeroed out. 

HavanaAuthor
April 25, 2022

Can you tell me how please?

mv32Answer
April 25, 2022

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:

  1. From the Supplier Balance Detail report window, select Customise.
  2. Go to the Filter section.
  3. From the A/P Paid drop-down, select Unpaid.
  4. 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!