Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Automate Sales Document Commitments

(0) ShareShare
ReportReport
Posted on by 45
Hi, does anyone know if there is a way to automate the “Sales Document Commitments” in Purchase Order Processing?  I am creating a PO document using GP 10.0 SP4/Web Services and setting the DoesAllowSalesOrderCommitments to true.  How do you automate the association between the “Purchase Order” and the “Sales Order”?  The manual process is to open the “Sales Commitments for Purchase Orders” window and pick the Sales Order Document.  I have not had any luck finding a method in eConnect, Web Services or a SQL stored procedure to make this association.

*This post is locked for comments

  • Terry Crane Profile Picture
    Terry Crane 45 on at
    Re: Re: Automate Sales Document Commitments

    Hi, looks like that might just do the trick. Thank you for the quick response.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Automate Sales Document Commitments

    You will need to create a Web Service extension to the CreatePurchaseOrder web method. You will have to define your own stored procedure that inserts the SOP commitment record in the dbo.SOP60100 table then wrap that stored procedure in a web method. Your web method can be independent from the GP web services or created as an extension to the existing CreatePurchaseOrder method.

    Take a look at the Extending The Web Service chapter at http://msdn.microsoft.com/en-us/library/cc508802.aspx

  • Terry Crane Profile Picture
    Terry Crane 45 on at
    Re: Re: Automate Sales Document Commitments
    Hi, I am trying to accomplish this functionality without the end user.  When I create a Sales Order using the web service CreateSalesOrder,  I need to generate a corresponding PO and have the documents linked together.  Similar to the process that takes place when you create a PO from the “Sales Transaction” menu ... Actions > > Purchase.  I can also create a Purchase Order using the web service method CreatePurchaseOrder however; I cannot find an automated way to make the PO commitment association to the Sales document.  Thx, Terry
  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Automate Sales Document Commitments

    Automatic committment works from the Sales Order side in GP.  Users entering a sales transaction can automatically generate POs to purchase the items for delivery to the firm or to the customer with the costs of the purchase being posted directly to the COGS as the sales transaction is posted.

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

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans