Filtering general ledger for one account, yet two asset accounts are being shown?

[OmelMedina]

Hey everyone,

I seem to have a weird issue in the General Ledger which ends up showing two accounts when I filter only for one of them. They are asset accounts and only these two accounts display this behavior? I have seen some discussions already on this and the general consensus is that we are filtering a Parent account. But that is not the case!

Here are some pictures

I just updated to the latest version of ERPnext and it didn’t seem to help the issue. I do have a custom app but I couldn’t imagine it would affect the General Ledgers filter like this. Both my production and test site show the same result. So it must be something specific to me for some reason. I did filter on the actual account column for those two different accounts and it does just fine. But the head filters don’t work for two different accounts?

[OmelMedina]

Never mind, I have figured it out shortly after. It seems like I had some corrupted indexes after some changes which caused the general ledger to show two accounts together when I filtered. Not sure exactly what change caused the issue!

The solution is to go into “Tree View” for the COA and click on the 3 dots. You should have an option to rebuild the tree. The general ledger relies on the tree to filter accounts properly. The lft_rgt_index composite must have been corrupted somehow in the tabAccount table for those two particular accounts. I’m assuming I thought this was taken care of automatically in version 15.34.0 according to this hotfix. But I suppose it could be something else!