Scenario:
This error means that one or more of the user's expense report records are missing required sublist data—such as individual expense lines. Every expense report must include at least one sublist entry.
If the user is using a multiple-file import, the error may be due to an issue with the key column used to link the files. For example, if there's a typo or mismatch in the key column (like an incorrect Internal ID or external key), NetSuite won't be able to connect the main expense report data with its related line items
Solution: (Example import)
- Go to Setup > Import/Export > Import CSV Records
- Import Assistant: Scan & Upload CSV File
- IMPORT TYPE: Select Employees
- RECORD TYPE: Select Expense Reports
- CSV File(s): Select MULTIPLE FILES TO UPLOAD
- Primary File - Expense Report: Select CSV File for Body fields
- Linked File (Optional) - Expense Report - Expenses: Select CSV File for Sublist Fields
- Click Next
- Import Assistant: Import Options
- Data Handling: Select ADD
- Click Next
- Import Assistant: File Mapping
- PRIMARY FILE KEY COLUMN: Select BODY: External ID
- Column dropdown: Select LINE: REF NO.
- Click Next
- Import Assistant: Field Mapping
- Note: The user don't need to add a mapping for Ref No. as this can be automatically generated upon import.
- —
- Click Next
- Populate IMPORT MAP NAME
- Click Save and Run
Hope this helped!