Bin Transfer Import
The bin transfer record is used to post details of inventory movement between bins within the same location. It shows the quantity of items to be decreased from the originating bin and increased in the destination bin. You can create and update it using the CSV Import Assistant.
The bin transfer 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, it appears as an option in the Record Type field.
Within the NetSuite UI, you can access and create a bin transfer record at Transactions > Inventory > Bin Transfer. For help working with this record manually, see Bin Transfers.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.
Sample Bin Transfer Single CSV File Format
You can create a single CSV file that contains the bin transfer 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 transfer 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.
|
External ID |
Date |
Location |
Item |
Quantity |
From Bin |
To Bin |
|---|---|---|---|---|---|---|
|
BT10000 |
7/18/2025 |
US-West |
Item A |
12 |
BinA001 |
BinA010 |
|
BT10001 |
7/18/2025 |
US-West |
Item B |
5 |
BinB001 |
BinB010 |
Sample Bin Transfer Multiple CSV File Format
You can create three separate CSV files, one for each section of the bin transfer record and linked through External IDs. You can add one ID column to identify each bin transfer record and another one for each item line. The following example includes details when the Advanced Bin/Numbered Inventory Management feature is enabled.
Header fields
|
External ID * |
Date |
Location |
Memo |
|---|---|---|---|
|
BT10000 |
7/18/2025 |
US-West |
Item A |
|
BT10001 |
7/18/2025 |
US-West |
Item B |
Item sublist fields
|
External ID * |
External ID 2 * |
Item |
Units |
Quantity |
|---|---|---|---|---|
|
BT10000 |
Line0010 |
Item A |
eaches |
25 |
|
BT10001 |
Line0100 |
Item B |
eaches |
50 |
Inventory Details subrecord fields
|
External ID 2 * |
From Bin |
To Bin |
From Status |
To Status |
Quantity |
Lot/Serial Number |
|---|---|---|---|---|---|---|
|
Line0010 |
BinA001 |
BinA010 |
Good |
Damaged |
10 |
|
|
Line0010 |
BinA001 |
BinA011 |
Good |
|
15 |
|
|
Line0100 |
BinB001 |
BinB010 |
Good |
|
50 |
Lot B |
* 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.