Example 2
Same price lists as in 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 the records in the base price list, but do not select to update the linked price list, or create the linked price list later.
Add the records in the base price list:
2017-01-01 to 2017-12-31, price 100.00.
2017-05-01 to 2017-06-30, price 80.00.
Now update (or create) the linked price list.
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 2 | 2017-06-01 | 2017-06-30 | 72 |
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-06-30, price 72.00
2017-07-01 to 2017-11-30, no price is found in the price list.