-
NSC | Updating the Date on an Existing Expense Report Causes Exchange Rate Error (Scenario 2)
Scenario 2: User cannot update or change the date on an existing expense report and encounters the error: “Exchange rate cannot be changed on an existing Expense Report.” Findings and Explanation When the user updates the Date field on an existing Expense Report, NetSuite automatically evaluates the exchange rate…
-
NSC | Exchange Rate Cannot Be Changed on an Existing Expense Report (Scenario 1)
In NetSuite, the exchange rate applied to an Expense Report is determined by the transaction date and the corresponding currency exchange rate available in the Currency Exchange Rates list. Once an Expense Report is created and saved, the exchange rate becomes fixed and cannot be modified. Any attempt to update the…
-
NSC | Troubleshooting Currency Exchange Rate Calculation
A user posted a journal entry for a Canadian subsidiary using CAD as the transaction currency. However, when running a consolidated report, the amount still appeared in CAD instead of converting to the parent company currency, USD. When consolidated reports do not show the expected currency conversion, review the following…
-
New to NetSuite | Methods for Updating Exchange Rates: CSV Data Import
In addition to manual exchange rate updates (New to NetSuite | Methods for Updating Exchange Rates: Manual Updates) and automatic exchange rate integration (New to NetSuite | Methods for Updating Exchange Rates: Automated Integration), you can also update exchange rates using the CSV Data Import method. When dealing with…
-
Vendor Bill Exchange Rate Override Updating Master Currency Rate
Hi , I came across some weird behaviour. After Overriding the vendor bill Payment exchange rate, master list exchange rate is changing for that currency, is this normal?
-
Pre- and Post-FX Rate Adjustment
We have a new process to manually upload FX rates rather than use the system calculated rates, and I would like to generate a report (could be a saved search) that shows the pre- and post- amounts for specific accounts given the adjusted rate. Has anyone run into something like this before? Is it just a matter of pulling…
-
New to NetSuite | Methods for Updating Exchange Rates: Manual Updates
One of the steps included in creating a currency record is to set up exchange rates, please see New to NetSuite | Set Up Currencies, between the base currency and foreign currencies to apply to transactions. Currency exchange rates are used to convert foreign currencies to base currencies, providing default rates for…
-
why are base amounts different when FX used same amount and same rate?
Can anyone explain why two lines in the same journal for the same FX amount would end up with slightly different USD (base currency) amounts? A single standard journal uses one rate so how can the base amount be different?
-
I can not change the currency to be applied in a purchase error
Hello, could you help me, please? I am trying to update the currency exchange rate from USD to MN (Mexican pesos) to be applied in a purchase order, but a message appears that does not allow me to do so. The message says: “The data has been unexpectedly modified during saving. Please contact your administrator.” Could you…
-
Currency Exchange Rate Calculation
My Dilley test account's company currency is USD. Currently the Canadian subsidiary (CAD) falls under AMERICAS (USD) Now I posted a journal for Canadian subsidiary with CAD amount, but when I run a consolidated report at AMERICAS, its not converting back in USD to show, its still showing the same CAD amount, which is…