Mopar Promotions & Parts Sources

Post Reply
Inkman

Mopar Promotions & Parts Sources

Post by Inkman »

Since Mopar's factory sources don't mean much where parts promotions are concerned, what are my options for building an order by specific promotional codes? A source for each promo code would make for a lot of new sources. That would be okay except I'm already sourcing by sales and have quite a few sources as a result. I can pull up a report to show sales by promo code in the report generator (I'm on ADP) but it would all need to be key-punched. Is there a better way?
Inkman
jazdale

Mopar Promotions & Parts Sources

Post by jazdale »

Inkman,

What are you using to extract the promo parts?

The master tape detail source detail
7 = PROMOTION - EOS PARTS
8 = PROMOTION - ACCESSORIES
9 = PROMOTION - SHEET METAL

R-B = right of B = 4th character of ABCD
Heres some (not all of it)
R-BPROMOTIONAL CODES
A = CAN NOT USE
B = EOS BATTERIES
X = EOS EXHAUST SYSTEMS
C = EOS CHEMICALS

**********************
Are you using either/both of these?

Source would be simple to use.

If you're extracting off of ABCD heres a trick.
We're going to use Excel to re-post the detail. Yes, I'm assuming you have Excel.

Construct the RPG using ABCD and save it.
Rerun the report in RPX which will send it to Excel on your PC.

If cell A1 = part-no and A2 = O.O.
Then we'll build A3 to be part-space-O.O. so its formatted like function PO (post orders)
The formula for A3 =A1&" "&A2
Now drag the lower corner of A3 and it will auto-fill the rest of your order.

Setup your header in option A function PO so its ready for part numbers.
Highlight the part-space-o.o. column in excel and choose copy.
Go to ADP and choose paste.

Enjoy.


Post Reply