1 / 38

Customer Order Management Off Line Pricing

Customer Order Management Off Line Pricing. A Simple Approach to Mass Price Maintenance. The Goal . Update COM Pricing Details Easily and Quickly Reduce Clerical Effort Implement Changes in a Timely Manner. Method. Download Current pricing to Excel Use the COM offline maintenance function

hilary-finch
Download Presentation

Customer Order Management Off Line Pricing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Customer Order ManagementOff Line Pricing A Simple Approach to Mass Price Maintenance

  2. The Goal Update COM Pricing Details Easily and Quickly Reduce Clerical Effort Implement Changes in a Timely Manner

  3. 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

  4. The Tools • XA Offline Pricing • I-Series Client Access • Excel Add-in. • Excel

  5. 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

  6. 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

  7. Preparing to Change Pricing • Download • COM Provides • Intermediate Files to Exchange Data • Data layouts • Change • Microsoft Excel • Upload • Edits for uploading valid data

  8. 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

  9. Copy to Offline File Prepare the Work Files

  10. Series – I addin • Setup the Excel addin • Download files

  11. Program Files/IBM/client access/shared

  12. Download File to update

  13. Download File to update

  14. Download File to update Item Base Price

  15. Download

  16. Download

  17. Download

  18. Excel View

  19. Make The Changes

  20. Ready To Upload Highlight the rows to upload

  21. Ready To Upload Highlight the rows to upload

  22. Transfer Request

  23. Transfer Request

  24. Replace Member

  25. Save the Transfer Request

  26. Be Sure No One is Using The File

  27. Apply New Prices

  28. The Update is Submitted

  29. New Prices

  30. Benefits • Easier Preparation • Automate Pricing • Convert Manual Pricing Quickly • Change Pricing Quickly • Add New Pricing Records

  31. Questions ?

More Related