Home Page link  

Date Account Opened Query

  
Groups | Search | About
User Password
Register Now! Lost Password?

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Date Account Opened Query A 08-01-2006
Posted by A on August 1, 2006, 2:44 am
Please log in for more thread options
 So, I can pull up the first invoice from every customer I have and the date
on it is essentially the day the account was opened.

Is there any way for me to generate a report that will simply contain the
info for the first sale for every customer? I would, of course, filter out
all the info except for the date and use this to determine my account
growth over the course of a couple of years.

My plan is to take this data into excel and make a chart showing monthly
account gropwth over a 2 year period.

TIA

Andrew

Posted by Peter Saxton on August 2, 2006, 9:04 pm
Please log in for more thread options
>So, I can pull up the first invoice from every customer I have and the date
>on it is essentially the day the account was opened.
>
>Is there any way for me to generate a report that will simply contain the
>info for the first sale for every customer? I would, of course, filter out
>all the info except for the date and use this to determine my account
>growth over the course of a couple of years.
>
>My plan is to take this data into excel and make a chart showing monthly
>account gropwth over a 2 year period.
>
>TIA
>
>Andrew

List all invoices and sort them by customer and invoice date and
export to excel and delete all invoices except the first one for each
customer.

--
Peter Saxton from London
peter@petersaxton.co.uk

Similar ThreadsPosted
reports query February 5, 2007, 2:36 pm
Query regarding payment of bills March 31, 2007, 8:21 am
Chart of Accounts Query... January 28, 2008, 4:04 pm
941 Out-of-Date October 11, 2006, 9:46 am
941 Out-of-Date October 11, 2006, 9:50 am
Changing a date September 8, 2006, 8:35 pm
item Date March 3, 2007, 11:43 am
date format November 7, 2007, 12:06 am
Invoice date due won't update December 22, 2007, 3:10 am
How change default "bill due" date? September 28, 2006, 7:42 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap