Cumulative Mileage Issue in Expense Reports

Hi,

We were having an issue in Fusion calculating rates for mileage type expense reports.

Expense Setup: If the Trip Distance is below 10,000 miles rate would be 0.45. Once the overall distance crosses 10,000 miles rates would be 0.25.

Example: User enter a expense report for 20,000 miles, Reimbursable Amount for expense report will be 7,000

Logic: First 10,000 miles – 10,000 * 0.45 = 4500

              Next 10,000 miles – 10,000 * 0.25 = 2500

              Total = 4,500 + 2,500 = 7,000

This logic is not working when user create multiple mileage expense reports.

Example: If a user create 3 separate expense reports with 10,000 miles in each report. Actual calculation would be

Expense Report 1 = 10,000 * 0.45 = 4,500

Expense Report 2 = 10,000 * 0.25 = 2,500 (Rate should be 0.25 since we already crossed 10,000 miles in other expense report)