Customer Balance Report

[bettygustafson]

When I print a Customer Balance Summary it lists every customer I have ever had..... including zero balance customers and inactive customers. Is there a way to only list active customers or customers with an actual balance? Thanks.

[Oleg]

Run the report, go to Modify Report button, click on Adcanced and chose options you want.

[mare123]

I'm having the same problem. I can not build a report without having really old customers come up on the report. Any suggestions?:

[Joe Williams]

Goto Modify and then click the Advanced button. Click the Non-zero option for 'Display Rows' and 'Display Columns'.

[mare123]

Hi,

Thanks for the response, but, under modify, advanced my only options are "All or In Use" and "Current or Report Date".

Any other suggestions?

Thanks again.

[Joe Williams]

If you are running a Detail report you will not have the option for the "Display Rows" or "Display Columns" that have the option for "Non Zero".
The DETAIL type report will display all transactions for the period for the customer/vendor even if their total balance is 0.00 (fully paid).

[CourtNg2011]

Hi,

I think you should go to "Modify Report" from the "Customer Balance Report" form. Then, click on the Advanced command button. From there, you can select advanced options such as "display row" with non-zero; "display column" with non-zero.

Courtney Nguyen

[mare123]

Thanks for getting back to me. I tried that but it doesn't bring up the detail, just the summary. Very odd. Thanks again.

[Joe Williams]

I do not think we ask, so what version of QuickBooks are you using.
Example: Windows US version QuickBooks 2010

[mare123]

Quickbooks Pro 2011.

[Deidre56]

As Joe said, you are not getting the options the others are because you are looking at the Customer Balance Detail. To get the options under the Advanced button you have to be running the Customer Balance Summary.

[mare123]

OK, thanks again for everyone's help. I appreciate it.