ANS-1418 · CSV IMPORT & DATA MIGRATION
How to Resolve ‘Please Enter Value(s) for: Account’ During Vendor Bill CSV Import
When importing Vendor Bills via CSV, ensuring the 'Account' field is correctly mapped on the Expense sublist is crucial to prevent validation errors.
Short answer
The error "Please enter value(s) for: Account" during Vendor Bill CSV import occurs when the 'Account' field on the Expense sublist is not properly mapped. To resolve this, ensure the CSV mapping explicitly includes and correctly populates the 'Account' field for each expense line, as it is essential for successful import of Vendor Bill expenses.
Scenario
Users attempting to import Vendor Bills via CSV may encounter a validation error prompting them to "Please enter value(s) for: Account". This issue arises when the CSV mapping for the Vendor Bill Expense sublist does not correctly specify the required 'Account' field for each expense line.
Solution
To successfully import Vendor Bills with expense lines, the CSV mapping must correctly specify the 'Account' field on the Vendor Bill Expense sublist.
Ensure that the CSV file includes a column for the 'Account' field for all expense lines.
During the CSV import process, explicitly map this column to the 'Account' field within the Vendor Bill Expense sublist.
Verify that each expense line in the CSV has a valid NetSuite account specified in the mapped column.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support