by chartle » Fri Jul 11, 2003 10:23 am
Try this...
REPORT NAME = PARTS SALES
FILE NAME =PROD.HIST
REPORT TYPE = SORT
ENTER FIELDS TO SORT BY = MK;CTRMN
SELECT SORT SEQUENCE = A
FIELD1 = TRAN
CONDITION1 = EQUAL
VALUE1 = SLS""CM""VOID""RV
AND/OR1 = AND
FIELD2 = TRNSDATE
CONDITION2 = EQUAL
VALUE2 = <<TRNSDATE>>
ENTER COLUMN HEADINGS[104]
MK;CTRMN;INV#/PO#;PART-NO;+QTY;+EXT-COST;+EXT-SALE;+GROSS~;GROSS PCT~;TRAN;TC;TRNSDATE;PARTS PRICE LEVEL;
SERVICE PRICE LEVEL
ENTER DESCRIPTION TOTAL LINE = BLANK
PRINT TOTALS ONLY = N
ENTER FIELD(S) TO BREAK ON = MK;CTRMN
CHANGE PAGE AT EACH BREAK (Y/N) = N
ENTER SPECIAL FORMAT (Y/N) = N
When you print this report duke, it reports your sales for a specific date (or you can change CONDITION2 above to equal GREATER THAN OR EQUAL and get a sales in the current month greater than a given date and it reports by make (if you have more than one) and then by counterman. The last two fields are the parts price level code and the service price level code. This will show you where your parts have sold. We have found that alot of times the price level will be blank and have discovered that these are the standard price code levels enter for retail, warrranty, and internal (the second level of price codes you see when coming out of price level program 2565.
Also, very helpful with this 6910 report is the GROSS PCT~ field. This will allow you to see your gross profit per sale on each part. If you want to rank your sales by GROSS PCT~; you can change your FIELDS TO SORT BY to equal GROSS PCT~ and BLANK OUT the ENTER FIELD(S) TO BREAK-ON and you will now get this report by your lowest gross profit percentage to your highest gross profit percentage.
I hope this works for you.
Chuck Hartle'