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

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