your partner for manufacturing excellence

Customer Order ManagementOff Line Pricing

A Simple Approach to Mass Price Maintenance

your partner for manufacturing excellence

The Goal

Update COM Pricing Details Easily and Quickly

Reduce Clerical Effort

Implement Changes in a Timely Manner

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

your partner for manufacturing excellence

The Tools

• XA Offline Pricing

• I-Series Client Access– Excel Add-in.

• Excel

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

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

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

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

your partner for manufacturing excellence

Copy to Offline File

Prepare the Work Files

your partner for manufacturing excellence

your partner for manufacturing excellence

Series – I addin

• Setup the Excel addin

• Download files

your partner for manufacturing excellence

Program Files/IBM/client access/shared

your partner for manufacturing excellence

your partner for manufacturing excellence

Download File to update

your partner for manufacturing excellence

Download File to update

your partner for manufacturing excellence

Download File to update

Item Base Price

your partner for manufacturing excellence

Download

your partner for manufacturing excellence

Download

your partner for manufacturing excellence

Download

your partner for manufacturing excellence

your partner for manufacturing excellence

Excel View

your partner for manufacturing excellence

Make The Changes

your partner for manufacturing excellence

Ready To Upload

Highlight the rows to

upload

your partner for manufacturing excellence

Ready To Upload

Highlight the rows to

upload

your partner for manufacturing excellence

Transfer Request

your partner for manufacturing excellence

Transfer Request

your partner for manufacturing excellence

Replace Member

your partner for manufacturing excellence

your partner for manufacturing excellence

your partner for manufacturing excellence

your partner for manufacturing excellence

your partner for manufacturing excellence

Save the Transfer Request

your partner for manufacturing excellence

Be Sure No One is

Using The File

your partner for manufacturing excellence

Apply New Prices

your partner for manufacturing excellence

The Update is Submitted

your partner for manufacturing excellence

New Prices

your partner for manufacturing excellence

Benefits

• Easier Preparation

• Automate Pricing

• Convert Manual Pricing Quickly

• Change Pricing Quickly

• Add New Pricing Records

your partner for manufacturing excellence

Questions