Anyone else tested Mileage Thresholds with multiple lines?

Summary:

Multiple mileage lines on one Expense Report do not accumulate mileage and cause incorrect rates to be used.

Content (required):

Client requires employees to detail each trip and not combine mileage into one expense line, which is perfect for the MI they require. 1st line that goes over threshold works perfectly. The 2nd line that is created on the same report, resorts to the previous threshold. Subsequent reports use the new threshold correctly.

Eg. Employee is at 9,000 miles.

45p per mile, threshold set at 10,000 miles and 25p per mile after.

Expense Report has 2 lines.

Created first. 1010 miles calculated for £452.50 ((1000 x 0.45)+(10 x 0.25))