I need to query the general ledger accounts for a given party because it has balance in many accounts.
In Spanish chart of account a customer can have balance in accounts 430,4304,4309, 431, 4311,4312,4315, … Same situation for suppliers with accounts 400, 44x.
Actually double clicking an account general ledger you can get the detail of all the parties of this account and their balance. But there is no way to get the detail of all accounts of a party despite it is the same data filtered by party.
Indeed it can be achieved defining a form relate from party to general ledger - account parties.