web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error When Attempting ...
Microsoft Dynamics GP (Archived)

Error When Attempting to Inactivate Employee

(0) ShareShare
ReportReport
Posted on by Nancy Hogan 1,295

Customer is receiving error:  "There are unposted transaction for this employee. The employee record can not be deleted or inactivated" when trying to inactivate 2 employees.  We have so far tried all of the following:

Delete Dynamics...activity and delete dynamics..sy00800 and delete tempbd..dex_lock and delete tempdb..dex_session. 

Ran Checklinks on the Payroll check work and Payroll Transaction tables

Deleted all Payroll & DD Work tables per instructions per KB 851664.

These employees are not in a recurring or current batch or in the process of a build.

We also tried re-booting the server.

Any other suggestions?

Thanks,

Nancy

 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Nancy,

    Have you perhaps looked at the SY00801 table from the Dynamics database as well? There might be records there still that can be deleted.

    Also, a suggestion you might try is creating a DEXSQL.log file. In doing so, when the error is on the screen in Great Plains and when you review the DEXSQL.log it might be able to point you to a transaction table that is being looked at when you tried inactivating the employee.

    You can follow "KB850996 - How to create a Dexsql.log file to troubleshoot error messages in Microsoft Dynamics GP" Make sure you delete the log file prior to hitting the delete button. So that it only captures the activity on clicking the Inactive checkbox.

    I also did a quick try at this and did note that the system looked at the UPR10302 or the Payroll Transactions table. Also the same table was not visible from the KB851664 that you had already reviewed. You might want to check this as well as there is a BACHNUMB or Batch Number column that might point you to the unposted transaction.

    Hope that helps

     

     

  • Nancy Hogan Profile Picture
    Nancy Hogan 1,295 on at

    Hi,

    I had posted this on another Forum and they suggested checking in the UPR10302 and the UPR10308 tables.  The customer found it in one of these and deleted.  Problem solved.

    Thank you very much for replying back.

    Nancy

  • Community Member Profile Picture
    Community Member on at

    Can you just delete from the UPR10308 table?  I can't delete an employee and the only thing I can find is in the UPR10308 table

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans