Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ranked Sales Report

Status
Not open for further replies.

IsabelM

IS-IT--Management
Aug 30, 2010
8
CA
I'm looking for a sales history report for all my customers ranked by sales (so customer who purchased most at the top, customer who purchased least at the bottom). I need it to cover the year to date. I can't seem to find a report that ranks this way in either AR or OE but maybe I'm missing something. Using Sage Accpac 500 ERP (Version 5.5A). Thanks for your help!
 
Nope, it's not there. Write a report from OESHDT or OESHHD.
 
Thanks Etienne. At least I know I'm not crazy.
 
Follow up question: is there at least a report that already exists that totals customer sales so that I don't have to strip out all of their transactions to then sort and filter it in excel?
 
Crystal reports can pretty much take you through a Wizard to get you that report off of the tables that Ettienne suggested.
 
I've never done the crystal reports thing so that's Greek to me but I can at least ask our software guy to walk me through it. Then maybe I can start getting the reports I actually need! Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top