Troubleshooting: Delete user - error message prompted

Question: Error message: "The value of column UserId in table EventLog does not exist in its master file" prompted when deleting a user?

Version: 1.8 / 1.9 / 2.0

Deleter user.png


Possible Reason:

This message indicates there are event log for this user that is locked in event log table, and the system could not allow deletion of such user. Besides, if there is any transaction exists in other tables such as Item, Invoice or Purchase, the related user is not allowed to be deleted too.


Solution:

Set the status of such user to "non-active". Go to General Maintenance > User Maintenance > select the User ID, click on Edit User, uncheck the checkbox of "Active".


Deleter user1.png


By: CK 170721; KM 170726; P170801

Go to menu

  AutoCount Accounting 2.0


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations