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 version 2.1.0.1.
Solution:
Update to version 2.1.0.1 or later, and you should be able to set the Global Price Change for Location Price.
--Source from AutoCount Wiki --
Related Articles
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. ...
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.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.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 ...
A1.99 : Prompted Message: Unable to create new account book, error message-Unknown SQL Exception.Invalid object name Setting
Question: When I try to create new account book, error message prompted: "Unknown Sql Exception (Number =208, Message=Invalid object name ‘Setting’.)”. Why? Possible Reason : This is a known bug in version 2.0.17.154 and is fixed in version ...