Hi Everyone, I am performing a CSV import to creat...
# csvimports
v
Hi Everyone, I am performing a CSV import to create Item Fulfillment records. However, even after correctly specifying the inventory detail quantity and mapping it to the appropriate NetSuite field, I am still encountering error as "The total inventory detail quantity must be 3" . Any guidance or suggestions would be greatly appreciated.
r
I think I've always had to split up the files whenever I've imported stuff that required setting Lot/Serial values. Like you set up a header file, a line file, and a Lot/Serial file, then join them together in the importer. Someone smarter than me may know how to do it in one file, but I could never get it to work
b
It seems to me that you have a mapping issue. Are you mapping the quantity to both the item list AND to the inventory detail? If you follow the same logic that you would in the UI, you would set the value in the quantity column )or check the box for fulfill in a fulfillment) and then click into the inventory detail and set the serial (if exists) the bin and quantity.
s
There is a suiteanswer that explains how to do this, you can look up inventory adjustments with inventory details and change the transaction type