Bin Putaway Worksheet Import
The bin putaway worksheet record is used to post details of initial bin assignments for items in a location. Aside from received items, you can initially assign bins to items that result from positive adjustments. Both bins and locations that you include in a worksheet must be set to use bins. You can create and update this record using the CSV Import Assistant.
The bin putaway worksheet record is available for import when the Bin Management feature is enabled on your account. Within the Import Assistant, on the Scan & Upload CSV File page, you'll see it as an option in the Record Type field.
Within the NetSuite UI, you can access and create a bin putaway worksheet record at Transactions > Inventory > Bin Putaway Worksheet. For help working with this record manually, see Updating Bin Putaway Worksheets.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.
Sample Bin Putaway Single CSV File Format
You can create a single CSV file that contains the bin putaway details that you want to import. Each row should contain the details specific to an item. If you have multiple inventory detail lines for a single item line, you can add another ID column to identify each item line. To include items in the same bin putaway worksheet record, repeat the common details such as the External ID and date. You can also repeat an item line ID to associate inventory detail lines that belong to it. To specify each inventory detail line, include a separate line number column.
This example includes details when the Lot Tracking and Advanced Bin/Inventory Management features are enabled.
|
External ID 1 |
Date |
Location |
Item |
Qty |
|---|---|---|---|---|
|
BPW101 |
7/18/2025 |
US-West |
Item A |
12 |
|
BPW101 |
7/18/2025 |
US-West |
Lot Item B |
10 |
|
BPW101 |
7/18/2025 |
US-West |
Lot Item B |
10 |
(continued)
|
External ID 2 |
Line Number |
Bin |
Lot/Serial Number |
Inventory Detail Qty |
|---|---|---|---|---|
|
Line101 |
1 |
BinA001 |
|
12 |
|
Line102 |
1 |
BinB001 |
LotB1 |
4 |
|
Line102 |
2 |
BinB002 |
LotB2 |
6 |
Sample Bin Putaway Multiple CSV File Format
You can create three separate CSV files, one for each section of the bin putaway worksheet record and linked through External IDs. You can add one ID column to identify each bin putaway worksheet record and another one for each item line. To specify each inventory detail line, add a separate column for the line number.
This example includes details when the Lot Tracking, Advanced Bin/Numbered Inventory Management, and Inventory Status features are enabled.
CSV File 1: Header fields
|
External ID 1 * |
Date |
Location |
|---|---|---|
|
BPW101 |
7/18/2025 |
US-West |
CSV File 2: Item sublist fields
|
External ID 1 * |
External ID 2 * |
Line Number 1 |
Item |
Units |
Qty |
|---|---|---|---|---|---|
|
BPW101 |
Line101 |
1 |
Item A |
ea |
12 |
|
BPW101 |
Line102 |
2 |
Lot Item B |
ea |
10 |
CSV File 3: Inventory Details subrecord fields
|
External ID 2 * |
Line Number 2 |
Bin |
Lot/Serial Number |
Inventory Status |
Inventory Detail Qty |
|---|---|---|---|---|---|
|
Line101 |
1 |
BinA001 |
|
Good |
12 |
|
Line102 |
1 |
BinB001 |
LotB1 |
Damaged |
2 |
|
Line102 |
1 |
BinB002 |
LotB1 |
Good |
2 |
|
Line102 |
2 |
BinB002 |
LotB2 |
Good |
6 |
* On the File Mapping page of the Import Assistant, be sure to set the following fields:
-
Primary File Key Column – Select External ID.
-
Parent File Key Column and Subrecord File Link Column – Select External ID 2.