Global List Update

Objective

Use the recommendations in this template for global price list updates, which flow into country price lists.

Example flow

Edit data

1. Open the Manage Global List Prices scenario workbook.

When you created the scenario, this workbook was loaded with data from base and decision support workbooks.

2. Open the Update List Prices worksheet.
3. In the Proposed List column, enter a value manually or upsert data from a CSV file.
4. In the Proposed Start Date column, select a start date.

The following information shows how other columns, column groups, and KPI cards in this worksheet are calculated. Use this information for additional decision support.

Price Change

CASE 
    WHEN COALESCE ({Current List Price}, 0) = 0 THEN NULL
    ELSE ({Proposed List Price} - {Current List Price} ) /  {Current List Price}
END

Publish data

1. In the Update List Prices worksheet, select the Publish checkbox for records that represent updated and final data. These records will be published back to the base and master data workbooks.

2. From the Actions menu, select Publish.

   The selected records are synchronized with the Global List waterfall element workbook.