Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

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

Integration Manager: Can you change the DOC number without changing the Document Number?

(0) ShareShare
ReportReport
Posted on by FzZzT 135

Hello,

We integrate orders from a system that has its own IDs. We put this ID into a user-defined field, but when integrating, all we are able to see is the sequential DOC number, which makes it almost impossible to determine which order is failing to integrate... Is there a way to change something so that we can replace this DOC number with the other system's order ID?

I think I did this by changing Document Number once, but we need GP's document numbers to stay intact...changing that would be problematic. Right now we do a preview to "track" the order as a workaround, but that's also problematic...

Thanks,
Josh

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Integration Manager: Can you change the DOC number without changing the Document Number?

    I am not sure why my previous note came blank so let's try again.

    You need to map the Document Number and Doc Type if you have then in your external database to be imported. Otherwise, GP will use the next sales order number which is in sales processing order setup.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Integration Manager: Can you change the DOC number without changing the Document Number?

     

  • FzZzT Profile Picture
    FzZzT 135 on at
    RE: Integration Manager: Can you change the DOC number without changing the Document Number?

    Thanks for the response, sorry it took so long to respond.

    The orders come from a web site and are being imported via ODBC in Integration Manager. The integration splits the query into a list and details. I don't see an order ID field in the Sales Transaction mapping, so I think what you mean is change the DOC number to be the order ID (which the web site creates), or set Document Number field in the IM mapping to be the order ID. I want to do the former but not the latter. I might be using the wrong terminology (it's based on the GUI) so I'll explain my view:

    The DOC number (in IM) and the Document Number (in GP) are two different things that sometimes match up... The DOC number, AFAICT, is just a serial integer that IM displays during the integration. It seems to disappear after that. This is currently set to "Use Default" in IM. This is the number I want to change, because if an order doesn't integrate, there is no way to figure out which order. The Document Number maps into GP (currently something like W000132456). Currently, when set to Use Default in IM, I think this just uses some built-in default. I tried setting this once, and it worked, the DOC displayed in IM matched the order ID from the site, but it also changed GP's Document Number to be the order ID, not the W... format. This broke other pieces that apparently depend on the W... format.

    I hope that helps... Maybe it isn't possible. My last resort would be to run a query via script after each document and insert the DOC number to map to an order ID...but that would be terrible for performance and workflow.

    Thanks again.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: Integration Manager: Can you change the DOC number without changing the Document Number?

    Are we talking about sales orders through sales order processing and getting imported using Integration Manager? If so, when you map your fields just map the order ID to be your DOC number? As long as it is unique and can be found in your order header and detail lines you will be fine. If you are trying to use both GP SOPNUMBE and your DOC number I do not see how that work unless you concatenate them.

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

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans