We have a tax item called, Incl VAT 10%, previously it was targeted to the wrong account called Product Sales, but later we changed it into a Tax Received account, and it is working fine now. But there are more records with the old setting, ie- taxes logged into the Product sales account. Is there a way to change all the existing accounts to the new Taxt received account available in the system?

One way is to go through all the records individually and do a reset to draft and then update the account. but this is a time-consuming one.

The issue comes when we took the ledger reports of the separate accounts, these tax data came inside the product sales report which is incorrect.

Any help is appreciated in advance. Thanks.