possum wrote:I run this every few months and rank top customers down. We have a variable discount structure and I can review activity and price levels. Lots of good info, adjust as you see fit!~
REPORT NAME YEAR TO DATE TOP WHOLESALE PARTS CUSTOMERS
FILE NAME CUST.HIST CREATOR Pre 10.0 release
REPORT TYPE SORT MODIFIED BY xxxxxxxx LAST SAVED 02/22/2011
ENTER FIELD(S) TO SORT BY YTD-GSLS;PYR-GSLS
SELECT SORT SEQUENCE (A=ASCENDING D=DESCENDING) D
LAST PRINTED 08/10/2016
ENTER SELECTION CRITERIA
FIELD CONDITION VALUE AND/OR
YTD-GSLS >= 200 OR
PYR-GSLS >= 200 AND
PL # 1 AND
PL # ""
ENTER COLUMN HEADINGS[115] CUST#;CNAME-LAST-ACT;YTD-#DOC;YTD-GROSS;YTD-%;PYR-GR
OSS;PYR-%;PL
Users browsing this forum: No registered users and 35 guests