I’m building an app - Mileage Tracking and Reimbursement.
Table 1 - Year and IRS rate.
Table 2 - Date Traveled, person, from and to, starting and ending mileage, purpose, reconciled… basic stuff.
I have two issues I’m trying to resolve.
I have a connection from the traveling detail to the IRS Rate. I have a formula that extracts the year from the entered date, however the connection doesn’t seem to use the year. You have to select the year from the dropdown to grab the rates. How can I retrieve the rate from the IRS file? I don’t want to give people the option, since they would always pick the year with the largest rate, and if they enter a 12/31/2022 and a 1/1/2023 record it should have rates for the appropriate year, one for each year.
I have a grid set up for accounting to filter the records for a person, and date. I have a summary so they can see cost totals. The problem is by including the total the grid totals everything , including “starting mileage” and “ending mileage”. The total is correct, but having the total of the mileages looks terrible.