Pos: Unable to dril down source document – Invalid Column Name

From AutoCount Resource Center

Question: when I want to drill down to source document in POS transaction viewer, error message “Unknown Sql Exception (Number=207, Message=Invalid column name ‘DeptNo’. Invalid column name ‘ProjNo’.)”

Drill down error1.png

Possible Reason:

During upgrade of the system, there are some files not being updated.


Go to Microsoft SQL Management Studio or AutoCount Accounting Management Studio and run the query as shown below: -

UPDATE Registry SET RegValue='3.32' WHERE RegID=900001

Drill down error2.png

Then, re-login the system and try to drill down to source document again.

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations