JSON > NetSuite Extra row on Item Fulfillment Packages Subtab
Hey Everyone,
I have a couple flows that map data to the NetSuite's Item Fulfillment record Packages list. This list always has one row in it by default and I can't seem to make it go away. If I map an array in JSON with 2 objects in it I'll wind up with 3 rows on packages. I've used the Line Id to try to overwrite the row and tried the Packages : Replace All Lines = true mapping.
Ideas??
Thanks!!
1
Comments
Hi David,
Unfortunately, this is a weird NetSuite behaviour only applicable for Item Fulfilment (best guess is because NS support different package sublist depending upon Shipping method). To solve this problem, Item Fulfilment needs to be created in Dynamic Mode (I would suggest to read NetSuite Help about this). This is a NS feature that stimulate creation of a record via API when its done via UI and adds fields one by one just like user is doing it. So, its important to have the right ordering of the field mapping for the records to be created.
To enable dynamic mode for IO NS Imports, add a new mapping on Import side , "Use Dynamic Mode", and hardcode this to "true". This should remove the extra packing line showing up.
Hi Mujtaba,
Thanks for the advice. I'm familiar with dynamic mode. I'll give that a try!
But we have provided dynamic mode as true in the import mapping to solve the issue of the Extra row on Item Fulfillment Packages Subtab. We are getting an 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.
How we can solve this?
Hi Rosemol Joe
looks like the issue is coming from the line item sublist, not from the package sublist. I think you were trying to add a new line item in the item fulfillment record which is not present in the sales order record, can you confirm the items you were trying to fulfill are present in the sales order record?
can you check mappings for the item sublist, one of these fields is added or not (item or itemkey or itemname) which is important for finding the existing line.
Thanks,
Please sign in to leave a comment.