![Page 1: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/1.jpg)
your partner for manufacturing excellence
Customer Order ManagementOff Line Pricing
A Simple Approach to Mass Price Maintenance
![Page 2: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/2.jpg)
your partner for manufacturing excellence
The Goal
Update COM Pricing Details Easily and Quickly
Reduce Clerical Effort
Implement Changes in a Timely Manner
![Page 3: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/3.jpg)
your partner for manufacturing excellence
Method
• Download Current pricing to Excel– Use the COM offline maintenance function
• Manipulate the Pricing Date in Excel– Using formulas, and cut & Paste
• Replace the Pricing File Data with the New Information
![Page 4: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/4.jpg)
your partner for manufacturing excellence
The Tools
• XA Offline Pricing
• I-Series Client Access– Excel Add-in.
• Excel
![Page 5: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/5.jpg)
your partner for manufacturing excellence
Basic Information
• COM Pricing Files– Item Base Price MBLKCPP– Price Book Header MBLLCPP– Price Book Version MBL4CPP– Price Book page 1 MBLMCPP– Price Book Page 2A MBLNCPP– Price Book Page 2P MBLOCPP
![Page 6: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/6.jpg)
your partner for manufacturing excellence
Basic Information
– Price Book Page 3A MBLPCPP– Price Book Page 3P MBLQCPP– Price Book Page 4 MBLRCPP– Price Book Page 5 MBLSCPP– Item Foreign Price MBLTCPP– Contract/Promotion Header MBIDCPP– Contract/Promotion Item MBIECPP
![Page 7: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/7.jpg)
your partner for manufacturing excellence
Preparing to Change Pricing
• Download– COM Provides
• Intermediate Files to Exchange Data• Data layouts
• Change – Microsoft Excel
• Upload– Edits for uploading valid data
![Page 8: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/8.jpg)
your partner for manufacturing excellence
Download Offline Pricing Files
• COM– Menu AMBM63– 13. Offline Pricing >>
• 1. Offline Item Base Price
• 2. Offline Price Book
• 3. Offline Contract/Promotion
• 4. Offline Foreign Price
![Page 9: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/9.jpg)
your partner for manufacturing excellence
Copy to Offline File
Prepare the Work Files
![Page 10: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/10.jpg)
your partner for manufacturing excellence
![Page 11: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/11.jpg)
your partner for manufacturing excellence
Series – I addin
• Setup the Excel addin
• Download files
![Page 12: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/12.jpg)
your partner for manufacturing excellence
Program Files/IBM/client access/shared
![Page 13: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/13.jpg)
your partner for manufacturing excellence
![Page 14: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/14.jpg)
your partner for manufacturing excellence
Download File to update
![Page 15: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/15.jpg)
your partner for manufacturing excellence
Download File to update
![Page 16: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/16.jpg)
your partner for manufacturing excellence
Download File to update
Item Base Price
![Page 17: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/17.jpg)
your partner for manufacturing excellence
Download
![Page 18: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/18.jpg)
your partner for manufacturing excellence
Download
![Page 19: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/19.jpg)
your partner for manufacturing excellence
Download
![Page 20: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/20.jpg)
your partner for manufacturing excellence
![Page 21: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/21.jpg)
your partner for manufacturing excellence
Excel View
![Page 22: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/22.jpg)
your partner for manufacturing excellence
Make The Changes
![Page 23: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/23.jpg)
your partner for manufacturing excellence
Ready To Upload
Highlight the rows to
upload
![Page 24: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/24.jpg)
your partner for manufacturing excellence
Ready To Upload
Highlight the rows to
upload
![Page 25: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/25.jpg)
your partner for manufacturing excellence
Transfer Request
![Page 26: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/26.jpg)
your partner for manufacturing excellence
Transfer Request
![Page 27: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/27.jpg)
your partner for manufacturing excellence
Replace Member
![Page 28: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/28.jpg)
your partner for manufacturing excellence
![Page 29: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/29.jpg)
your partner for manufacturing excellence
![Page 30: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/30.jpg)
your partner for manufacturing excellence
![Page 31: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/31.jpg)
your partner for manufacturing excellence
![Page 32: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/32.jpg)
your partner for manufacturing excellence
Save the Transfer Request
![Page 33: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/33.jpg)
your partner for manufacturing excellence
Be Sure No One is
Using The File
![Page 34: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/34.jpg)
your partner for manufacturing excellence
Apply New Prices
![Page 35: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/35.jpg)
your partner for manufacturing excellence
The Update is Submitted
![Page 36: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/36.jpg)
your partner for manufacturing excellence
New Prices
![Page 37: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/37.jpg)
your partner for manufacturing excellence
Benefits
• Easier Preparation
• Automate Pricing
• Convert Manual Pricing Quickly
• Change Pricing Quickly
• Add New Pricing Records
![Page 38: Your partner for manufacturing excellence Customer Order Management Off Line Pricing A Simple Approach to Mass Price Maintenance](https://reader036.vdocuments.us/reader036/viewer/2022062421/56649d885503460f94a6cca8/html5/thumbnails/38.jpg)
your partner for manufacturing excellence
Questions