Here are the values I am using (highlighted in yel...
# suiteanalyticsr
Rafa
11/08/2019, 5:27 PMHere are the values I am using (highlighted in yellow) when the "Average" rate is applied. I am loading the value in the Amount field into another application that then converts back to USD (consolidated base currency) using the Consolidated Average Exchange Rate from NetSuite for the correct period. But the currency conversion doesn't align to the ratio between the two values below.
j
Jon Kears
11/10/2019, 11:45 PMAmount (foreign currency) x exchange rate will give you local currency
Your consolidated Amount (using average) should be equal to Amount (foreign currency) x exchange rate x consolidated exchange rate
Jon Kears
11/10/2019, 11:47 PMNote that consolidated exchange rate is not possible to look up without using the option in your saved search (there are no linked tables in the saved search)
Jon Kears
11/10/2019, 11:47 PMIt is possible to do it over ODBC though
Jon Kears
11/10/2019, 11:50 PMBut note for balance sheet accounts like bank accounts, the formula should be
Amount (foreign currency) x exchange rate x consolidated exchange rate for the closing period
You will not be able to get other period end values
Jon Kears
11/10/2019, 11:52 PMMost of my saved searches are using consolidated exchange rate "none" and then I use a trusty vlookup in excel
r
Rafa
11/12/2019, 11:00 PM@Jon Kears Thanks for the responses. You nailed it on the "None". I'm very new to NetSuite so in my head I didn't have a handle on the data model. Once I flipped the value to "None" and did some back of the napkin calcs I realized "None" gave me the correct Amount value in the functional currency, which is exactly what I wanted.
4 Views