Skip to main content

Notifications

Announcements

No record found.

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

Recreate stored proc for APR_PTO45100

Posted on by 1,045

When testing closing payroll in one of our companies, we receive this message: get/change first operation on APR_PTO_Code_SETP cannot find table.  The More Info button shows:  could not find stored procedure zDP_APR_PTO45100OF1.  I could not find this table in the table resources under HRMSS\Payroo.  How can I get it recreated?

Categories:
  • Suggested answer
    RE: Recreate stored proc for APR_PTO45100

    I believe the HR/Payroll Suite, which is made up of 4 features, was acquired from Integrity, back in GP 10.0 or so, if I remember:

    --1911  / HRM Solution Series

    --4522 / Payroll Integration To Payable

    --4933 / Certification Manager

    --4955 / Employee Health and Wellness

  • WindyCityGP Profile Picture
    WindyCityGP 1,045 on at
    RE: Recreate stored proc for APR_PTO45100

    Thank you Derek and Beat for your responses.  I will reach out to Integrity-Data since we do use that.

    Does Microsoft own Integrity-Data's HRMSS product?

  • 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: Recreate stored proc for APR_PTO45100

    HI Windy,

    everything starting with zDP_ usually indicates a Stored Procedure, not a table. However, the subsequent characters can provide some hint of the table that is concerned by the SP, in this case APR_PTO45100. That doesn't sound to be standard table of GP to me, which means it might be part of an ISV product.

  • Suggested answer
    RE: Recreate stored proc for APR_PTO45100

    I believe this may be part of an Integrity Data add-in, as I don't have any APR_PTO45100 table in my GP 18.3.1173 system and we didn't add anything new to 18.3.1200, nor can I find any mention of this table.

    Do you have Integrity or any other third-party products installed for Dynamics GP related to payroll?

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

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans