REY & REY REPORTS

[AL]

LOOKING FOR SOME IDEAS OR GOOD REPORT GEN
IN REY &REY SYSTEM FOR GROSS PROFIT BY SOURCE
AND HOW TO GET SALES FOR RETAIL WHOLESALE AND
RO (CUSTOMER PAY AND WARRANTY) IN REPORT GEN
I'D LIKE TO BE ABLE TO LOOK AT REPORT TICKET BY TICKET RATHER THAN IN 0422. ALSO WHAT PARTS NUMBERS ARE BILLED ON A RO OR INVOICE ON A DAY BY DAY BASIS
THANKS
AL

[ralphc10]

Hi Al,
To answer your question I would need more info, like where are you trying to get this report from, accounting or parts & more... You can also get FREE help form the support phone line go to parts or accounting then report gen group. They will help you creat just what you are looking for. 800-767-0080

Hope that helps,
Ralph Chiucchi
R&R Consulting

[petepuma01]

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).]

[petepuma01]

You may also want to try 2543 Invoice Register to review profit detail for specific invoices.

[petepuma01]

Parts sold to invoices and RO's

Report uses the offset date fields (looks at current date and adds/subtracts the value entered)-- this field prevents the need to modify the date in the report all the time. Enter 0 for sales on the current date, a positive number for previous days (i.e.; 1 for yesterdat, 2 for 2 days ago)

REPORT NAME: PARTS SOLD TO DOCUMENTS
FILE NAME: PROD.HIST
REPORT TYPE: SORT
ENTER FIELD(S) TO SORT BY: INV#/PO#
SELECT SORT SEQUENCE (A=ASCENDING D=DESCENDING) A

ENTER SELECTION CRITERIA

FIELD CONDITION VALUE AND/OR
OFFSET-TRANS DATE~ EQUAL <<0=CUR DAY/POS# FOR PRV DAY>> AND
TRAN EQUAL CM""RET""SLS""VOID

ENTER COLUMN HEADINGS[101] INV#/PO#;CTRMN;PART-INFO;QTY;TRAN;+EXT-COST;+EXT-SAL
E;+GROSS~;SALE TYPE~;SALE TYPE (CWI)~

ENTER DESCRIPTION FOR TOTAL LINE
PRINT TOTALS ONLY (Y/N) N

ENTER FIELD(S) TO BREAK ON INV#/PO#

CHANGE PAGE AT EACH BREAK (Y/N) N

ENTER SPECIAL FORMAT (Y/N) N