trunk - balance amount missing in journal entries

[Frederic Clementi - Camptocamp]

A wish more than a bug...
Would you mind sometime to add the "total balance" beside Total debit and Total credit at the bottom left hand corner of list of entries screens...
You have no idea how this small add could be useful. (I am simply taking about Total balance = Total Debit - Total Credit)

see attached doc

Many thanks

Frederic

[DBR (OpenERP) (dbr-openerp)]

Thanks for reporting.

[xrg (xrg)]

On Wednesday 06 April 2011, you wrote:
> Public bug reported:
>
> A wish more than a bug...
> Would you mind sometime to add the "total balance" beside Total debit and
> Total credit at the bottom left hand corner of list of entries screens...
> You have no idea how this small add could be useful. (I am simply taking
> about Total balance = Total Debit - Total Credit)
>

I gave your idea a few minutes of thought/search..

If we had a "line_balance" field, merely of (debit - credit), we could have
solved that in just one xml line.
 like <field name="line_balance" sum="Total balance" />

But, the one we have, the "balance", is a /running sum/ ! It will not just
compute the current line. So, we cannot use that.

Conclusion: please wait a bit more to decide on the right field to support.

[Ferdinand (office-chricar)]

see patch
I have also added
'balance_line_abs': fields.function(_balance_move_line_abs, method=True, string='Balance Line abs'),

this makes it easy to sort by absolute values because matching move lines have often debit = credit and ther is no other way to see these lines next to each other than ordering by absolute values

in another system we even had an automatic reconciliation using the absolute values.