DealersEdge Professional Forums

Does anyone have a R&R report for tracking lost sales by employee..?

I have one built that works on prod.hist monthly.

MSInventory wrote:I have one built that works on prod.hist monthly.

I tried building one but just could not get what I really wanted..Any chance I could get a copy of that from you ...Thanks

Here ya ago:


REPORT NAME LOST SALES BY USER
FILE NAME PRH.1707 CREATOR
REPORT TYPE SORT MODIFIED BY LAST SAVED 08/02/2017
ENTER FIELD(S) TO SORT BY PART-NO
SELECT SORT SEQUENCE (A=ASCENDING D=DESCENDING) A
LAST PRINTED 08/02/2017
ENTER SELECTION CRITERIA

FIELD CONDITION VALUE AND/OR
TC = L






ENTER COLUMN HEADINGS[077] PART-INFO;QTY;QOH;TRNSDATE;TRAN;TC;USER ID

Perfect sir... Thanks you very much. I was using the wrong selection criteria.

MSInventory wrote:Here ya ago:


REPORT NAME LOST SALES BY USER
FILE NAME PRH.1707 CREATOR
REPORT TYPE SORT MODIFIED BY LAST SAVED 08/02/2017
ENTER FIELD(S) TO SORT BY PART-NO
SELECT SORT SEQUENCE (A=ASCENDING D=DESCENDING) A
LAST PRINTED 08/02/2017
ENTER SELECTION CRITERIA

FIELD CONDITION VALUE AND/OR
TC = L






ENTER COLUMN HEADINGS[077] PART-INFO;QTY;QOH;TRNSDATE;TRAN;TC;USER ID

You're more that welcome. Glad I could help.