The following tables provide details about the fields supported in a CSV file used for an inventory worksheet import.
| Header Field | Notes |
|---|---|
| Adjustment Account | Usually, an expense account for inventory adjustments. This field is required and should match the name of an existing account at Setup > Accounting > Manage G/L > Chart of Accounts. If the Use Account Numbers preference has been enabled at Setup > Accounting > Preferences > Accounting Preferences, NetSuite recommends that values include both account number and name, such as 11000 Accounts Payable. Number-only values, such as 11000, also are supported. Name-only values, such as Accounts Payable, are not supported when this preference is enabled. If this preference is not enabled, name-only values should be used. Note that account names may be non-hierarchical, even for sub-accounts. |
| Class | Must match the name of an existing class at Setup > Company > Classifications > Classes.Most CSV imports require the use of the full hierarchical name, but inventory worksheet import supports the use of the simplified name. For example, both Headquarters: Executive and Executive are supported. |
| Date | Required. Default value provided if CSV file does not include this field. |
| Department | Must match the name of an existing department at Setup > Company > Classifications > Departments.Most CSV imports require the use of the full hierarchical name, but inventory worksheet import supports the use of the simplified name. For example, both Marketing: Marcom and Marcom are supported. |
| Location | Required if the Multi-Location Inventory feature is enabled.Must match the name of an existing location at Setup > Company > Classifications > Locations.Most CSV imports require the use of the full hierarchical name, but inventory worksheet import supports the use of the simplified name. For example, for location name, both California: Los Angeles and Los Angeles are supported. |
| Memo | Provides a detailed description displayed in the transaction detail list and other reports.Maximum length = 4000. |
| Posting Period | An error is returned if a closed period is specified. |
| Reference # | Used to track adjustments. This number appears on register and account detail reports.Maximum length = 45.Default value provided if CSV file does not include this field. Note that if you provide a value that is already in use, an error occurs. |
| Subsidiary | Required for OneWorld accounts.Must match the name of an existing subsidiary at Setup > Company > Classifications > Subsidiaries.Most CSV imports require the use of the full hierarchical name, but journal entry import supports the use of the simplified name. For example, both EMEA: Germany, and Germany are supported. |
| Transaction Order | Required. Must use one of the following values: First transaction in the day – posts the worksheet at the beginning of the day and does not include additional inventory transactions entered during that day for this worksheet. The last transaction in the day – posts the worksheet at the end of the day and includes all inventory transactions entered during that day for this worksheet. |
Each line in the CSV file should include a different value for each line-level field.
| Line-Level Field | Notes |
|---|---|
| Item | Required. Item to be adjusted. Must match an existing item at Lists > Accounting > Items. You cannot reference the same item in multiple lines. Note By default item names should be used as values for this field, but you can also choose to use internal ID or external ID values. |
| New Qty | Required. The new total quantity on hand for the item. |
| New Value | Required. The new value for the new quantity of items in stock. |