ANS-1610 · CSV IMPORT & DATA MIGRATION
How to Locate and Use the Single Inventory Worksheet CSV Template in NetSuite
Access the NetSuite Single Inventory Worksheet template to efficiently import inventory adjustments via CSV.
Short answer
The Single Inventory Worksheet CSV template is located in NetSuite under Transactions | Inventory | Adjust Inventory Worksheet | Import. This template facilitates bulk inventory adjustments, but it's important to note that imported data will use Average Cost and does not support bins or lot/serial numbered items.
Scenario
Users often need to perform bulk inventory adjustments in NetSuite and require a specific CSV template for this purpose. Locating the correct template and understanding its limitations are crucial for a successful import process.
Solution
To locate the Single Inventory Worksheet Template File, navigate within NetSuite to Transactions | Inventory | Adjust Inventory Worksheet | Import. On this page, a link will be available to download the template file.When utilizing the Inventory Adjustment Worksheet for imports, please be aware of the following important considerations:* The import process will bring in all inventory at Average Cost.* While the NetSuite user interface (UI) supports bins and lot / serial numbered items for inventory adjustments, the import functionality for the Inventory Adjustment Worksheet does not support these features.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support