#CFG7DNCM9 #C298P0BCK #C29HQS63G Has anyone successfully used Celigo to create Item Fulfillments from Sales orders that contain duplicate lines. (the same item is used on multiple line items of the sales order). It is very complicated as the entire order is not always fulfilled at the same time. So the Line ID of the IF changes. For example if you first fulfill LInes 1, 2, 3 of the sales order I belive that is lines 1, 2, 3 of the Item Fulfillment when posting. But then when you go back to fulfill Lines 4, 5, 6 of the sales order later, that is lines 1, 2, 3 of the next item fulfillment. So the line ID's change depending on what is already fulfilled on the order. And you can't use the itemkey because it gives you an error of "multiple items with the Key xxx are found". Has anyone run into this before?

ideally you export out the sales order line id and then re import them back into the item fulfillment

orderline

field as the key

@battk is correct. Here is an example of the mappings. "Items: Line ID" is mapped to the sales order line id

you want to use orderline, not line

I see what you are saying @nsAI on the complexities with existing line ID fields. I've found that when using kit items or when you cancel SO lines, the Line ID on the fulfillment doesn't match. What I do that works for me is to create a very simple workflow (triggered on order create/update) that populates a custom field "3PL Line Id" for example with the value from the Sales Order Line Id, the value is inherited as it is into the Item Fulfillment, so you are sure that the Line Id on the SO is always the same as the Line Id on the IF.

Sure you can use orderline as well. You won't see it in the drop down menu, but you can manually enter in like this

item[*].orderline

Thanks everyone...so @battk and @Tyler Lamparter are you saying I need to add a lookup step in the fulfillment flow that looks up the order line of the sale order, then use that in the next step that posts the Item Fulfillment? If so, I don't think the order line of the sales order translates to the line of the item fulfillment. Isn't the IF line in 3's? So Line 1, 2, 3 of the SO is line 0, 3, 6 of the IF?

you dont need to do a lookup, mark the etail order line id as a "key field to find existing lines" refer to @Tyler Lamparter screenshots. and it should work.

@Greg Lopez is correct. Just change my mapping from orderline to etail order line id and set as key

So in the netsuite side of the mapping just manually type in item[*].orderline?

That's what I said here https://netsuiteprofessionals.slack.com/archives/CFG7DNCM9/p1717863135712109?thread_ts=1717775755.981749&cid=CFG7DNCM9

like this?

yeah

(FYI custom_field3 is holding the etail order id from the saels order

and make sure you set as key under the settings for that field

yes like this?

yes

ok thank you