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

Revision as of 07:10, 26 April 2021 by LaySwan (talk | contribs) (Created page with "'''Question:''' When I try to change item code, error prompted: Invalid column name ‘Key1’. Why? '''Version:''' 2.0 File:Invalid Key1 a.png <u><b>Possible Reason...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

Version: 2.0


Invalid Key1 a.png


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.

Invalid Key1 b.png


After installed and re-login AutoCount, 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


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations