Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Forum

Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
  #1  
Old 06-16-2004, 12:45 PM
bettygustafson bettygustafson is offline
Junior Member
 
Join Date: Jun 2004
Location: CT
Posts: 1
Customer Balance Report

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.
Reply With Quote
  #2  
Old 06-16-2004, 04:23 PM
Oleg Oleg is offline
Registered User
 
Join Date: Sep 2003
Location: Phoenix, AZ
Posts: 1,225
Send a message via Skype™ to Oleg
Run the report, go to Modify Report button, click on Adcanced and chose options you want.
__________________
Oleg | Certified QuickBooks Pro/Premier/Enterprise/ Point of Sale ProAdvisor
(800) 609-0788 | http://qbooksconsulting.com/
VERY SIZABLE DISCOUNTS ON QUICKBOOKS ENTERPRISE AND POINT OF SALE SOFTWARE AND HARDWARE!
Reply With Quote
  #3  
Old 04-22-2011, 07:20 AM
mare123 mare123 is offline
Registered User
 
Join Date: Apr 2011
Posts: 5
Just need current customers

I'm having the same problem. I can not build a report without having really old customers come up on the report. Any suggestions?:
Reply With Quote
  #4  
Old 04-23-2011, 02:10 AM
Joe Williams Joe Williams is offline
Registered User
 
Join Date: Jan 2006
Location: Oklahoma
Posts: 8,847
Goto Modify and then click the Advanced button. Click the Non-zero option for 'Display Rows' and 'Display Columns'.
__________________
Joe Williams
joewilliams@wavelinx.net
Piedmont, Ok
Reply With Quote
  #5  
Old 04-25-2011, 05:32 AM
mare123 mare123 is offline
Registered User
 
Join Date: Apr 2011
Posts: 5
Don't have those options

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.
Reply With Quote
  #6  
Old 04-26-2011, 03:51 AM
Joe Williams Joe Williams is offline
Registered User
 
Join Date: Jan 2006
Location: Oklahoma
Posts: 8,847
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).
__________________
Joe Williams
joewilliams@wavelinx.net
Piedmont, Ok

Last edited by Joe Williams; 04-26-2011 at 03:54 AM.
Reply With Quote
  #7  
Old 04-27-2011, 07:39 PM
CourtNg2011 CourtNg2011 is offline
Registered User
 
Join Date: Apr 2011
Posts: 3
Reply to question: Customer Balance Report

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
Reply With Quote
  #8  
Old 04-28-2011, 05:31 AM
mare123 mare123 is offline
Registered User
 
Join Date: Apr 2011
Posts: 5
Thanks for getting back to me. I tried that but it doesn't bring up the detail, just the summary. Very odd. Thanks again.
Reply With Quote
  #9  
Old 04-29-2011, 02:06 AM
Joe Williams Joe Williams is offline
Registered User
 
Join Date: Jan 2006
Location: Oklahoma
Posts: 8,847
I do not think we ask, so what version of QuickBooks are you using.
Example: Windows US version QuickBooks 2010
__________________
Joe Williams
joewilliams@wavelinx.net
Piedmont, Ok
Reply With Quote
  #10  
Old 04-29-2011, 05:33 AM
mare123 mare123 is offline
Registered User
 
Join Date: Apr 2011
Posts: 5
Quickbooks Pro 2011.
Reply With Quote
  #11  
Old 05-02-2011, 08:54 AM
Deidre56 Deidre56 is offline
Registered User
 
Join Date: Aug 2005
Posts: 895
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.
__________________
~Deidre~

Senior Accountant
Quickbooks Proadvisor
Reply With Quote
  #12  
Old 05-09-2011, 06:24 AM
mare123 mare123 is offline
Registered User
 
Join Date: Apr 2011
Posts: 5
OK, thanks again for everyone's help. I appreciate it.
Reply With Quote
Reply

Bookmarks
Bookmark and Share
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

Forum Jump


All times are GMT -5. The time now is 07:37 PM.


 

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.
You Rated this Thread: