web
You’re offline. This is a read only version of the page.
close
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) / Integration Manager an...
Microsoft Dynamics GP (Archived)

Integration Manager and Inventory Adjustments

(0) ShareShare
ReportReport
Posted on by Jeff Boughton
Hi all, I am trying to make an Integration Manager using the Inventory adapter. I am performing adjustments into a batch. Essentially I am trying to take a CSV file full of inventory and create a big adjustment to move it all into a site. The problem I am having creating this Inventory adjustment is that each item adjustment is creating a document number within the batch. I just want it all on one document number as my first round will be over 28,000 items to be added -- I don't want 28,000 document numbers with just one item adjustment on it. Please help! I am using Dynamics GP 9.0 SP4 (Still). Jeff

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Tim W Profile Picture
    Tim W 2,925 on at

    You need to set your integration (assuming single file) with header and line and group by something you have in the file at the header level (such as batch number) that is the same on all lines.

    The sample Inventory Transaction integration in IM has header / line/ serial objects but is a good example on how to setup a group by as that groups by Document Number.  I'd almost recommend splitting it up a bit though as that is quite alot of lines on a single transaction but I would assume it will work.  I've certainly done north of 5000 lines on a cutover in a single IM transaction.

  • Jeff Boughton Profile Picture
    Jeff Boughton on at

    Thanks Tim - I appreciate your response. You helped me find the direction I needed. I took a deeper look at the IM example for Inventory and as you mentioned, I played with the header/detail files and got it working.

  • B-e-a Profile Picture
    B-e-a 5 on at

    Hi Jeff.

    How did you make it work? I'm also having the same problem.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans