How to Display Local Subsidiary Amounts in NetSuite Consolidated Reports?

To retrieve and display the local subsidiary amount of a transaction, the 'Foreign Amount' field in NetSuite is the relevant option.When working with consolidated reports:1. Access the desired consolidated report.2. Customize the report to explicitly include the 'Foreign Amount' field. Consolidated reports typically default to displaying amounts in the parent subsidiary's base currency, so direct inclusion of 'Foreign Amount' is necessary to show the local subsidiary amount or the original transaction currency.For saved searches, particularly in complex multi-currency and multi-subsidiary environments:1. Add the 'Foreign Amount' field to the search results.2. Be aware that the behavior of this field can be nuanced. Depending on the specific search criteria and currency translation settings, additional formulas or configurations may be required to accurately display the original transaction currency amount.