Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Sales Order Integratio...
Microsoft Dynamics GP (Archived)

Sales Order Integration and Next Sales Order Number

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,730

We just had situation with a sales order integration.  There were 5 sales orders to integrate. Prior to the start of the integration the next sales order number was 075050. The integration started and errored on the 4th sales order. The error was caused by an invalid address ID. However, other users were still entering sales orders.Sales orders 075050,075051,075052 are now in the system from the integration. A user goes to enter a new order and gets sales order number 075050, not 075053. If you look at sales order document setup, the next sales order number is 075053. I tested this with several users and the result was the same. I then had everyone exit GP, restarted the SQL service and users then went back to generate new sales orders and now they all started getting the correct sales order numbers.Has anyone else ever experiened this and, if so, how did correct the situation?

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Sales Order Integration and Next Sales Order Number

    Richard,

    That's odd, you'd think the macro would act just like a user. Another mystery. Like you, if it's quick to fix and doesn't happen very often, I just fix it and move on :)

    Kind regards,

    Leslie

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Sales Order Integration and Next Sales Order Number

    Leslie, I am using the standard adapter. When this happens it just locks up the order process and the client simply wants to get back to work. There is no time to track it down. It must be some table or record lock issue as simply restarting SQL fixes it every time.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Sales Order Integration and Next Sales Order Number

    Richard,

    I too have seen this happen. It happens so rarely that I've never tried tracking it down. Are you using the standard adapter or the eConnect adapter?

    Kind regards,

    Leslie

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Sales Order Integration and Next Sales Order Number

    Integration Manager. We see this occur 2-3 per year. We integrate 3-4 times per day. It just happened that yesterday there was this issue with an address code.

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    Re: Sales Order Integration and Next Sales Order Number

    How were you integrating?  Integration Manager, eConnect, Macro or direct SQL?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans