ANS-1333 · CSV IMPORT & DATA MIGRATION
How to Upload NetSuite Chart of Accounts with Parent-Child Relationships?
When importing a Chart of Accounts into NetSuite, correctly mapping the internal IDs for parent and sub-accounts is crucial for establishing hierarchical relationships.
Short answer
To successfully upload a NetSuite Chart of Accounts with parent-child (mother-son) relationships, ensure that only the internal IDs are mapped. Specifically, map the internal ID for the main account and the internal ID for its corresponding sub-account to establish the correct hierarchy during the import process.
Scenario
Users attempting to import a Chart of Accounts into NetSuite may encounter difficulties when trying to establish parent-child or "mother-son" relationships between accounts. The system requires specific mapping to correctly link sub-accounts to their respective parent accounts during the upload process.
Solution
To correctly upload a Chart of Accounts with parent-child relationships in NetSuite, the import process requires mapping only the internal IDs for both the parent and sub-accounts.
Map the Internal ID for the parent account.
Map the Internal ID for the sub-account.This ensures that NetSuite correctly recognizes and establishes the hierarchical structure between the main accounts and their associated sub-accounts.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support