Page 1 of 1
CDK Report for GM Non-Returnable Inventory
Posted:
Fri Sep 15, 2017 8:46 pmby partsman94
Hi,
I am needing to see if anyone could help me with a report that will list all of the non returnable parts in my GM inventory on our CDK DMS.
Unfortunately, I'm not great at English statements or attempting to form my own reports. I have tried multiple times through the CDK Service Connect
to get them to help me with a report such as this, but they can't seem to get it either. I have been a long time lurker on the forum for researching issues such as this, but can't seem to find an answer other than mention of the ABCD fields containing the codes. This will be my first post on the forum, but I will surely have more as time moves on. Your time and assistance is greatly appreciated!
AL
Re: CDK Report for GM Non-Returnable Inventory
Posted:
Mon Sep 18, 2017 1:54 pmby Gerry Laughlin
try:
SORT PART-NO. WITH P-U GT "" AND WITH O.H. GT "0" AND WITH ABCD NE "[R]" BY BIN BY O.H. CLASS ITEM-ID DESC MULT O.H. BIN
MNS SCOST TOTAL CUR.VAL SO BOPCK ABCD ID-SUPP
Re: CDK Report for GM Non-Returnable Inventory
Posted:
Mon Sep 18, 2017 2:27 pmby Mike Nicholes
I seem to remember that on the master tape there is a field called "ABCD" and the non-return code might be in one of the six fields in ABCD. Ask CDK for a descriptor of what is each of the ABCD fields.
Mike
Re: CDK Report for GM Non-Returnable Inventory
Posted:
Mon Sep 18, 2017 2:59 pmby partsman94
Thanks for your help fellas! I'm going to attempt to run the report today and hopefully this will
allow me to sort through the inventory issues that we have a little better.
Re: CDK Report for GM Non-Returnable Inventory
Posted:
Mon Sep 18, 2017 3:08 pmby ehiatt
*Deleted*
Re: CDK Report for GM Non-Returnable Inventory
Posted:
Mon Sep 18, 2017 3:24 pmby ehiatt
This is from a list I was given by ADP/CDK.
(Disclaimer: this list is titled GM Puerto Rico and is dated 12/1/15. It seems to be correct but you may want to check with them for a more current list.)
ABCD INFO
L-A Selective Parts Indicator
A = Accessories
E = Engine/Minimum Discount
F = Engines/Maximum Discount
G = Transmissions/Minimum Discount
H = Transmissions/Maximum Discount
T = Tires
X = Performance Parts
B = Collision - Truckload Fascia/Grille and a MyPriceLink Part
M = Collision - Competitive Collision and a MyPriceLink Part
W = Collision - MyPriceLink Part Not Already Identified by the
R-A and L-B First Year the part is used (YY)
R-B and L-C Last Year the part is used (YY)
R-C Franchise Code
2 = 42 Common with Car, Truck & AC Delco
3 = 43 Common with Car & Truck
4 = 44 TOPKICK/KODIAK Exclusive
L-D Material Return Code and Damaged Package Return
R = Returnable
D = Damaged Package Returnable
B = Both Returnable and Damaged Package Returnable
R-D Service Lane Part Indicator
Y = Yes
N = No
L-E Limited Lifetime Parts Warranty Program
L = Limited Lifetime Warranty Part
R-E thru R-F Promotional Discount % Shown as Percentage - Example: 3.10 in PRICE9 = 3.1%