Example 1

Base price list valid 2017-01-01 to 2017-12-31.

Linked price list valid 2017-06-01 to 2017-11-30, 10% deduction on the base price.

Add a record in the base price list with the validity dates 2017-01-01 to 2017-12-31, price 100.00. This also creates a record in the linked price list with the validity dates 2017-06-01 to 2017-11-30, price 90.00.

Add a record in the base price list with the validity dates 2017-05-01 to 2017-06-30, price 80.00.

This will not add a record in the linked price list since there already is a record with valid from date 2017-06-01.

Nor will the existing record be updated based on the new price in the base price list, since the base price is not valid for the whole validity period of the linked price list line. The linked price list line is updated, but the valid base in this example is the record with the validity dates 2017-01-01 to 2017-12-31, which means that the price will not change.

Outcome

Base price list valid 2017-01-01 to 2017-12-31:

Record Valid from Valid to Price
Added record 1 2017-01-01 2017-12-31 100
Added record 2 2017-05-01 2017-06-30 80

Linked price list valid 2017-06-01 to 2017-11-30, 10% deduction on the base price:

Record Valid from Valid to Price
Added record 1 2017-01-01 2017-11-30 90

Price retrieved from the base price list during different date intervals:

2017-01-01 to 2017-04-30, price 100.00

2017-05-01 to 2017-06-30, price 80.00

2017-07-01 to 2017-12-31, price 100.00

Price retrieved from the linked price list during different date intervals:

2017-06-01 to 2017-11-30, price 90.00

Related topics