Open Forum

Expand all | Collapse all

APR_BSS40700 Table?

  • 1.  APR_BSS40700 Table?

    GOLD CONTRIBUTOR
    Posted 16 days ago
    Is anyone familiar with the APR_BSS40700 table in the company database? My update keeps getting hung up on it with an error DBMS 50000, DUSQLAccountSync on that table. The weird thing is in the company I'm updating I don't see the table, but I do see a table APR_BSS40700_T. Any assistance is appreciated as always.

    ------------------------------
    Jon Godwin
    Database Administrator
    Boulder CO
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: APR_BSS40700 Table?

    TOP CONTRIBUTOR
    Posted 16 days ago
    Hi @Jon Godwin,

    I'm not overly familiar with the table, but based on the link below the table is part of the attribute setup of the HRM Solutions series product which deals in payroll.

    https://gptables.azurecurve.co.uk/products/hrm-solution-series-1911/payroll/bss-attribute-setup-apr-bss40700/

    Do you know happy to know if that product is/was used at one point?

    Thanks,

    Samantha

    ------------------------------
    Samantha Higdon ,CPA,CGMA
    Consultant
    Lagom, LLC
    Carmel IN
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: APR_BSS40700 Table?

    GOLD CONTRIBUTOR
    Posted 16 days ago
    We've never used payroll through GP. Perhaps I can uninstall that module?

    ------------------------------
    Jon Godwin
    Database Administrator
    Boulder CO
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: APR_BSS40700 Table?

    GOLD CONTRIBUTOR
    Posted 15 days ago
    Samantha is correct. The APR_BSS40700 table is the 'BSS Attribute Setup' table and a part of the 1911/HRM Solution Series module, which is one of four modules added when the Human Resources/Payroll Suite is installed for Dynamics GP.

    The other three modules are: 4522/Payroll Integration to Payable, 4933/Certification Manager and 4955/Employee Health and Wellness.

    If you uninstall the HR and Payroll Suite, it'll remove these four modules from the .set files, thus GP Utilities won't try to upgrade it, which should get you past your error message.

    Thanks

    ------------------------------
    Derek Albaugh
    Sr. Support Engineer
    Microsoft
    Moorhead MN
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: APR_BSS40700 Table?

    GOLD CONTRIBUTOR
    Posted 15 days ago
    Thanks, @Samantha Higdon & @Derek Albaugh. I appreciate the feedback. Definitely makes my life easier.​​

    ------------------------------
    Jon Godwin
    Database Administrator
    Boulder CO
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role