Can data from NetSuite be imported into Adaptive in US Dollars when importing consolidated reports with multiple currencies per subsidiary?
The customer plans using the following currencies: USD, GBP, Indian Rupee, Canadian Dollar, Euro and Australian Dollar but their base currencies are USA, GBP and Indian Rupee. They categorize data by department and location.
There are two options:
1. Build in the currency structure at the subsidiary level and then the data can be brought in as any currency and rollup to the plan level in USD based on the exchange rate.
2. Run a report from NetSuite in USD and then manually import it into Adaptive Insights.
Planning in Foreign Currency - If a client is planning in Multi-currency in NetSuite(NetSuite’s OneWorld multi-currency subsidiary feature), we must build the plan structure at the subsidiary level in Adaptive Planning. If we attempt to bring the data over at an aggregate level, the imported numbers do not make any sense. The clients can see the data at an aggregate/converted level in NetSuite, but when it is imported, NetSuite gives the sum of the unconverted data.
There is no other workaround for this situation including the NetSuite API which is not designed to bring in the USD information at an aggregate level.