Understanding Currency Exchange Rates for Sales Order Transactions
If you have sales order transactions with amounts in a foreign currency, you must run the Taiwan Ten-Days Exchange Rate program before you run the Customer Sales Update program (R42800). The Taiwan Ten-Days Exchange Rate program updates the transaction amounts and currency exchange rate in the Sales Order Detail File table (F4211) based on the values that you set up in the processing options and the Currency Exchange Rate Entry program. The Taiwan Ten-Days Exchange Rate program updates the sales order amounts in F4211 using multiplier or divisor based on what you set up in the Currency Exchange Rate Entry program.
The system updates these fields in the F4211 table and creates matching records in the SO Detail Ledger File table (F42199):
Currency Conversion Rate - Spot Rate
Amount - List Price
Amount - Price per Unit
Amount - Extended Price
Foreign Unit Cost
Foreign Extended Cost
If you had processed the sales order using the Use Taxed Prices (UTP) logic, the Taiwan Ten-Days Exchange Rate program updates the domestic taxed prices in the F4211TX table and inserts the updated taxed prices in the F42199TX table. To verify this, the system checks the value of TPSC in the F4009T1 table. If the value of UTPPSC is 1 and the value of UTP is 1, that indicates that the sales order was processes using the UTP logic.