Scenario
User is using CSV import for Inventory Worksheets but will at times have problems with Item Name.
Solution
When creating a CSV import for Inventory worksheet, it is better to use IDs (be it Internal IDs or External IDs) of the item instead of Item Names.
- The internal ID is a NetSuite system-assigned ID number. To display internal ID values on NetSuite forms, go to Home > Set Preferences > Click the General subtab, and in the Defaults section, check Show internal IDs. When this preference is enabled, a list displays the IDs as one of the columns.
- The external ID is an ID number used by an external system. A record has an external ID only if the user created one when bringing the record into NetSuite.
In this way, you are less likely to encounter any errors in the import also less likely to have any clerical error when using IDs instead of the Item Name.
For other things to consider for Inventory Worksheet CSV, please refer to SuiteAnswers ID: 20038.
-----
If you find this information useful, let us know by reacting or commenting on this post!