Here is the reason why NetSuite shows different amounts for the same transaction in searches/list

Posted by CuriousRubik on 06 Aug, 2014


  • 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?


  • 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”

Topics: Accounting

Download E-Books

NetSuite CuriousRubik
NetSuite CuriousRubik