Exchange rate payment and ordering issue

[Former Member]

Dear All,

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

Regards

Akber

[former_member826946 · Accepted solution]

While creating the sales order, maintain the pricing date as required.

Pricing date field is available above Inco terms in the main screen which controls date for exchange rate determination.

[Former Member]

Hi Suresh

Keep the pricing date as  Order date in Sales Order pricing date and  exchange rate in copy control (VTFA or VTFL) at the item category level for  Pricing Exchange Rate Type (V_TVCPFLP-PFKUR)  as A or D .

A Copy from sales order

D Exchange rate determination according to pricing date

Please test the result and see if that works ?

Regards

Santosh Verma

[Former Member]

Hi Santosh,

I think would not work because, lets assume, if the advance payment is made on 18th Feb, and exchange rate is 100, and ordering is done on 25th and during this time exchange rate goes up to 100.2, then according to your solution(A or D) still pricing date will be picked which is 25th and not 18th , which is the payment date.

Regards

Akber

[Former Member]

Hi Akber

Keep the Pricing date in sales Order as 18th . Hope this helps.