Skip to content
+1-888-319-3663

COMMUNITY FORUM

Update inventory item with a location code during import to Sales Order Entry

Lewis asked 3 years ago
Is there a way to update the inventory Item Location Code during an import into the sales order entry window?
Error Number = 110 stored Procedure = taSopLineIvcInsert Error Description = Item number/location code does not exist in inventory.
 
This happens because the location code is not added.  To manually fix this the user needs to go to Item Maintenance>Site Item Assignments and mark the warehouse code that is required. 
My second option would be to run two imports, however that seems a little crude and wonder if there is one import that will satisfy the sales order and site requirements.
Answers
Best Answer
Patrick Roth Staff answered 3 years ago
Out of the box, no.
However you can always use the Node Maintenance window to add the “add item to site” node to the SOP Order node.  Then it’ll show up in the sop map just the same as it was there natively. 
Just make sure that the order of the nodes that this one comes before the ‘add line item’ node since you need it to happen first.
Once you have that, map normally. 
patrick
Lewis answered 3 years ago
Patrick,
 
That sound like the answer I was looking for.  I will give it a try and let you know if I have any troubles.
Thanks
Lewis
 

If you would like to submit an answer or comment, please sign in to the eOne portal.