Skip to main content
Microsoft Dynamics GP forum
Suggested answer

Recreate stored proc for APR_PTO45100

editSubscribe (0) ShareShare
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?

  • 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,002 Super User 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?


Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…


Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,045 Super User

Martin Dráb Profile Picture

Martin Dráb 222,570 Super User

nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans