Comment 2 for bug 922621

OK.

Excellent, i got it.

Our Poitn is, if you set a simple sum, no matter where you use it , it will be bad calculated.....

Please, how we are working on this too!,

can you improve just:

'foreign_balance': "COALESCE(SUM(l.amount_currency), 0) as foreign_balance",

Whit the correct SQL part, to put inside our Algorithm please.

BTW.

One question is important:

If I have 10 aml with 5 different currencies and some in 0 (empty), how this Amount must be shown an P&L?

Is a important question that we need to document before program IMHO (as anglosaxon does some time).

This kind of features can brake all demo, if number doesn't comply with accounting specifications.

Regards, and thanks for your time men!!!