tracking code
LBMC Technology Solutions
  • Home
  • Solutions
    • Dynamics 365
    • Dynamics NAV
    • Dynamics GP
    • Dynamics CRM
    • Sage Intacct
    • Document Management (ECM)
    • Network Engineering and IT Solutions >
      • IT Security
      • Managed IT
      • Business Phone Systems
  • Events
    • All Upcoming Events
    • Training / CPE
    • Webinars and Workshops
  • Resources
    • Blog
    • Forum
    • On-Demand Webinars
    • Referral Program
    • Services We Offer
    • Support
  • About Us
    • Careers
    • Partner with Us
    • Community
    • Contact Us

Payroll table failing to upgrade for GP 2015 year-end?

12/21/2015

 
Posted by Tyler Boswell
​

With the Year-End updates for Microsoft Dynamics GP 2013 and 2015 going live in late November, a lot of you have probably either started planning, or actually performing your year-end updates.
​
For those of you that are already on GP 2015 RTM or R2, this won't be an issue, but for those of you that are on version 12.01801 or earlier, you may be having problems updating your ‘Payroll Master Employee ACA’ table (UPR00905).
Payroll troubleshooting for GP
The issue, in short, is that the temporary table is not being removed as it should be. Luckily, this can be quickly resolved with a couple of simple scripts that you will run against your ‘DYNAMICS’ database.

I’m going to stop and add a quick disclaimer before going any farther. You should ALWAYS run a backup before running any scripts. If you are not comfortable performing a backup or running SQL scripts, it is best to contact your partner or Microsoft directly. Every environment is different so these scripts are provided as is, without warranty.

Once you have made your backup, run the following scripts:

Delete DU000010 where PRODID = 0 and fileOSName = 'UPR00905' and conversionScript = 'convertUPR00905forGP14TX2'
-and-
Delete DU000030 WHERE (Status <> 0 or errornum <> 0) and Status <>15

After running these scripts you can re-launch Microsoft Dynamics GP Utilities and continue the upgrade.

If you have yet to begin running Utilities, you can proactively avoid the error by running the first script against the ‘DYNAMICS’ database and you will be able to execute the upgrade without any UPR00905 errors.
​
 If you have any additional questions, contact InterDyn Artis.
​
Dynamics GP training

Comments are closed.


    Blog

    ​Your one stop shop for technology.

    Categories

    All
    Business Central
    Dynamics 365
    Dynamics CRM
    Dynamics GP
    Dynamics NAV
    Events
    Microsoft Dynamics Add-ons
    Software Decisions
    Tutorial

Solutions
Microsoft Dynamics 365
    Business Central
    Customer Engagement
Microsoft Dynamics NAV
Microsoft Dynamics GP
​Microsoft Dynamics CRM
​Sage Intacct
​
Network Engineering

​ERP Comparison Guide
Learning Opportunities
All Upcoming Events
User Conferences
Training / CPE
Vision
Webinars & Workshops
​

Resources
Blog
Forum
Referral Program
​​YouTube Channel

Company
About Us
Careers
Contact Us
​
Locations
Charlotte
Knoxville
Nashville
Picture
Picture
Proudly powered by Weebly

Sitemap | Home | Careers | Contact Us

share

Copyright © 2019

LBMC Technology Solutions