Part piece count using ADP

[drapp]

We are still using ADP WebSuite 2007. Is there a way to obtain a parts 'piece count' sold to service repair orders. I am not looking for part number count. I am looking for total piece count. I assume I will need to sort this based on labor type because I want to exempt body shop repairs and we use the same service account (xxx-S) for service and body work.

ADP says there is nothing in the way of canned reports. I cannot find anything on the MGR reports. RPG won't do it because the correct 'dict' items are not loaded. ADP is working to load the 'dict' items but it will take a few days to accomplish this - then I have to build a RPG report to get what I need.

Basically what I want to do is pull total pieces sold to service department repair orders over a given time period. Let's say I want total piece count on service repair orders for the month of November 2014.

There is a good reason for this but I don't really want to get into the why I want it - I just do.

[tcollins]

I track part numbers sold, pieces sold as well as number of invoices for each counter person. I created the report in the enhanced report generator. Once this report is created, you might have to export to an excel file then sort by RO #'s but it should work or you might be able to create a selection process just for RO's. I haven't tried that. See the attachment.

[drapp]

After speaking with a few different ADP / CDK support people over several days, I think they have come up with a solution to the problem. ADP/CDK had to build (add) a few dictionary items to the parts RPG reporting system. Then they built a basic report which I modified slightly. For those of you that are curious the english statement is shown below:


SORT PDA.PARTS WITH SALE-TYPE EQ "RO" AND WITH CLOSED GE "%" AND WITH CLOSED LE
"%" AND WITH SALE-ACCT EQ "46700" BY SALE-ACCT CLOSED PART-NO TOTAL QTY REFER
BREAK-ON SALE-ACCT TOTAL T-COST TOTAL T-SALE ID-SUPP