A1.102 : 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 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.
--Source from AutoCount Wiki --
Related Articles
A1.120 : Prompted Message: Global Price Change - Invalid column name ‘LastUpdate’
Question: When I set Global Price Change for Location Price and proceed to the Next, an error message prompted - Unknown Sql Exception (Number=207, Message=Invalid column name ‘LastUpdate’. Why? Possible Reason: This is a known bug and is fixed in ...A1.116 : Prompted Message: Change Item UOM rate error – Invalid object name ‘Sync’
Question: When I change item uom rate, system prompted an error: “Unknown Sql Exception (Number = 208, Message = Invalid object name ‘Sync’.). Why? Possible Reason: The registry value failed to upgrade properly when upgrading the database. Solution: ...A1.114 : Prompted Message: Profit and Loss of Document-Invalid column name ‘ProjNo’. Invalid column name ‘DeptNo’
Question: When I inquiry the Profit and Loss of Document, error prompted “Unknown Sql Exception (Number = 207, Message= Invalid column name ‘ProjNo’. Invalid column name ‘DeptNo’.) Possible Reason: This is a known bug in version 2.0.28.200 and ...A1.117 : Prompted Message: Error during upgrade to 2.0-Invalid Data Definition Language Statement, error message is Violation of PRIMARY KEY constraint … The duplicate key value is (CR Default)
Question: When upgrade database from 1.9 to 2.0, error message prompted “Invalid Data Definition Language Statement, error message is Violation of PRMIARY KEY constraint … The duplicate key value is (CR Default). Why? After clicking OK, another ...A1.96 : Prompted Message: Error upgrade to 2.0-Unknow Sql Exception… Invalid object name ‘Settings’
Question : When upgrade database from 1.9 to version 2.0, error message prompted: ‘Unkonw Sql Exception (Number=208, Message=Invalid object name ‘Setting’.) Inner Exception Message: Invalid object name ‘Settings’. Why? Possible Reason : This is a ...