Implementing Reimbursement/ Expense Claim of our Organization

[ShivangiC]

We are implementing Reimbursement/ Expense Claim of our Organization as in automating the Expense Claim process.

1. In our requirement, we need a button 'Return for Review' under Tasks [on esc portal] where Manager can Approve, Reject or Return the request. With this button Manager must be able to enter his/her comments and the state of request must be as specified. The requests are raised via Record Producer and are mapped to custom tables at backend. Attaching the flowchart of our requirement.

2. We have Currency type fields at backend but in record producer we don't have any option for it. As we are using MRVS for it, because Employee must be able to enter single/multiple line items under Request Number. So, what can be the solution for it. We want 3 currencies USD, JPY, INR, and if whichever user selects in record producer, that currency must be set at backend for every Currency type field. We even have Cost Center containing different location of our offices such as Tokyo [Japan], Bhubaneshwar [India], London and so on. [If in case we can use them in this scenario.]

3. The request raised by the Employee is displayed under 'My Requests' of esc portal but it is not clickable so that Employee can view the details of request raised by him/her.

Please specify the detailed steps to achieve these. As we our new for SNOW customization, we need your guidance.