Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

stored procedure for project accounting?

Posted on by 250

End user wants modifications to a stored procedure which is attached to an SSRS report

Trying to find who created the original stored procedure

It's name is:  seeGPPAProjectsinProgress

How would I find what stored procedures come with GP vs developed externally?

GP2018

Categories:
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: stored procedure for project accounting?

    Hi Deanne,

    This is a default SP provided by Microsoft for the SSRS collection of reports, and obviously made for the PA module..

    I could only suggest to make a copy of that SP, assuming it can be edited (some Microsoft SP's are encrypted, not edit possible) in order to make the customization you want to this SP.. It's not a good idea to alter the existing one, as it might get overwritten during the next service pack or update in GP.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: stored procedure for project accounting?

    The Software Development Kit has them.  Microsoft hasn't updated it in a while, but you can see the nomenclature they use and see isn't used. It's under Parameters for Project accounting.  docs.microsoft.com/.../mdgp2016_softwaredevelopmentkits_372

    It looks like they may have taken an existing one and modified it.

    Pam

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans