This article is intended for accounts integrated with Adaptive Insights, NetSuite's partner in delivering financial management solutions.
Discrepancy after import of Data coming from NetSuite to Adaptive Insights is noticed when comparing balances coming from a report, e.g. Income Statement, with the Financial Planning Sheet is due to duplicate mapping of accounts.
Navigate to Financial Planning>Admin>Import>NetSuite Import Category Mappings.
1. Set Financial Planning Dimension to Account
Ensure that the Mapped Financial Planning Account has no duplicate mapping with NetSuite Account Name [Number] Accounts.
2. Set Financial Planning Dimensions to Level
Ensure that the Mapped Level has no duplicate mapping with NetSuite Department
3. Set Financial Planning Dimensions to Location
Ensure that Mapped Dimension Value has no duplicated mapping with NetSuite Location
Check the changes Financial Planning Sheet against NetSuite Report.