cn Integration Manager $IM 9$, is there a way to insert have multiple line-items on one sales order?
*This post is locked for comments
I've got it, during the mapping, I went to Items>>Options , change the Record Source to my line-item file.
Thanks
I've tried that but the results I get is either a bunch of orders with one line item or just one order with one item, then the integration fails due to "Doc no already exist". Here's what I have on my two file: Header- Type,Cust_id,Type_id,Doc no
Lineitem- Item no, QTY, Doc no
Linked by Doc no
Is there any other setting I need?
thanks
All the time. You need two import files, one for the sales order header and a separate one for the line items. The first file contains ONLY one record for each sales order. The second contains the data for the line items.
We do it all the time. This is why the model IM has multiple files.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156