Inventory Worksheet Import Process in NetSuite

The Inventory Worksheet Import feature in NetSuite allows users to efficiently adjust inventory levels using CSV files, rather than manually entering data through the user interface. This method is especially useful for large inventories or when conducting physical counts. By utilizing a provided template, users can quickly submit their inventory adjustments, saving time and reducing errors.

Benefits of the Inventory Worksheet Import

• Speed: Importing data via CSV is significantly faster than manual entry, especially for large inventory adjustments.
• Efficiency: Reduces the likelihood of human error associated with manual data entry.
• Simplicity: Users can easily prepare their adjustment data in a CSV format using the available template.

Key Limitations to Consider

When using the Inventory Worksheet Import, it’s important to be aware of the following limitations:

• Single Worksheet Creation: Each import can only create one new inventory worksheet; updates to existing worksheets aren't supported.
• Data Combination Restrictions: Each import accommodates only one combination of class, department, location, and subsidiary. Separate imports are necessary for varying combinations.
• No Bin Information: The import does not support importing bin data.
• Costing Method Limitations: The tool is best suited for average costing; it ignores LIFO and FIFO methods, meaning historic cost details will not be preserved.
• Unique Item Changes: Adjustments to lot-numbered items, serial-numbered items, and inactive items are not permitted. Assembly item changes only affect the assembly's quantity, not its component items.
• Line Limitations: The import can handle inventory worksheets of up to 1,000 lines. However, performance may degrade with larger worksheets, and timeouts may occur, causing some records to be unprocessed.
• Field Mapping: Users cannot save field mappings for subsequent imports.

Permissions Required for Import

To use the Inventory Worksheet Import feature, users need specific permissions: Adjust Inventory Worksheet and Import CSV File. By default, only account administrators have these permissions, which can be added to custom user roles as needed.

Steps to Import an Inventory Worksheet

1. Access the Import Assistant: Navigate to Transactions > Inventory > Adjust Inventory Worksheet > Import. Ensure you have the correct permissions.
2. Upload Your CSV File: Download the template and populate it with your record data. Upload it via the Assistant when prompted.
3. Review Field Mappings: The Assistant will automatically map CSV fields to corresponding NetSuite fields. You can modify these mappings as necessary before initiating the import.

For detailed CSV setup requirements, consult the guidelines on preparing your CSV file for optimal results. Consider reviewing related topics such as Making Inventory Adjustments for further efficiency.

Key Takeaways:

• The inventory worksheet import streamlines stock adjustments using CSV.
• Be mindful of restrictions like single worksheet creation and line limits.
• Proper permissions are necessary, typically requiring admin access.

Source: This article is based on Oracle's official NetSuite documentation.