Hello, I’m trying to create an Item Fulfillment from a Sales Order via Integration. However, I am getting this error: “Failed to create, update/transform record because You must have at least one valid line item for this transaction.” When I fulfill the Sales Order manually through NS, I don’t run into any errors. Any thoughts/suggestions on what I should be looking out for?

@Sam is the inventory available in that location?

I ran into this while working on an integration project last week. It can be very frustrating, but here are a few things to look for: Make sure the location you're creating the fulfillment for actually has inventory for at least one of the items that you're trying to fulfill. If you're using subsidiaries, be careful of those, too.

@AK47 @tdietrich Confirmed that the inventory is available (qty available) at the location. And confirmed that the item’s subsidiary matches that of the Sales Order. Will look into the bins. Thanks both and please feel free to add any additional checks I should be making!

Take a look at the parameters in the url that netsuite defaults in when you create the fulfillment in the ui

Hi @battk, are you talking about these parameters? id=874788&e=T&transform=salesord&memdoc=0&whence=&inventorylocation=305

Specifically inventorylocation

Hmm still getting the same error

are you using suitescript?

Celigo

that actually can be suitescript or suitetalk

Celigo uses suitescript too and has options to perform additional transformations + defaults. I'd suggest checking your payload to NetSuite to see if you have any line items within it. If you do, you'd have to provide the accurate mapping instructions into the Celigo interface.