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?
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
..... ThinkPads_User
ASKER
thinkpads:
Was there supposed to be more to your comment? columns for D?
Was there supposed to be more to your comment? columns for D?
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
..... ThinkPads_User
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
... ThinkPads_User
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.