Pos: Login Error - Unknown SQL Exception (Number = 207, Message=Invalid column name ‘ReturnQty’. Invalid column name ‘ReturnQty’.): Difference between revisions
Content added Content deleted
(Created page with "'''Question:''' When I try to login AutoCount POS after updated version, error message prompted “Unknown SQL Exception (Number = 207, Message=Invalid column name ‘ReturnQt...") |
(No difference)
|
Latest revision as of 02:21, 30 April 2018
Question: When I try to login AutoCount POS after updated version, error message prompted “Unknown SQL Exception (Number = 207, Message=Invalid column name ‘ReturnQty’. Invalid column name ‘ReturnQty’.)” Why?
Possible Reason:
During upgrade of the system, some table in the POS system is not being updated.
Solution:
Go to Microsoft SQL Management Studio or AutoCount Accounting Management Studio and run the query as shown below: -
ALTER TABLE [dbo].[PosDtl] ADD [ReturnQty] [dbo].[d_Qty] NULL
After running this query, login POS system as usual.
By: Michelle 180413, KM 180416, P180427