Update of a linked price list

A linked price list can also be updated using related option 16='Upd price list' in (OIS017).

It is not allowed to set the field 'Function selection' to 1-'Create or Update' for a linked price list. Use function selection 3-'Update/Delete' to update existing records, then add new records with function selection 2-'Create'.

Function selection 2-'Create'

All records in the base price list with a 'Line valid from' date within the entered date range are used to create a corresponding record in the linked price list, with the same 'Valid from' date and the same 'Valid to' date if the 'Valid to' date is within the price list's 'Valid to' date. If not, the linked price list's dates are used. This creates a date interval in the linked price list where both the base price and the linked price are valid.

If no record exists in the base price list with the linked price list's 'Valid from' date, a record is still created in the linked price list for that date if a price exists in the base price list that is valid at that date. If more than one price exists that is valid, then the one with the highest 'Valid from' date is used.

If the base price list only has records that are no longer valid, no record is created in the linked price list.

Function selection 3, 4, and 5 (Update/Delete)

Price list lines with a 'Line valid from' date within the selected date interval are updated or deleted. The price from the base price list used for each update is the price with a 'Line valid from' date less or equal to the record being updated. No update is done if no base price exists that has a 'Valid to' date that is greater or equal to the 'Valid from' date of the record being updated.

Related topics