Rate changes to Mileage policy iExpenses v12.1.3
Has anyone figured out how to create a Mileage policy with distance thresholds and handle rate changes throughout the period.
EG. Policy for the fiscal year April 1 2016 - March 31 2017.
Mileage thresholds <8000kms @ rate .345
8001-15999 kms @ rate .327
>16000 kms @ rate .315
On June 1 the rate changes increases by .5 so they become .395, .377, and .365.
An employee who enters their expenses for travel the last week of May on June 6th will get the new rate, but should only be reimbursed the rate that was in effect in May.
We cannot create monthly periods because the mileage needs to accumulate for the entire year.