Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to receive items o...
Microsoft Dynamics GP (Archived)

How to receive items on multiple receipts with Integration Manager?

(0) ShareShare
ReportReport
Posted on by Tom W. Ross 855

I have a data file with all the required information for entering Receivings Transactions via Integration Manager. I am using a source field for the Receipt Number. I am testing with eight receipts, and each receipt should have five items. When I run the integration, all 40 items are received on all eight receipts. I realize this is because the integration is intended to create a single receipt and then load a bunch of items onto it, not create a handful of receipts with a bunch of different items on them.

I think what I need to do is have the PO Receiving Items integration read the receipt number in the source file and only update the matching receipt number. How would I go about this?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: How to receive items on multiple receipts with Integration Manager?

    Hi Tom,

    I was just reading your post online. I was wondering how you were able to integrate transactions under the receiving entry. I have econnect setup already but I always get a TA error message. Can you please share your file with me that you are using so I can follow the same structure to integrate my entries.

    Thanks,

    Mo

  • Tom W. Ross Profile Picture
    Tom W. Ross 855 on at
    Re: How to receive items on multiple receipts with Integration Manager?

    Thanks again for the help, Dan. The problem was that my relationships were not set up correctly. Once I made the right query relationship, it worked perfectly. Grouping does need to be turned on on the header as you stated, though.

  • Tom W. Ross Profile Picture
    Tom W. Ross 855 on at
    Re: How to receive items on multiple receipts with Integration Manager?

    Thanks for the reply, Dan. For the header properties, I do have group by receipt number turned on. If I change the line item properties to group by the receipt number, the receipt number becomes the only source field I can map.

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: How to receive items on multiple receipts with Integration Manager?

    In the source file properties, click on the group by tab and group them by receipt number.   Based on what you stated, that should help.

    Dan Liebl | Senior Consultant | OTT,Inc | dliebl@OTT-inc.com

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans