Pos: Login Error - Unknown SQL Exception (Number = 207, Message=Invalid column name ‘ReturnQty’. Invalid column name ‘ReturnQty’.)

From AutoCount Resource Center
Jump to navigation Jump to search

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?


Pos return qty1.png


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