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 already fixed in version 2.0.29.202.
This issue happens if you did not enable Department and Project Module.
Solution:
Please upgrade to version 2.0.29.202 or later.
--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.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. ...A5.73 : Sales - Reports : Profit & Loss by Document
This function allows you to generate Profit & Loss by Document report. Profit & Loss by Document report is used to view the profit earned for each transaction. It will calculate by the differences of total selling price against total cost incurred of ...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.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: ...