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

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