Accounting 2.0 - Prompted Message: Unable to save new transaction-Invalid column name ‘ToDocType’. Invalid column name ‘TransferedQty’

From AutoCount Resource Center

Question: Error during save new transactions. After upgraded AutoCount 1.9 to version 2.0 showing error: Invalid column name ‘ToDocType’. Invalid column name ‘TransferedQty’.

Version: 2.0 / 2.1

Possible Reason:

Some columns are missing during upgrade.


1) Backup the account book.

2) Search and open SQL Management Studio from window search.

3) Click on the database name and execute the following query:

UPDATE Registry SET RegValue = '2.2.43' WHERE RegID = 2

4) Now, user may login to AutoCount to upgrade database again.
Now you should be able to save new transactions.

By: Cit Ta 231024, Lay Swan 231109, P231121

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