Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / GP 2018 Not able to fi...
Finance | Project Operations, Human Resources, ...
Suggested answer

GP 2018 Not able to find CheckBooks CRUD operation API's from GP service

(0) ShareShare
ReportReport
Posted on by Pravat Sabat 5

I have got into a situation where all the installations for GP 2018 is finished and up and running. Thank you to the forum which helped me in reaching to this point. Now as I started doing implementation for my project and added service reference to "ServerName:48620/.../GPService". I found difficult in mapping the tables with the service function calls. example: I am not able to get the Checkbook operations like GetCheckbook, UpdateCheckbook.

Any help would be much appreciated to get this to a closure.

Additionally, If there is any way I can get the table mappings with the Rest API's service Classes/Functions also will be helpful.

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: GP 2018 Not able to find CheckBooks CRUD operation API's from GP service

    If Web Services doesn't have any options for Checkbooks, there isn't any setting or configuration, by default, that adds more functionality, it pretty much is what it is and has been that way since we changed Web Services back in GP 10.0 and that was just to move it from IIS to WCF.

    Usually, if Web Services and/or Integration Manager doesn't have the functionality being looked for, such as Checkbooks, the default is eConnect as that does have, in most cases, the procedures to do what you're looking to do, and if it doesn't, a PRE or POST procedure can possibly be modified to do what you need it to do. You can call the eConnect API directly.

    Another option may be Visual Studio Tools, using .NET languages to build an integration add-in for Dynamics GP.

    Understanding you are unable to use econnect in your environment, I would leave this to the forums community to see if there is someone that has and/or knows a customer in a similar environment and what they may be using in a situation like yours, to provide more in-depth information.

    Thanks

  • Pravat Sabat Profile Picture
    Pravat Sabat 5 on at
    RE: GP 2018 Not able to find CheckBooks CRUD operation API's from GP service

    Hi Derek,

    I have verified the path as well in our server and could not able to find the XSLT files related to Checkbooks.

    Calling EConnect is not an option for us, as our application is hosted in azure and need to make an API call to connect to the Dynamic database (which is an on-premise server).  

    Is there a way we can create a new API using EConnect taCreateCheckbook procedure which will solve the problem for us. Let me know if this is feasible. If yes, let me know the procedure to do so or any GP Community thread works for me.

    Note: Checkbook is one of the entity from my list. I am looking for a solution which will work for all the entities which we are dealing with. 

    Thanks

    Pravat 

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: GP 2018 Not able to find CheckBooks CRUD operation API's from GP service

    I'm not seeing anything with checkbook in the XSLT folder (C:\Program Files\Microsoft Dynamics\GPWebServices\XSLT\, so I'm about 99% sure that means there is no functions related to checkbooks in Web Services.

    eConnect, such as the taCreateCheckbook procedure, may be another option you can look at.

    Thanks

  • Pravat Sabat Profile Picture
    Pravat Sabat 5 on at
    RE: GP 2018 Not able to find CheckBooks CRUD operation API's from GP service

    Hi Derek,

    Can I get a guidance for the problem I am facing. I really need this to a closure. Any feedback would be highly appreciated. 

    Thanks

    Pravat

  • Pravat Sabat Profile Picture
    Pravat Sabat 5 on at
    RE: GP 2018 Not able to find CheckBooks CRUD operation API's from GP service

    Hi Derek,

    All the GP service configuration is proper as per the link provided and i am able to access all service links as well.

    I am able to consume the service and able to do operations (GetAll/Create/Update) which are listed under the GPService( After creating a DynamicsGPClient object). For testing, I have created multiple Vendor using CreateVendor function call and that was successful as well. Verified the data in the database as well.

    The problem what i am facing is related to few entities which are not getting listed in the service. Example : Checkbook related functions are one of them. I am expecting when I create an object of DynamicsGPClient, I should be able to access/call services like GetCheckbook/CreateCheckbook etc. which I am not able to see from the listed operations.

    pastedimage1607014851467v1.png

    Are there any configuration needed, to enable these functions from GP application. 

    Let me know if this will help you in answering my Question.

    Thank you

  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: GP 2018 Not able to find CheckBooks CRUD operation API's from GP service

    So, you're using Web Services to integrate checkbook operations like GetChedkbook and UpdateCheckbook.

    The first thing that I'd recommend is to verify the following:

    support.microsoft.com/.../how-to-verify-if-microsoft-dynamics-gp-web-services-is-functioning-cor

    Then, if Web Services is installed and working correctly, when you attempt to run the integration and have issues with it, we would want to look at the Web Services Exceptions Console, along with the Event Viewer logs on that server, for related information we'd use to troubleshoot the issues being seen.

    Thanks

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

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans