380 likes | 495 Views
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
E N D
Customer Order ManagementOff 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 • Manipulate the Pricing Date in Excel • Using formulas, and cut & Paste • Replace the Pricing File Data with the New Information
The Tools • XA Offline Pricing • I-Series Client Access • Excel Add-in. • Excel
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
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
Preparing to Change Pricing • Download • COM Provides • Intermediate Files to Exchange Data • Data layouts • Change • Microsoft Excel • Upload • Edits for uploading valid data
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
Copy to Offline File Prepare the Work Files
Series – I addin • Setup the Excel addin • Download files
Download File to update Item Base Price
Ready To Upload Highlight the rows to upload
Ready To Upload Highlight the rows to upload
Benefits • Easier Preparation • Automate Pricing • Convert Manual Pricing Quickly • Change Pricing Quickly • Add New Pricing Records