We have received request to add functionality to Apex to support escalation/de-escalation of pricing based on changes to the Oil Index. We would like to get feedback from the community on how you handle this process today.
Please Vote if you would like to see this functionality included in Apex.
The current functionality for index based pricing with other charges almost works, with the exception that we need the ability to associate what index was in effect at the time we quoted. To use the existing index functionality all quotes would have to be priced based on a base date in the past witht the current index rate applied, which isn't practical. Instead, we quote based on the current Oil index and then we adjust pricing on orders monthly as the index changes. This is a tedious manual process that we have developed reports for to identify orders ticketed that need to be reviewed/adjusted.
One approach would be to add an 'Index Date' to the Quote/Order where we could reference what the Oil Index was at the time of quote/order - then when the Other Charge is calculated it would adjust to be the differnce between the rate at time of quote/order and the rate on the ticket date.