Inventory Worksheet Import Permissions and Limitations

The Inventory Worksheet Import feature provides a streamlined alternative for adjusting inventory levels in NetSuite. By using a CSV file based on a system-provided template, users can quickly and accurately create new inventory worksheets. This functionality is particularly beneficial for high-volume inventory adjustments post-physical counts or at the conclusion of a NetSuite implementation.

How Does the Inventory Worksheet Import Work?

Using the Inventory Worksheet Import, users can create adjustments without the need to fill out each entry manually on the Inventory Worksheet form. This method is especially advantageous when dealing with numerous inventory items, allowing for faster data entry.

Key Uses

• Post-Inventory Adjustments: Great for entering changes after conducting physical inventory counts.
• Implementation Reset: Useful when resetting stock quantities and values during the implementation phase of NetSuite.

Inventory Worksheet Import Limitations

While the Inventory Worksheet Import can significantly speed up the process of data entry, it does come with certain limitations that should be considered:

• Single Worksheet Creation: Each import can only generate one new inventory worksheet; it cannot update existing ones or create multiple worksheets at once.
• Combination Limits: Each import supports only one combination of class, department, location, and subsidiary, necessitating multiple imports for varying categories.
• Bin Information Excluded: The import currently does not allow for the import of bin details.
• Costing Method Constraints: The import primarily operates under average costing, as it does not accommodate LIFO or FIFO methods.
• Assembly Item Changes: Adjustments to assembly items affect the assembly itself but do not adjust the quantities of individual components.
• Line Limitations: Users can import inventory worksheets with up to 1,000 lines, but performance may degrade with larger lists, and some records might remain unprocessed if timeout limits are reached.
• Field Mapping Constraints: Saving field mappings is not supported, which may require manual configuration for each import.

Required Permissions for Import

To successfully execute an inventory worksheet import, users must possess the following permissions:

• Adjust Inventory Worksheet: By default, only account administrators possess this permission; it is not assigned to standard roles. However, it can be added to custom roles for users performing imports.
• Import CSV File: This permission is necessary to enable the CSV file import functionality.

Additional Resources

• For detailed import interface guidelines, refer to the Using the Inventory Worksheet Import Assistant documentation.
• Check out the Requirements for Inventory Worksheet CSV File Data for tips on setting up your CSV file correctly.