Hi, Quick question. Does anyone know where the exc...
# administrationn
NS User
05/09/2024, 7:28 PMHi, Quick question. Does anyone know where the exchange rate value is pulled from on a purchase order?
s
sam1128
05/09/2024, 7:57 PMIt comes from exchange rate table. List > accounting > exchange rate
n
NS User
05/09/2024, 7:59 PMI thought so, but when I checked the exchange rate history I couldn’t find the value to 1.00
NS User
05/09/2024, 8:00 PMI have a PO submitted for INR and I am trying to convert that into USD. I want to used the exchange rate field value to convert the INR into USD.
s
Sam-I-Am
05/09/2024, 8:10 PMFx rate for the INR to INR. What is the base currency of the transaction subsidiary? Most likely INR🤔
n
NS User
05/09/2024, 8:10 PMINR
NS User
05/09/2024, 8:10 PMWe want to convert that into USD
s
Sam-I-Am
05/09/2024, 8:14 PMDoes this sub rolls up to a parent sub with USD base? Then you can look it up from the parent subs perspective. Other option is to multiply it with the USD fx rate of the day. Might be able to look it up in the GL impact in USD
n
NS User
05/09/2024, 8:16 PMI wanted to try with the second option of multiplying the INR with USD FX rate, that is why I used the standard exchange rate field available on PO
NS User
05/09/2024, 8:24 PMBut, it is not pulling the correct exchange rate of USD. It supposed to be 0.001 something like that but it shows 1.00
k
Karina
05/10/2024, 3:29 PMis your transaction in USD? is your entity’s base currency not USD? Only then you get your rate
👍 1
n
NS User
05/10/2024, 6:03 PMThe transaction currency is INR, and the subsidiary currency is also INR. Okay,I get it now. Since both are the same, it shows 1.00 as the exchange rate.
s
Sam-I-Am
05/10/2024, 6:07 PMThat's the point - header level transaction FX rate is against the sun's base currency