Expense Lines - Is there a way to know who processed the expense?

[Onoderav]

Hi, guys!
Concerning expense lines, client requested a field in the fm_expense_line list that shows the user who processed the expensive. I haven't found anything that shows this kind of information. Someone knows if there's a way to achieve this?
Thanks in advance.

[Iraj Shaikh · Accepted solution]

Hi @Onoderav 

Please follow the steps below to accomplish your requirement

1. Create new field on fm_expense_line table and reference it to the "User [sys_user]" table.

2. Create a new business rule that triggers "before" an insert or update on the fm_expense_line table.

Filter condition: State changes to Processed

Srcipt:

(function executeRule(current, previous /*null when async*/ ) {

    current.u_processed_by = gs.getUserID();

})(current, previous);

Please mark this response as correct or helpful if it assisted you with your question.