-
New to NetSuite | Editing Consolidated Exchange Rates
Consolidated Exchange Rates are the specific rates NetSuite uses to roll up financial data from child subsidiaries into a parent company for reporting. While NetSuite calculates these automatically, manual overrides are often necessary during month-end closes to meet audit requirements or specific accounting standards. 1.…
-
New to NetSuite | Consolidated Exchange Rates: Understanding Rate Classifications
Consolidated exchange rates ensure that currency amounts are properly translated for consolidated reports. These rates represent the link between a subsidiary’s base currency and that of its parent or grandparent subsidiary for a specific accounting period. NetSuite automatically generates these rates when you create…
-
Reopening and bulk closing periods again can affect consolidated exchange rates?
Hi all, I think the answers is yes, but I wanted to better understand the reason for that. I guess this is because of the revaluation of previous periods, but I am not sure if this is how consolidated exchange rates table gets updated. Thanks in advance
-
Calculate Consolidated Exchange Rates
Submitting a question on behalf of a teammate. I would like to revisit an important question regarding the "Calculate Consolidated Exchange Rates" task and its effects on our ledger balances (P&L, BS, equity) and translated values when we re-run it. Should we re-run the "Calculate Consolidated Exchange Rates" task after…
-
CTA Elimination not zero
Hi Team, can anyone explain why the CTA Elimination account balance is not zero (screenshot below)? Does anyone have experience with this issue, and what is the best practice to find the root cause? I would greatly appreciate any help or discussion. Thank you.
-
Consolidated Exchange Rates on Saved Searches: Current Consolidated Exchange Rate (With Date/Period)
Scenario: A Journal Entry was created on September 16, 2025 with the following setup: Date = August 22, 2025 Posting Period = August 2025 Subsidiary = CANADA New Brunswick Subsidiary's Base Currency = CAD Transaction Currency = AUD Exchange Rate = 2.00 Account = 1100 Accounts Receivable General Rate Type per Account…
-
Consolidated Exchange Rates on Saved Searches
According to SA 7752, "Transaction saved searches that include values calculated based on consolidated exchange rates may not match the general ledger impact of these same transactions. The values in the saved search are translated to the base currency using the selected consolidated rate type." Per SA 7762, "You can…
-
Does anyone know what Quarterly Current Rate in NetSuite is?
In the Consolidated Exchange Rates System Notes, some of our records show that Quarterly Current Rate is changed. However, this field does not seem to be exposed in any record. Any idea or NS documentation you can share about this field? Appreciate any help!
-
Currency Exchange Rate Integration Feature: Past Rates Were Incorrect
This notice applies to customers with the Currency Exchange Rate Integration feature enabled in your NetSuite account, and you have configured your account to receive exchange rates from Xignite, one of our data providers. What Has Changed Due to an issue with Xignite, your NetSuite account received incorrect exchange…
-
NSC | How is Transaction Amount Calculated in Item Records (OneWorld)?
SCENARIO User is tasked with understanding how transaction amounts are calculated in item records within their OneWorld instance. Given the company's operations across multiple subsidiaries and currencies, the user wants to know how transactions found in the Related Records > Transaction section of the item record are…