Troubleshooting: Upgrade AutoCount error-Invalid DDL Statement /* Add AccountingBasis column in Tax Type table*/

Question: When I upgrade AutoCount to latest 1.9 version and login, an error prompted “Invalid DDL Statement /* Add AccountingBasis column in TaxType table*/”. What should I do?

Possible Reason:

The registry value failed to upgrade properly when upgrading database.

Solution:

1) Open SQL Server Management Studio and connect to the instance.

2) Click on the database name that failed to login and Execute the below query.

UPDATE REGISTRY SET RegValue = '1.0.9.73' WHERE RegID = 2

3) Now you should be able to upgrade AutoCount and login successfully.

By: Aimi 230407, Lay Swan 230425, P230426

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 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