Seek assistance in solving the following issues related to P.O in foreign currency. Thanks in advance
1, For purchase orders in foreign currency, during MIGO,in the FI document, the inventory value which include cost payable to the vendor, taxes, CHA and freight are calculated in foreign currency and the company code currency value is arrived by multiplying the total inventory value with the exchange rate prevailing in Ob08 on the posting date of MIGO, instead of adding the values of basic price converted to local currency at the rate prevailing on MIGO, Custom duty at the rate prevailing on Customs Miro and Freight CHA etc which are inputted in local currency and converted to P.O currency in P.,O, at the exchange rate in P.O
The value thus arrived is different from the actual value paid since the freight and CHA are in co code currency in the P.O and converted to P.O currency in P.O with exchange rate prevailing on the date of P.O and Custom duty paid in local currency is at the rate prevailing on Custom MIRO.
2, Freight and CHA are entered as condtions in the P.O and the values entered in local currency. These are converted to P.O currency by the system at the exchange rate prevailing on the P.O date. During MIGO in the FI document the values for these are arrived by multiplying the value in P.O currency with the exchange rate prevailing on MIGO. for e.g. the CHA lumpsum entered as INR 20,000 is converted to $ 400, assuming the OB08 rate on the date of P.O is 50. if on the date of MIGO OB08 is 60, during MIGO, in the FI document entry for local currency the CHA charges become 24000. ( 400 x 60 ). While the actual amount is 20,000. the same scenario exist for freight too which is entered in local currency.
WHAT IS HAPPENING
1. Foreign Vendor - Foreign Currency X OB08 rate on MIGO Posting Date
2. Freight - Company Code Currency Converted to Foreign Currency as per OB08 rate on PO Creation Date X OB08 rate on MIGO Date
3. CHA - Company Code Currency Converted to Foreign Currency as per OB08 rate on PO Creation Date X OB08 rate on MIGO Date
4. Customs - Company Code Currency Converted to Foreign Currency as per OB08 rate on Actual Customs Payment Date X OB08 rate on MIGO Date
WHAT IS REQUIRED
1. Foreign Vendor - Foreign Currency X OB08 rate on MIGO Posting Date
2. Freight - Company Code Currency Converted to Foreign Currency as per OB08 rate on PO Creation Date X OB08 rate on PO Date
3. CHA - Company Code Currency Converted to Foreign Currency as per OB08 rate on PO Creation Date X OB08 rate on PO Date
4. Customs - Actual Customs Duty paid in Company Code Currency through Customs MIRO