Accounting 2.0 - AR: Unable to reassign tax entity in Debtor/ Creditor Maintenance (shown in grey)

Question: I wish to reassign the tax entity in Debtor Maintenance but the tax entity field is grey now, how I can change it to the correct Tax Entity?

Answer (1):

1) Backup the account book. Define the debtor account number as the accno need to be use in the sql query.

2) Go to AutoCount Accounting Management Studio > SQL Query > Run this query.

update Debtor set TaxEntityID = null where AccNo = 'xxx-xxxx'

update Creditor set TaxEntityID = null where AccNo = 'xxx-xxxx'

When the tax entity number become null, you should be able to assign new Tax Entity Number.

Answer (2):

Update to version at least 2.2.6.7, in this version system allow you to reselect the TIN number.

By: Soh Wee 240625, Lay Swan 240729, Jae Sen 240805