Im working in an FMCG company where we work on advance payment model. Customer sends us payment and then we can place sales order against that customer. We are facing an issue with our export customers, that when they send payment in dollar ($), the exchange rate is say 100, after 3 or 4 days, the exchange rate changes, and after that when we place order system converts the dollar to local currency on the date of order and not according to the payment's exchange rate. Lets assume that after 3 days of payment, the exchange rate goes up to 100.2, and then when we place order the system doesnt allow us to place order.
I want that the order value to be placed is equivalent to the payment's exchange rate done by the customer?
Please suggest a possible way out for this issue