RETAIL SALES RANKING REPORT

[MAGPIE]

I would like to run a retail piece sales ranking report (Reynolds system) to be used to set up bins close to the retail counter. I read the thread "R&R Report Generator" from 2002 that had some good sample reports in it, the closest being one that lists part numbers sold in each transaction. But, you still have to add up the total pieces sold on retail counter tags per month by hand. Has anyone come up with a better solution since then, maybe using ERALINK to pull info from different files? Thanks!

[AKTOYPM]

PROD.MASTER
SORT
12 MONTH HIST~
D
12 MONTH HIST~ GREATER THAN OR EQUAL <<QTY>>

PART-INFO;BIN1;QOH;QAVL;12 MONTH HIST~

If you want you can add reorder point and best stocking leverl so you dont end up cramming parts in that are in transit.

[AKTOYPM]

My bad that wont narrow down retail only.
I guess you could have reynolds add 12 month hist~ to the invoice file.
And write it in that file.

[jimt01]

aktopm didnt answer the question but i like the report anyway

Jim