Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by Pravat Sabat

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

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Derek Albaugh Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Pravat Sabat 5 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

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

Was this reply helpful? Yes No
Pravat Sabat 5 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Derek Albaugh Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Pravat Sabat 5 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Derek Albaugh Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No