Report # 1: Gross Profit By Source
This report will display the gross in dollars. To get the percentage, divide the total gross dollars by the total sales dollars (or export to Excel to do this automatically).
This report uses the transaction files so you will need to change the file for the month you want to report on. PROD.HIST is for the current month while the PRH.YYMM files are for previous months.
REPORT NAME: GROSS PROFIT BY SOURCE
FILE NAME:PROD.HIST
REPORT TYPE: SORT
ENTER FIELD(S) TO SORT BY: SRC~
SELECT SORT SEQUENCE (A=ASCENDING D=DESCENDING) A
ENTER SELECTION CRITERIA
FIELD CONDITION VALUE AND/OR
TRAN EQUAL CM""RET""SLS""VOID
ENTER COLUMN HEADINGS[035] SRC~;+EXT-COST;+EXT-SALE;TRAN;+GROSS~
ENTER DESCRIPTION FOR TOTAL LINE
PRINT TOTALS ONLY (Y/N) Y
ENTER FIELD(S) TO BREAK ON SRC~
CHANGE PAGE AT EACH BREAK (Y/N) N
ENTER SPECIAL FORMAT (Y/N) N
[This message has been edited by petepuma01 (edited 01-06-2003).]
[This message has been edited by petepuma01 (edited 01-06-2003).]
[This message has been edited by petepuma01 (edited 01-06-2003).]