Financial year limit for expense type

[saikatinit]

Hi Team,

I need to maintain financial yearly limit(1st April to 31st March) for one of our expense type. In audit rules there is no option for Financial year( only weekly/yearly/monthly/daily). Can you please help me with this issue if any solution there.  Also we would like to track in some field the remaining amount from the limit. Is that possible? Can you please help. 

[KevinD]

@saikatinit running limit audit rules can only look at a calendar year.

To keep a running total, I would recommend using a Cognos report that you schedule to run either daily, weekly or monthly. This allows you to see a comprehensive list of all employees and their running total in one report.

[saikatinit]

Hi Kevin,

Actually, our customer has some company policy to maintain expense type limit for a financial year like from April to March. Is there no way we maintain that? if not using audit rule, any other alternatives? Cognos means using reports that we can do but they want at expense level and stop users from submitting expense if they cross that limit in Financial year and not in calendar year. 

[KevinD]

@saikatinit okay, so my colleague gave me an option. You would need to create a custom field on the Employee profile (accessed from Company Administration). The field could be labeled Expense Type Name Allowance. For example, Work Boot Allowance. This field would need to be updated periodically, which could be done by running a Cognos report and copying the data from the report into the Import file. She also mentioned automating the Cognos report via FTP, but I don't quite know how that works. 

Anyway, once the custom field is created, you can then create an audit rule based on that field. Here is an example of the rule.