web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Integration Manager- M...

Microsoft Dynamics GP (Archived)

Integration Manager- Multiple Lines

(0) Share

Report

Report

Posted on by Community Member

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 have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Richard Whaley 25,195 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

I've got it, during the mapping, I went to Items>>Options , change the Record Source to my line-item file.

Thanks

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

HP-11021721-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans