Purpose
The Update Contract Prices tools allow you to update a specific selection (of your choice) of existing Contract Prices by increasing the price by a percentage and changing the contract start and end dates.
The update is a 3 step process:
- Calculate – this function is where you enter the % increase for contract prices, specify start and end dates, and enter the selection criteria for the contract prices to apply the changes to
- Review – this report allows you to see the new price alongside the current contract price for comparison prior to committing to the new prices
- Update – use this to confirm your changes and apply the new prices
Note: there is also a Contract Price Upload available for mass Contract Prices changes.
Data Input
Step 1 – Calculate Contract Prices
Use this function to enter a % increase (or decrease) of existing contract prices and to nominate which of the existing contract prices the update should apply too. Note that you cannot create new contract prices with this function, you can only change existing contract prices.
The new contract prices are calculated and stored in a ‘work’ area. This allows you to review the new prices to check all is correct before confirming them with the ‘Update’ function.
You could also use the ‘Calculate’ and ‘Review’ functions together as a ‘what-if’ style function if you like, so see what a proposed increase would look like. You might even want to use the review report as a price basis for negotiation with the customer.
The new prices calculated are held per ‘user’, so if you have several users who work on different prices, you do not disrupt each other’s prices as you work on them.
Options
Adjustment Factor
Enter the % to increase (or decrease) contract prices by. For example, enter 1.1 to increase prices by 10%.
Entry of 0 sets the contract price to zero. The entry of 0.9 will decrease the prices by 10%. Entry of a negative number sets the contract price to a negative.
Contract Start Date
Enter the start date for the contract prices. This is optional.
Contract End Date
Enter the end date for the contract prices. This is optional.
Filters
Enter the selection criteria required to target the contract prices you need to update. You may select contract prices for a Customer(s), for a Contract Price List code(s), or for a Product range.
Selected Items
Items selected matching the entered criteria are displayed in a list for visual confirmation. Items can be omitted from the calculation run with the use of the standard OA include/exclude tool prior to the system calculating the new contract prices.
Return to the Top
Step 2 – Review
Use the report to compare the current Contract Prices to the newly calculated Contract Prices. The report also includes the standard price for each Product and the new margin.
If you find an error, you can go back to the ‘Calculate’ step and re-do the calculation.
Step 3 – Update
Use this function to confirm that you would like to move the new Contract Price details from the calculation ‘work’ area and apply them as actual Contract Prices. The new prices are then active and will apply to orders immediately, assuming the orders are within the contract’s valid date range.