Hello,
In Record Producer I have a Currency dropdown having values INR, USD, JPY. As our organization is located globally. Currently, we made the currency dropdown read only and auto populated it according to User's location in sys_user table. Now, if Employee travels to another branch for sometime and enters his expense amount according to other country, the 'converted amount' field must automatically be populated after dynamic currency conversion. We can make Currency dropdown editable for the Employee to select the currency he/she is spending in and that currency must be used for conversion and according to his Location[in sys_user]. The Converted Amount must be displayed.
Example:- if Employee is of Indian office and travels to UK/US for 1 month for official training. He will be entering 250 USD as his expense amount [USD to be selected in Currency dropdown and 250 to be entered in Amount field ] but his office will be reimbursing him money in INR. So there must a 'converted amount' field which must auto populate the converted 250 USD to INR. How can this field calculation be achieved?
NOTE:- fx_rate table has static rate to be input by user manually, so not going with that. We need implementation dynamically
