How to prevent resetting Netsuite line item fields when updating opportunity

Nuri Ensing NetSuite Integration Whiz

• October 20, 2021 14:43

I have a flow in which I update for example the delivery date of a line item in Netsuite. The flow is an import with an operation Update. However it will also reset all other fields of the lineitem which I am updating like the price. Is there a way to prevent this and thus only update the targeted field i.e the delivery date?

0

• 

  Uma Lakshmi Kanth Garimella Lead Engineer

  • October 21, 2021 05:43

  

  Hey Nuri,

  Generally, setting the "Items : Item" field resets the line in NetSuite. I would suggest you use a different identifying field like "Items : Line ID" to identify a line uniquely. This would not set the "item" field again hence would not reset the line.

  Please feel free to create a support ticket if you're still stuck, we'll take it up from there.

  0
• 

  Nuri Ensing NetSuite Integration Whiz

  • October 21, 2021 07:14
  • Edited

  

  

  

  Uma Lakshmi Kanth Garimella, thanks for your reply.
  I already have another field set up as a key. However If I do not set Item : Item (InternalId) then I will get an error Please add item. And when I am setting Item its resetting the line values.


  0
• 

  Uma Lakshmi Kanth Garimella Lead Engineer

  • October 21, 2021 09:22

  

  Hey, Nuri Ensing As your operation is "Update" you don't need to set the "Item: item" again for line-level field updates. You just need to tell us the "Line ID" so that we can update that line.

  Can you try and check if you can get the "Line ID" field across and use that?

  You probably might be getting "Please enter a value for Item" as it might be creating a new line instead of updating an existing line. If we have the correct "Line ID" mapping, it should update that line and you will not see this error.

  Feel free to contact Celigo support if you're still stuck on this.

  0

Please sign in to leave a comment.