NetSuite Item Fulfillment is not getting created

Sanju S

• June 05, 2024 18:25

When I try to create an Item fulfillment in NetSuite it's showing error as 
"Failed to create, update/transform record because You must have at least one valid line item for this transaction."

Here is the mapping

Input data sample

0

• 

  Yonton Mehler Integration Engineer NetSuite Integration Whiz Salesforce Integration Whiz

  • June 05, 2024 20:09

  

  Hi Sanju,

  It looks like your import step is built in a way that should work

  Seeing this error with this setup make me wonder about the following:

  1. Is the order Pending Fulfillment?
  2. Are the specific items in your test data needing to be fulfilled?
  3. Are the "item_name" values in your test data an exact match to the item names on the sales order?
  4. Are you able to create the Item Fulfillment for this order in the NS UI?

  If the answer to all of the above questions is yes, let me know and we can think of other things to consider. But hopefully one of those 4 questions will lead you to a simple solution.

  Yonton.

  0
• 

  Rick Eltzroth

  • June 06, 2024 19:54

  

  

  I was able to get item fulfillment to create from sales orders at one point. its been a minute.

  I used the internal ID of the NetSuite Item and mapped it to the Field ID: itemkey

  You also may need to 'use dynamic mode' and hardcode 'fulfill' to true

  0

Please sign in to leave a comment.