Update Purchase Order Inventory Detail with Multiple Serial Number

Scenario

User needs to update or add serial number (multiple serial number) on Purchase Order's Inventory Details through CSV Import.

Solution

1. Create a CSV file in Excel
2. Enter fields
   • Internal ID
   • Item Name
   • Location
   • Quantity
   • Inventory Detail Line Quantity
   • Serial/Lot Number
   • Line ID
3. Navigate to Setup > Import/Export > Import CSV Record
4. Step 1 Scan and Upload CSV File:
   • Import Type: Select Transactions
   • Record Type: Select Purchase Order
   • Select One file to upload > Select... button: Select CSV file created to upload
5. Click Next
6. Step 2 Import Options:
   • Select Update
7. Click Next
8. Step 4 Field Mapping: Map the Your Fields and NetSuite Field
   • Internal ID <-> Purchase Order : Internal ID
   • Item Name <-> Purchase Order : Item
   • Location <-> Purchase Order Items : Location
   • Quantity <-> Purchase Order Items : Quantity
   • Inventory Detail Line Quantity <-> Purchase Order Items : Quantity
   • Serial/Lot Number <-> Purchase Order Items - Inventory Detail : Receipt Inventory Number
   • Line ID <-> Purchase Order Items - Inventory Detail : Surrogate Subrecord ID
9. Click Next
10. Enter Name on Import Map Name field
11. Click Save & Run