Skip to main content

Notifications

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

Recreate stored proc for APR_PTO45100

(0) ShareShare
ReportReport
Posted on by 1,049

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,049 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,054 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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans