When modifying an existing Price List please note the following:
Header Qualifiers
You cannot modify an existing Qualifier the Wizard will create a new record. End date the existing record and create a new record on your worksheet. Use the Validate Option of ‘Validate and Upload’.
Secondary Price List
You cannot modify an existing Secondary price list the Wizard will create a new secondary price list. Delete the existing secondary price list by entering a ‘Yes’ in the ‘Delete Sec Price List’ column.
Lines
You can update a line if the List Line ID is in worksheet, so first you must download the price list first. A value can be changed; however it is recommended to use the ‘Create New Record Value’ field. This is to ensure pricing history integrity is maintained. To use this, provide an end-date to the current list line and set the ‘Create New Record Value’ to the new value of the list line. On upload this will end-date the current list line and create a new list line with the new value specified, and a start date starting one day after the supplied end-date used in the previous step.
Line Attributes
You cannot modify an existing attribute the Wizard will create a new record. Use the Validate Option of ‘Validate and Upload’.
Line Price Breaks
Modify an existing price break using the ‘Price Break New Value From’ and ‘Price Break New Value To’. Use the Validate Option of ‘Validate and Upload’.
