web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager fo...
Microsoft Dynamics GP (Archived)

Integration Manager for SOP

(0) ShareShare
ReportReport
Posted on by Katie Pieczynski 3,225

Does anyone have an example of how they have set up their sources to import SOP Quotes/Orders?

For some reason mine has gotten deleted and I am trying to recreate it but it is only bringing in the header and not the item numbers.

I have a text file with Customer number, Item number, and Qty

My source is Quote Header and Quote Detail with the relationship set with Customer number. 

My mapping is set to have Type as Quote Batch as a constant and Customer ID set for Source.

Any help would be great.

Thank you,

Katie

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    If you look in your Integration Manager\Samples folder you will find a sample SOP integration. You will also see a sample SOP integration in IM. You will need to select only the header fields for the header and sort on those fields, then in the detail you will select everything and then in your query relationships link the header sopnumbe to the detail sopnumbe. Make sure you set the source to record source for the detail.

  • Katie Pieczynski Profile Picture
    Katie Pieczynski 3,225 on at

    Thank you!  Now I have another question.  I want my integration to bring in the line items as they appear on the txt file.  Right now it is putting them in numerical order.  I have tried changing the UseOptimizedFiltering= to False but the did not work.  Do I need to sort or group on anything in the item source?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans