ANS-0983 · ONEWORLD & MULTI-SUBSIDIARY
How to Correctly Retrieve Transaction Totals in NetSuite OneWorld Searches
Understand how NetSuite's currency conversion formula impacts transaction totals in saved searches and how to configure searches for accurate subsidiary-specific values.
Short answer
When scripting searches for transaction 'amount' in NetSuite OneWorld, the system applies a currency conversion formula that defaults to the top-level parent subsidiary's value. To obtain the actual subsidiary transaction value, configure the saved search to set the 'Consolidated Exchange Rate' option to 'None' before calling it in your script.
Scenario
In NetSuite OneWorld environments, users may encounter discrepancies when retrieving transaction totals via script. The system's default behavior for the 'amount' search field applies a specific currency conversion formula, which can lead to unexpected consolidated values rather than the actual subsidiary-specific transaction total, causing errors in sum calculations.
Solution
NetSuite applies a specific formula when the 'amount' search field is used, which converts the transaction total to the top-level parent subsidiary's currency:
amount/[actual currency exchange rate] * [consolidated Exchange rate]This default conversion means that using the 'amount' search field will always return the top-level parent subsidiary's amount value, potentially causing errors in search sums.
To retrieve the actual subsidiary transaction value, configure the saved search as follows:
Create or edit the saved search in NetSuite.
Ensure the 'Consolidated Exchange Rate' option is set to 'None'.
Call this configured search within your script.
Expert NetSuite Support
Need help with this NetSuite issue?
OneWorld & Multi-Subsidiary consulting and configuration support