QuickBooks - A/R Summary

I have a customer that when they print their A/R Summary in Quickbooks 2006. it prints zeroes for a lot of the customers.  Is there any way to modify the report so those customers would not print on this summary report?
Daren Anderson, MSISPresidentAsked:
Who is Participating?
 
JohnBusiness Consultant (Owner)Commented:
For my QuickBooks Accountant Edition V2009 (I only have V2008 and V2009 on my Vista machine), I have the following AR reports:
1. A/R Aging Summary
2. A/R Aging Detail
3. Customer Balance Summary
4. Customer Detail Summary

I have no other A/R Summary Report

For 1 and 2, ajames is correct about the advanced setting. But in these two reports, you can change the aging to reduce the number of columns and be default, zero rows are not shown

For 3 and 4, the advanced setting is there as I described.

Maybe these ideas will assist.  .... ThinkPads_User
0
 
ajames9000Commented:
You need to open the report in question, there should be a button to modify report.  this is for Quickbooks 2008; however, if I remember correctly, it should be the same for 2006.

Once in the report modification section, click on the filter tab.

On the right hand side  you  will see a box with different filter options, click on "amount"

click on the >= radio button and place 0 in the box beside it.

This will show only accounts that have a balance owing.  the problem is that if an account is in a credit balance it will not show either.   Not sure why they do not have a <> selection so only the zero balances disappear.
0
 
JohnBusiness Consultant (Owner)Commented:
Also, when in the report, click on Modify Report, then click on the Advanced Button. In there are columns for Display Rows and Display Columns. Check in Rows that Non-Zero is checked and in Columns that Active is checked. See if that might help you.
..... ThinkPads_User
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Daren Anderson, MSISPresidentAuthor Commented:
thinkpads:
      Was there supposed to be more to your comment?  columns for D?
0
 
JohnBusiness Consultant (Owner)Commented:
Hi CFProcessMgr - No, the advanced section applies to all columns. It is a bit context-oriented in that different reports will bring up different options. It may not have displayed the way I noted for your particular report. All you can do is look and see if any option there affects your report.
..... ThinkPads_User
0
 
ajames9000Commented:
The option Thinkpad is referring to is available in the financial statement reports; however, it is not available in the AR summary report.  

Your best option is to use the filter option I provided above or do nothing with the reports.

I guess you could also export the summary report to excel remove the zero lines and then print it if you would like.

0
 
Daren Anderson, MSISPresidentAuthor Commented:
Just to clarify, I was talking about the A/R Aging Summary.  I have 2007 and the only option under Advanced settings is Open Balance/Aging and the choices of Current and Report Date
0
 
JohnBusiness Consultant (Owner)Commented:
Thanks for the clarification. That is what I thought, but wasn't sure. There is an option in that report in two places: (1) in the Modify Report tab: days per aging and how many days and (2) at the top of the report itself, the same two variables. These will allow you to reduce the columns. The advanced settings will not help here (as ajames noted too).
... ThinkPads_User
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.