Troubleshooting: Delete user - error message prompted

From AutoCount Resource Center

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.


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

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations