Extending a Price List
You can extend the dates a price list is effective by copying an existing price list and entering the start and end dates for the new, extended price list. You can also apply a percentage change across all the price list entries, if required.
How Does Oracle Training Administration Calculate the Price List Entries?
Oracle Training Administration calculates the dates of the entries for the new, extended price list based on the following:
- the end dates of existing price list entries
- the end dates of the activity
- any price list dates you enter
By calculating the dates in this way, Oracle Training Administration ensures that the entries for the new price always extend to the correct dates.
Example 1
Price List 1 is effective for the period 01-JAN-1997 to 31-DEC-1997, and today's date is 01-SEP-1997. Enterprise Z wants to extend Price List 1 to 31-DEC-1998, starting from 01-JAN-1998. They also want to increase the prices by 10 per cent.
The activity for which the price list entries apply is effective from 01-JAN-1997 onwards.
| Price List 1
| 01-JAN-1997
| 31-DEC-1997
|
|
| Entry 1
| 01-JAN-1997
| 30-JUN-1997
| 200.00
|
| Entry 2
| 01-JUL-1997
| 31-AUG-1997
| 100.00
|
| Entry 3
| 01-SEP-1997
| 31-DEC-1997
| 150.50
|
In this example, Enterprise Z is able to copy Price List 1 to create the new, extended Price List 2, with the following entry :
| Price List 2
| 01-JAN-1998
| 31-DEC-1997
|
|
| Entry 3
| 01-JAN-1998
| 31-DEC-1997
| 165.50
|
Notice that only entry 3 appears on Price List 2. Entries 1 and 2 do not appear because they were manually-terminated to end on 30-JUN-1997 and 31-AUG-1997 respectively (and today's date is 01-SEP-1997), while Price List 1 ran to 31-DEC-1997. Oracle Training Administration only extended entry 3 because it can be extended (it only ended because the price list ended), while the other two entries were already ended.
Example 2
Price List 1 is effective for the period 01-JAN-1997 to 31-DEC-1997. Enterprise Z wants to extend Price List 1 to 31-DEC-1998, starting from 01-JAN-1998. They also want to increase the prices by 15 per cent.
The activity for which the price list entries apply is effective from 01-JAN-1997 to 31-JUL-1998.
| Price List 1
| 01-JAN-1997
| 31-DEC-1997
|
|
| Entry 1
| 01-JAN-1997
| 30-JUN-1997
| 200.00
|
| Entry 2
| 01-JUL-1997
| 31-AUG-1997
| 100.00
|
| Entry 3
| 01-SEP-1997
| 31-DEC-1997
| 150.50
|
In this example, Enterprise Z is able to copy and Price List 1 to create the new, extended Price List 3, with the following entry:
| Price List 3
| 01-JAN-1998
| 31-DEC-1998
|
|
| Entry 3
| 01-JAN-1998
| 31-JUL-1998
| 172.50
|
Notice that while entry 3 appears on Price List 3 it ends on 31-JUL-1998. This is because the activity on which the price list is based ends on 31-JUL-1998. Entries 1 and 2 still do not appear on the new price list.
To extend a price list:
1. Query the price list to extend and choose the Copy List button.
2. Enter the name of the new, extended price list.
3. Enter the start and end date of the new list. The start date of each entry changes in line with the change for the list.
4. Enter the percentage if you want the prices on the new list to be increased (the amount must be between 0 and 100). Otherwise, leave this field as it is.
5. Select the direction in which the new prices should be rounded, and the unit to which they should be rounded. For example, if the prices are in US dollars and you want to round the new prices up to the nearest 10 cents, select Up and enter 0.1 in the Nearest To field.
6. Choose the Copy List button and Oracle Training Administration creates the new price list for you.
See Also
Price Lists
Changing Prices for Entries Within a Price List
Changing Price List Dates
