web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Is there a stored proc...
Microsoft Dynamics GP (Archived)

Is there a stored procedures reference document out there for GP?

(0) ShareShare
ReportReport
Posted on by Dylan West 155

I'm a developer and I'm making a web application that needs to insert data into the Applicant and Employee database tables in GP. I'd like to use the stored procedures that come with GP to do this. I'm finding that running SQL Profiler to find out what stored procedures are called for each part of the application process and new hire process is quite time consuming and tedious. Is there a reference document out there that lists out which stored procedures are called for which actions in GP and what their expected input parameters are? Thanks.

*This post is locked for comments

I have the same question (0)
  • Christopher Groh Profile Picture
    Christopher Groh 195 on at

    You probably don't want to call stored procedures directly. Look into eConnect and GP Web Services.

  • Dylan West Profile Picture
    Dylan West 155 on at

    Is there a particular feature of eConnect and GP Web Services that would help me insert records into GP? If so, what is the name of it so I know how to research it further. Thanks!

  • Verified answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Dylan,

    Here is link for Dynamics GP WebServices :msdn.microsoft.com/.../cc508424.aspx

    WebMethod to create applicant : msdn.microsoft.com/.../ff622616.aspx

    Web Method to create employee : msdn.microsoft.com/.../cc713398.aspx

    As you are going to develop website I will prefer to use WebServices. Sometime it happen in Dynamics GP WebService we don't find webmethod but eConnect has schema in that case I created Custom Webservices using eConnect.

    eConnect : msdn.microsoft.com/.../ff623651.aspx

    Thanks

    Sandip Jadhav

  • Dylan West Profile Picture
    Dylan West 155 on at

    Thanks a lot Sandip! I'll have to look into these tools and learn how to use them. (After my company buys them - if they buy them)

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Dylan,

    It seems to be it's free; don't know need to ask Microsoft.

    Thanks

    Sandip

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans