JSON > NetSuite Extra row on Item Fulfillment Packages Subtab
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.
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.
Thanks for the advice. I'm familiar with dynamic mode. I'll give that a try!0
Please sign in to leave a comment.