Troubleshooting: Inquiry Stock Movement report error-Unknown Sql Exception (Number=207, Message=Invalid column name ‘TypeofStockIn’

From AutoCount Resource Center

Question: When I inquiry stock movement report, system prompted an error “Unknown Sql Exception (Number=207, Message=Invalid column name TypeofStockIn .” Why?

Version: 1.8 / 1.9 / 2.0

Possible Reason:

The database has detected POS is installed, but the POS table is not updated.


Install POS Backend and plugin app from Plug-In Manager.

After installed and re-login AutoCount, you should be able to inquiry the stock movement report.

Note: Please seek assistance from your software dealer if the problem persists after performing the suggested steps.

By: Jodie 230719, Lay Swan 230821, P230823

Go to menu

AutoCount Accounting 2.0 & 2.1

AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS

AutoCount On The Go
AutoCount Accounting Plug-In Documentations