[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1163
  • Last Modified:

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?
0
Daren Anderson, MSIS
Asked:
Daren Anderson, MSIS
  • 4
  • 2
  • 2
2 Solutions
 
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
 
John HurstBusiness 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
 
Daren Anderson, MSISAuthor Commented:
thinkpads:
      Was there supposed to be more to your comment?  columns for D?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
John HurstBusiness 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
 
John HurstBusiness 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
 
Daren Anderson, MSISAuthor 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
 
John HurstBusiness 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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

  • 4
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now