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

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.