Scenario Resolve Error: “Please Make All Abbreviations Unique. They Will Be Used To Automatically Generate Matrix Subitem Name/Numbers” This happens when an Inactive value in the Custom List uses a duplicate abbreviation from the active values or the CSV file being uploaded. Navigate to Customization > Lists, Records, & Fields > Lists Preferred Custom List:… Continue reading Resolving Duplicate Abbreviation Errors in CSV When Adding or Updating Custom List Values
Tag: csv import error
Understanding CSV Import Limitations
SuiteAnswer ID: 10915 Access Level: Administrator, System Integrator Overview This article explains NetSuite’s CSV import capabilities, including file limitations, field formatting rules, and workarounds for importing attachments. Use this guide to: ✔ Avoid common import failures ✔ Structure files correctly for transactions/records ✔ Implement solutions for advanced needs (e.g., attachments) 1. File Size & Row Limits Hard… Continue reading Understanding CSV Import Limitations
GST Tax Rate Rules CSV Import
When importing GST Tax Rate Rules using the CSV Import Assistant, ensure the following steps are followed for the rules to show under the GST Tax Rate Rule page: Navigate to the Setup > Import/Export > Import CSV Records Use the Record Type = Tax Rate Rule instead of the GST Tax Rate Rule. On… Continue reading GST Tax Rate Rules CSV Import
Custom field is absent from the available NetSuite fields for mapping in the CSV Import Assistant.
Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > List Click the Name of the Custom Field On the Transaction Body Field page > Under Display tab > Set Display Type field to Normal Click Save
Fix the “Gateway Timeout Error” in Resource Allocation
Scenario The error is being thrown when updating Resource Allocation End Date. The Resource Allocation for one employee was incorrectly set up and the End Date was set to 1/22/60×8 instead of 12/13/20×8. The allocation was only for 0:25 hours. The Allocation Type of the Resource Allocation is set to Hard. When user tried to… Continue reading Fix the “Gateway Timeout Error” in Resource Allocation
How to resolve error: “Entity XX can only be used in transactions marked for elimination” in Journal Entry import
This error encounters when doing a CSV import for Journal Entries. For this type of error, please note that the XX in ‘Entity XX’, (whether Customer or Vendor entity) is an Entity ID and not an Internal ID. To resolve the error, consider either the following: Change Internal ID of XX Customer with another entity on the CSV file where… Continue reading How to resolve error: “Entity XX can only be used in transactions marked for elimination” in Journal Entry import
Error on CSV Import of Transactions: “Invalid entity reference key xx for subsidiary yy.”
Scenario User is trying to import a data through CSV but gets an error message stating: “Invalid entity reference key xx for subsidiary yy.” Solution The numbers (xx and yy) found in the error are the Internal IDs of the Entity record (Customer, Vendor, Employee, Other Name) and Subsidiary respectively that are found in NetSuite account 1.… Continue reading Error on CSV Import of Transactions: “Invalid entity reference key xx for subsidiary yy.”
Character Limit for Various Fields via csv import
The limit or Maximum Number of Characters for External ID for CSV Import is 255 characters. The maximum number of characters allowed on some of the standard fields on the entity records is listed below. Main tab Customer ID: 83 Company Name: 83 Mr./Ms.: 15 First/Middle/Last Name: 32 Phone: 22 Fax: 21 Email: 254 Web Address: 99 Job… Continue reading Character Limit for Various Fields via csv import
State and Province Names for CSV Import
State and province names in CSV files need to match Short Name values listed at Setup > Company > States/Provinces/Counties. If a CSV file includes the full names of states or provinces rather than short names, the import job may be complete, but state or province values may not be saved correctly. To avoid errors,… Continue reading State and Province Names for CSV Import
Error: “Invalid doc reference key” upon Customer Payment CSV Import
Scenario User is importing a Customer Payment uses the External ID of the Invoice in the CSV Template and receives the error “Invalid doc reference key”, ensure that the Reference type for the Invoice field is set to External ID. Solution Navigate to Setup > Import/Export > Import CSV Records Import type: Select Transactions Record type: Select Customer Payment CSV File(s): Upload CSV file Click Next Data… Continue reading Error: “Invalid doc reference key” upon Customer Payment CSV Import