NetSuite's default search configuration displays amount values in saved searches using the base currency of the parent subsidiary for OneWorld accounts, and the base currency for standard NetSuite accounts that do not have OneWorld enabled.
To show amounts in the subsidiary currency, you need to set the CONSOLIDATED EXCHANGE RATE as NONE on the saved search specified in the "SAVED SEARCH ID FOR INVOICING RESULTS" field. Additionally, specify "subsidiary.currency" in the "INVOICE CURRENCY" field in the invoice setup screen.
Note: For standard NetSuite accounts without OneWorld enabled, amounts will always be shown in the base currency. In this case, specify your base currency as text:USD in ISO format in the "INVOICE CURRENCY" field of the invoice setup screen.
To display amounts in the invoice response in either the transaction currency or the customer's currency, please follow the steps below:
- In the invoice search, create formula fields to display amounts in the desired currency. Additionally, make sure to include fields for the invoice currency or customer currency in your saved search.
- Replace the field IDs of your new formula columns, which store amounts in the desired currency, with the corresponding column numbers in the invoice setup screen under the amount fields. Also, specify your custom currency field in the "INVOICE CURRENCY" field.
- Ensure that you map your currency with the PromoStandards currency in the invoice setup screen.
