Open main menu

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

Revision as of 01:42, 23 March 2018 by Keatmeng (talk | contribs) (Created page with "'''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 ‘Dept...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.


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


Drill down error2.png


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



Go to menu