Accounting 2.0 - Prompted Message: Change Item Code error – Invalid column name ‘Key1’

Question: When I try to change item code, error prompted: Invalid column name ‘Key1’. Why?

Version: 2.0



Possible Reason :

The database detected POS 3 is installed, the database is upgraded from version 1.9 to 2.0, but the POS table is not updated.


Solution :

Install POS 5 Backend and plugin app from Plug-In Manager.


After installed and re-login using POS 5.0 Backend, the POS table is updated, and you should be able to change item code successfully. If this account book no longer using POS module, you may uninstall the POS plug in from Plug-In Manager.


By: Zhi Xuan 210406, Lay Swan 210422, P210426



Go to menu

  AutoCount Accounting 2.0 & 2.1


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations