We have a requirement to be able to create a single expense report for a user that has traveled in the same trip to different locations. The user should receive a per diem rate that is reduced on the travel days but only reduced on the rate that is for the location the user is flying to. The company policy is both the first and last day are considered travel days so the system is setup to do the automatic reduction as ‘both’ under the rate tiers.
However, this then causes an issue for the second line that is created for the second location because you are either double dipping and getting per diem for two locations for the same day at a reduced rate or you are being shorted because the second day you are at the second location is being treated by the system as a travel day even though it is not.
What we would expect is the following:
Day 1 travel to NY - per diem is 75% of the per diem rate since it is travel day
Day 2 is full day in NY - per diem is 100% of the per diem rate since no travel
Day 3 is travel day from NY to CA - per diem is 75% of the per diem rate of CA since it is a travel day to CA (currently this is where we see the issue with out of the box functionality and hoping we do not have to customize)
Day 4 is full day in CA – per diem is 100% of the per diem rate since no travel
Day 5 is travel day from CA home so the per diem rate is 75% since it is a travel day
Is there a way to indicate which day is a travel day on the expense report or is there some magic config I’m missing that will allow this scenario?
