I have a line items for my purchase order and I want each item to have another total amount automatically converted to BND (Brunei Dollars), based on the original total amount of whatever the currency is.
I would like to set the conversation automatically base on the latest exchange rate, would it be possible to do so?
Please see below example for easier understanding:
PO Date: 15/04/2016
Item: Bracket (Manual Input: Text)
Qty: 12 pcs (Manual Input: Numeric)
Unit Price: 1 (Manual Input: Numeric)
Currency: USD (Manual Input: Multiple Choices)
Total Amount: 12 USD (Summary: [Qty x Unit Price])
Total Amount in Brunei Dollars (Base on 1.36 today's exchange rate for USD-BND): 16.32 BND (Summary: [ExRate=USDtoBND of the date in the PO]*[Total Amount])
I hope that my explanations are clear and will wait for your prompt response.