Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP Webservices and Add...
Microsoft Dynamics GP (Archived)

GP Webservices and Adding Notes to Invoice

(0) ShareShare
ReportReport
Posted on by Mohammed Noureldine

We use webservices to integrate our Dynamics CRM 4.0 with GP 10.0. We do alot of integration using GP webservices like creating invoices, customers and vendors.

However, we just faced a problem. We need to use the web services to add some notes to the invoice. I have searched a lot but couldn't find a way to do so. Can anybody guide me to a way to do so?

Do I need to set a certain property in PayablesInvoice instance before sending it to the CreatePayablesInvoice webservice method? or there is another method to add a note to any GP entry? Please advice.

Thanks!

*This post is locked for comments

  • Mohammed Noureldine Profile Picture
    Mohammed Noureldine on at
    Re: Re: GP Webservices and Adding Notes to Invoice

    Many thanks for the help. I believe the solution is more complex than I expect. I think I will go for the web extension path if we have the time to apply the solution.

    I hope this would be supported in the GP web-services future releases.

  • Verified answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: GP Webservices and Adding Notes to Invoice

    From Chris Roehrick on the Partner Online Technical Forum (I assume you posted the same question there)

    There is no Note property on the PayableInvoice object in GP Web Services.    There is no Note element in the taPMTransactionInsert node of eConnect so my guess is that is why it is not modeled in the GP Web Services.

    One idea that I am thinking is that you could still use the taPMTransactionInsertPost procedure to go get the NOTEINDX value of the newly created transaction in the PM10000 table.  Then manually update the SY03900 table with the desired note text for the NOTEINDX value.  The problem is how to pass the notetext anywhere in GP Web Services?   You could potentially write the note text to a custom table using the Extensions model of GP Web Services.  Then in the taPMTransactionInsertPost  procedure you would have to pull the note text from the custom table.   Another option is to not use GP Web Services and use eConnect.   You could pass the note text to the USRDEFND4 element of the taPMTransactionInsert node.   Then in the taPMTransactionInsertPost procedure you will have custom code to update the SY03900 table (Notes) with the value from USRDEFND4.  Hope that helps in thinking how to integrate notes for payables invoices.

    I had also responded the following, which is pretty much what Chris is saying above:

    Interestingly enough, the taPMTransactionInsert node available in eConnect does not allow you to pass a note to a payable transaction -- the GP Web Services are wrapped around eConnect. It sounds like you will have to create a stored procedure on SQL Server to add the note to the transaction then create a custom web method (either independent or as an extension to the CreatePayablesInvoice method) to pass the note over to GP.

  • GPDev Profile Picture
    GPDev 1,755 on at
    Re: GP Webservices and Adding Notes to Invoice

    Hi Mohammed,

    I don't think you can integrate data into the OLE Notes field in GP with web services, at least not without a lot of customization. The content of GP notes are stored in the file system and not in a SQL Server table. 

    Check out this article for more information on OLE Notes in GP: http://dynamicsgpblogster.blogspot.com/2008/11/all-about-dexterity-ole-container.html

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans