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

From AutoCount Resource Center
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)
Jump to navigation Jump to search

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

IconAcc20.PNG AutoCount Accounting 2.0


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