Price list line item effectivity dates
You can set effectivity dates at the line item level.
By default, the price of a line item is effective for the effective period specified for the corresponding price list. You can also specify a special price for a particular period at the line item level by overriding existing price list effectivity dates with new effectivity dates. This means that the same product ID can have more than one entry with varying prices in the same price list. In such a scenario, the system uses the lowest value of the effective prices.
For example, let us suppose that a price list is effective from 12/01/2012 through 12/01/2013. One product ID, ProductID1, has three entries in the price list:
- One entry defines a price of $35.00. The entry does not define effectivity dates, so its effectivity dates are the same as the price list effectivity dates.
- The second entry defines a price of $25.00 and has effectivity dates from 02/01/2013 to 08/01/2013.
- The third entry defines a price of $30.00 and is effective from 01/01/2013 to 10/01/2013.
The following table provides prices for ProductID1 on various dates:
| Date | Price |
|---|---|
| 11/15/2012 | Price not available from this price list. The price list is not effective. |
| 12/02/2012 | $35.00: Only the first entry is effective. |
| 01/03/2013 | $30.00: The first and third entries are effective, and the third provides the lowest price. |
| 05/16/2013 | $25.00: All three entries are effective, and the second provides the lowest price |
| 09/20/2013 | $30.00: The first and third entries are effective, and the third provides the lowest price. |
| 11/02/2013 | $35.00: Only the first entry is effective. |
Price lists can also be defined to be active for a few days of the week during a date range.
Price list effectivity dates can also be adjusted for time zones.