cancel
Showing results for 
Search instead for 
Did you mean: 
Danc
Occasional Member - Level 1

Audit rule which checks across multiple years

Is it possible to create an audit rule which checks across multiple years for a given user/expense report type?

Ex. We have an expense report type ‘Employee Special Benefit’. The lifetime limit is $1000 per employee. When an employee enters a new expense report of this type we want the system to add up all prior expense reports for that type/person for all prior dates and confirm is not > 1000. If > 1000 then throw error/warning that user is over limit.

Seems like there is some limit to only check by year so can a formula be created to do:

Amount-Yearly Total for current year

PLUS

Amount-Yearly Total for prior year

Possible?

Thanks for any assistance you can provide