DealersEdge Professional Forums

I was wondering if someone could help me out with a report. I am looking to build a report that will show me all RO's under a pre defined effective labor rate for a set time period. Any ideas?
Thanks
Kevin

Creat a new report in RPG,

ADD NEW REPORT

PRINT A REPORT (LIST)
SELECT FILE TO BE ACCESSED (HISTORY)

2. SELECTION CRITERIA

SELECT "LABOR TYPE (8)" YOU CAN EITHER TYPE EQUALS AND INPUT THE LABOR TYPE OR (%) TO HAVE IT PROMPT FOR LABOR TYPE WHEN YOU RUN REPORT.

SELECT "OPEN DATE (9)" USE > FOR DATE GREATER THAN, THEN USE (%) TO ENTER THE BEGINNING DATE NOW SELECT "CLOSED DATE" USE THE < FOR DATE LESS THAN, AGAIN USE (%) TO INPUT THE DATE. YOU WILL HAVE TO USE "A" FOR EACH SELECTION BECAUSE YOU WANT IT TO SELECT A SPECIFIC LABOR TYPE, WITH A OPEN DATE GREATER THAN (DATE) AND CLSED DATE LESS THAN DATE.

THEN YOU SELECT HOW YOU WANT IT TO SORT, ASCENDING FOR EXAMPLE

THEN THE OUTPUT FIELDS, RO NUMBER, SERVICE ADVISOR, ETC ETC ETC

THEN FOR DONE

Are you on Websuite?
The RO Performance report will allow you to view RO's below a certain ELR. In fact, it highlights them in RED.

As far as an RPG. It'll be tough. May even require an Excel dump so you can build the calculation for ELR.

I would do it in RPG as described above other than I would set the selection criteria for the date range with %% to dynamically set and have it run the columns as Labor sale, labor hours and Labor cost - then I'd do the math in excel. We could use ADP's built-in calculations - but it is just as easy for me to do that in excel as add the column in RPG.

With enchanced RPX this couldn't be easier. I would do the elr calc - then sort by elr. I would likely also do GP% and then I also look at the RO's that most severely impacted gross by sorting on the difference on the actual sale and what the sale should have been in the rate had not been changed.

However - with all of this be sure to check if misc coupons/discounts are being properly recorded to sale line. Otherwise it can give you a false read.

Remember that the you need to do an expanded sort to break-out all the labor types in an particular RO otherwise you'll only get the first labor type recorded. I think the field is BY-EXP.

s