Ranked Sales Report

[IsabelM]

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!

 

[ettienne]

Nope, it's not there. Write a report from OESHDT or OESHHD.

 

[IsabelM]

Thanks Etienne. At least I know I'm not crazy.

 

[IsabelM]

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?

 

[ettienne]

Nope

 

[DjangMan]

Crystal reports can pretty much take you through a Wizard to get you that report off of the tables that Ettienne suggested.

 

[IsabelM]

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.