Here is a scenario, I am not sure if this has been handled or there is a work around to address this ?

1. Sales Order Approval WorkFlow is enabled
2. User creates a sales order in Foreign Currency
3. Sales Order is sent for approval, the status changes to "Pending Approval"
4. Sales Order is Approved, the status changes to "Released"
5. Finance Team wants to update the "Exchange Rate" before posting the invoice
6. The Sales Order needs to be re-opened and re-approved before it can be invoiced

Since the Sales Order is in Foreign Currency e.g. CAD where as the functional currency of the company is USD, the CAD amount does not change when updating the exchange rate ?

Proposed solution: Allow the end user to update the "Exchange Rate" on a Released (approved) Sales or Purchase Order

Thanks