OIE - Mileage Rate schedules not working for cumulative mileage
I have created a Mileage rate schedule with a Distance Threshold of 10000 per period for 2010 01-APR-2010 - 31-MAR-2011. The mileage schedule details are Between 1 and 10000 miles, the mileage rate is 0.40 and above 10000 0.25.
When appliying this schedule on an expense report entered via OIE, if the mileage claim is greater than 10000 miles on the claim, the code correctly splits the expense lines into 2 lines for the different schedules.
However this only works on the single expense claim - it does not take account of the cumulative effect of multiple expense claims. Does anyone know if this is a bug, defect or unsupported feature - this is a common UK leigislative measure now for claiming mileage which all UK Companies should be impacted by so I guess I am not alone with this issue and if anyone knows a solution?