Hi ALL! I’m trying to update the lines on an ITEM ...
# general
k
Hi ALL! I’m trying to update the lines on an ITEM FULFILLMENT in NetSuite. Currently, the department line level field is blank and I would like to populate them via the CSV Importer tool of Celigo. This is my mapping BUT I keep getting this error: Failed to create, update/transform record because You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist. Tip: Please make sure that all the line items that you’re trying to use exist on the record.
m
In the settings of the item name mapping check the box that says “use this field to find existing lines”. Also set dynamic mode = T
s
I would just use LineID as the key and take the Item Name out (unless you're trying to update that as well?) Also, if it's an Import set as Update or Add/Update I don't think you need the Internal ID mapping at the top as the 'How Can We Find Existing Records' will do that for you.