Scenario:
- Consider Subsidiary A is the parent of Subsidiary B.
- The Base Currency of Subsidiary A is USD Currency of Subsidiary B is CAD
- Transaction posted in Subsidiary B is using the base currency of subsidiary A.
- Why is NetSuite returning different values for the GL Impact of the transaction?
Solution:
- The GL Impact of a foreign currency denominated transaction will be calculated based on the Foreign Currency Amount times the Exchange Rate.
- Default List Views will show the amount based on the Consolidated Exchange Rates between Subsidiary A and Subsidiary B
- Search Results/Custom List View will display the amount based on the “Consolidate Exchange Rate Type” selected on the search. This field is found on the Results tab.
For Example:
Base Currency of Subsidiary A is USD
Base Currency of Subsidiary B is CAD
Consolidated Exchange Rate of 1.3
Invoice from Subsidiary B:
Currency =USD
Amount = 100
Exchange Rate= 1.2
GL Impact will show an amount of 120 (100 x 1.2)
The invoice will show as 130 if viewed via Transactions > Sales > Create Invoices.
If viewing the results from a search, this will be shown as 130 by default. If you want to display it in the base currency of the subsidiary it was posted to, set the “Consolidate Exchange Rate” type to “None”
