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

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’.)”

Possible Reason:

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

Solution:

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

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

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note AutoCount Accounting 2.2 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations