Update inventory item with a location code during import to Sales Order Entry
Lewis asked 4 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.
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 4 years ago
Patrick Roth Staff answered 4 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
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