Transaction has got posted to a group account in the Chart of Accounts

Hi,

We are using v15.30.0 (version-15). We been using ERPNext for many years, and suddenly we found during a reconciliation that one of the transaction has got posted to a Group Account in the Chart of accounts. Usually, we see an error when you try to post to a group account. I have no idea how the transaction value has got posted from the Delivery Note.

Now I’m unable to delete the transaction (to correct the posting). It gives me the standard error saying, “…Group Account and group accounts cannot be used in transactions”.

Below you can see the Chart of Accounts, the posting should be to account 5171 but has got posted to the group account 5170.

The next image GL shows the posting.

Does anyone know how I can correct this accounting error. (BTW I cant correct it by a Journal Entry also, as it says 5170 is a group account …

CoA Group Account Tree

Hi,
has anyone faced this problem? Does anyone know the solution to this, please? Thanks.

Hi, this happens when your account is in non group and then you have done a transaction and after few days you move that account from non group to group. And then looking at the previous transaction, this happens.

Hi Shiv,
Thanks for the reply. This particular expense account has not been edited / changed in over 2 years (see image below). However, the GL entry (which has gone through a delivery note) happened about a month ago.

Can there be any other reason to do this?
Do you know any way I can transfer the transaction value to a different account (5171) ?

Mostly there is a bug there check your delivery note you will find that account try to reproduce the issue and open issue on github

Thanks, I’ll try to reproduce the scenario. Do you have any idea how I can reverse/change the existing entry?

You have to check the transactions related to those accounts.

There is only one transaction that has got posted to this group account from the beginning. That is the delivery note mentioned above. However, now it doesn’t allow me to cancel the delivery note, as it says 5170 is a group account. Any workaround?

Hi,
I still haven’t been able to sort this problem. Any help is really appreciated.
Is there some way I can at least change these CoA number ended in the transaction to the correct one from the backend?