Table of Contents

Update Inventory (Bulk)

Updated

Step 1: Download Files

Inventory Adjustment Primary

BLOS - Inventory Adjustment Primary Sample.csv

Contains one row per item that you are updating.

External ID An ID for the import, not item. This ID is arbitrary and should be the same for every row in the import

Adjustment Account

Subsidiary Always use 2

Date Date of inventory change

Inventory Adjustment Secondary

BLOS - Inventory Adjustment Secondary Sample.csv

Contains one row per item that you are updating.

External ID An ID for the import, not item. This ID is arbitrary and should be the same for every row in the import

Item Item ID (e.g. CCMP1755-SC). If it is a matrix item, this value shoule refer to a chield element (e.g. starter culture), not the parent (e.g. CCMP1755)

Item External ID Same as Item

Location Always Cryopreservation Laboratory

Adjust Quantity By Sum of all quantity adjustments in BLOS - Inventory Adjustment Tertiary

Inventory Adjustment Tertiary

BLOS - Inventory Adjustment Tertiary Sample.csv

Contains one row per item and per bin that you are updating.

Item External ID Same Item External ID as

Bin Bin number, e.g. T1-L1-QB-B1-C12

Lot Number A lot number for this item/bin. If you are adding an item to a bin that already contains the same item, the lot number must be unique for that item/bin combination.

Quantity Number of items being added or subtracted (negative number) from the bin.

Step 2: Add data to files

Populate the sample files with your data per the instructions above.

Don't forget to rename the files to avoid confusion with the sample files. Keep the words primary, secondary, and tertiary in the file names.

Step 3: Import sample files

  1. Log into NetSuite
  2. Navigate to Setup > Import / Export > Saved CSV Imports (or click the link in step 3)
  3. Click on 117 BLOS - Bulk Inventory Adjustment
  4. Under the CSV Files section, there are three files to upload. Upload the primary first, secondary second, and tertiary, third.
  5. Click Next
  6. Select ADD OR UPDATE
  7. Click Next
  8. Click Next on the File Mapping screen
  9. Click Next on the Field Mapping screen
  10. Click on the arrow next to "Save As & Run" and select "Run"
  11. You can view the status of your import by navigating to Setup > Import / Export > View CSV Import Status

Troubleshooting

If there is an error with one or more lines in the CSV file, you will see something like this on the status page

To view the error messages, click on the CSV Response link. This downloads a results.csv file with one line for each failed record import. See the table below for example errors and explinations.

Error

Explanation

Please enter value(s) for: Serial/Lot Number

If you are adding an item to a bin that already contains the same item, the lot number must be unique for that item/bin combination.

Still need help? Submit a ticket.

How did we do?

Edit NCMA Website

Upload New Bin Numbers

Powered by HelpDocs (opens in a new tab)