Inventory Worksheet Import Limitations
Review the following limitations to decide whether this import would be useful for you:
- Each import can create one new inventory worksheet. You cannot use the inventory worksheet import to update an existing NetSuite inventory worksheet or to create multiple inventory worksheets at one time.
- Each inventory worksheet import can import data for one combination of class, department, location, and, if applicable, subsidiary values. You must do multiple import jobs to import data for multiple classes, departments, locations, or subsidiaries.
- The inventory worksheet import currently does not support the import of bin information.
- Like the inventory worksheet form in the user interface, this import is best suited if you are using average costing. The import, like the UI form, ignores LIFO and FIFO, so does not preserve that history.
- The inventory worksheet import shares other limitations of the inventory worksheet form, including:
- New quantity values are exclusive of previous stock totals.
- Adjustments to lot numbered items, serial numbered items, and inactive items are not supported.
- A change to the quantity of an assembly item changes the quantity of the assembly only; it does not change the quantity of individual member items.
- Import is supported for inventory worksheets with up to 1,000 lines. However, poor performance results during import and in the user interface for inventory worksheets with over 1,000 lines, and these large inventory worksheets may not be editable in the user interface. Note that 1,000 lines are not always processed by the import. If the timeout limit is reached during the import process, some records are not processed. In this case, try the import with fewer than 1,000 lines.
- You cannot save field mappings for an inventory worksheet import.