A user posted a journal entry for a Canadian subsidiary using CAD as the transaction currency. However, when running a consolidated report, the amount still appeared in CAD instead of converting to the parent company currency, USD.
When consolidated reports do not show the expected currency conversion, review the following setup areas:
- Confirm the subsidiary base currency:
- Go to Setup > Company > Subsidiaries.
- Open the subsidiary record.
- Confirm that the subsidiary has the expected base currency assigned.
2. Go to Lists > Accounting > Consolidated Exchange Rates.
a. Filter by From Subsidiary, To Subsidiary, and Period.
b. Verify the Current, Average, and Historical rates.
3. Check Currency Exchange Rates:
a. Go to Lists > Accounting > Currency Exchange Rates.
b. Confirm that rates exist for the base currency and source currency combination.
4. Validate currency and exchange integration setup:
a. Go to Lists > Accounting > Currencies and confirm that the currency has the correct ISO code.
b. Review whether Currency Exchange Rate Integration is enabled.
c. Confirm whether exchange rates are set to update automatically or are manually maintained.
Please note that automatic Currency Exchange Rate updates apply prospectively. This means NetSuite generates exchange rates from the next immediate update based on the selected update time zone. Rates for earlier periods before the automatic update was enabled are not updated retroactively.