PDA

View Full Version : Inventory Sales by Customer report


peachtreejack
08-14-2009, 03:01 PM
I am using PT 2008 Complete Accounting. We have a customer requesting that we supply them with a list of all the items they have ordered from us in the past two years. Using the Reports feature, I can get a report of dollars in sales to this customer, and I can get a report of all inventory items and how many our company has sold overall. What I cannot seem to find is a report format that will tell me what particular inventory items a particular customer has ordered. The Inventory reports and the Customer reports do not seem to be tied together in any way. Help or ideas are appreciated.

rick Prindivill
08-14-2009, 07:36 PM
You will need to use Crystal Reports to extract the requested data. The good news is that this report has already been written for Peachtree. Here is link to such a report that allows prompts for Customer ID Range and Date Range. This report seems to be consistent with your needs. http://www.crystalforpeachtree.com/item_sales_by_item__customer___date_range.pdf

peachtreejack
08-20-2009, 06:56 AM
Do you suppose www.crystalforpeachtree.com is still in business? I have sent two "contact us" inquiries through their web site, with no reply. I could not find a telephone number anywhere on their site. They offer a "live help" button, but it goes to a dead page. This looks like what I need and I would like to order it, but so far they are too difficult to contact.

CraigFL
08-20-2009, 08:28 AM
You can get this information customizing the INVOICE REGISTER . You may need to manipulate in EXCEL to get it in a better format.

rick Prindivill
08-20-2009, 08:26 PM
The first page of the www.crystalforpeachtree.com contains the phone number 800-780-0700 (listed 2X). The same front page list an email address of info@crystalforpeachtree.com. The website may need to be updated but these Crystal Report people are definitely alive and well.