hello . as you can see in the screenshot , filtering the report by account is not working .
what is the problem
It looks like it’s working to me. The only records I see is the filtered “1149000000” account
I think that the account selected is a Group and maybe it is showing the childs too? Can you confirm if it is in face a group?
hello , thank you for your reply . No , the “is group” check box is unchecked .
From “Report Builder” please check “LFT” and “RGT” field values for the accounts for which you are generating General Ledger.
@pioneerpathan they do indeed have the same lft and rgt . what happens if I change the values ? is it something related to the tree ?
Go to report view of the “Account” docType. There you can see two fields: LFT and RGT. These are basically indexes to build tree structure of accounts. I am assuming there will be some wrong ordering of indexes for accounts. For more details, please visit the topic: Issue in LFT and RGT update for few accounts in Charts of Accounts and not shown in the Balance Sheet report - #2 by pioneerpathan
which I had posted once I encountered a problem.
I think, you first find out whether LFT and RGT indexes are incorrect or not? If it is then I will suggest you a workaround to resolve the issue.
can you suggest to us your workaround please
Yes @zbisho.
Accounts tree view structure is being build by LFT and RGT properties of an account. It means the child’s LFT and RGT must fall within the parent’s LFT and RGT. Please refer to my previous comment. If you change the parent account value of an account, the system will automatically rebuild LFT and RGT indexes for all the concerned accounts.
Please also note that an index value can not be used as either LFT or RGT index for more than one account.
Identifying any such anomaly will be the first step toward resolving the issue. If such a case is there then we need to rectify the improper indexes to obtain desire result.