Is it possible too separate account by partner when their balance haven't the same sign?

[pasgou]

Is your feature request related to a problem?
When editing a Balance sheet, I have to separate account between credit balance and debit balance without to compensate partner's balances.
Describe the solution you'd like
a mean to select balance by partner and not only by account

extend the issue #378

[pasgou]

I have searched a solution without development.
Here is my Solution =
In queries, add an item on account move line to fetch partner, credit and debit, with a domain corresponding to the account you want to select (in France, for example, I want select clients account only, and the account is '411100')

In KPI's, you can create a line and use the queries. Here I want to have the positive balance of clients only.
As in query I didn't add an accumulation method, we obtain a list. It was difficult to me to find a way to use this list but try to print the list to understand and the light will illuminate your brain as my own.
Here is the expression:

Explanation :
[partner_id.debit - partner_id.credit for partner_id in partner] gives a list of amount calculate with "partner_id.debit - partner_id.credit".
We calculate the sum of element (elt) where elt is positive or null.

Pro : I have the right amount without compensation between positive and negative partner's accounts
Cons : I don't have the detail anymore.

My way.

[sbidoul]

Clever solution.

[pasgou]

Problem with my solution : the comprehensive list do not order the sum by partner but by sign. If someone could test this and give ideas ...

[github-actions]

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days.
If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.