Comment 9 for bug 768817

Revision history for this message
Ujjvala Collins (uco-openerp) wrote :

Hello Dr. Ferdinand,

I have checked this issue as per the comment #4.
For entry analysis report, the query is built on Journal items. So basically there will be two Journal items per Journal entry. One consists of debit amount and other with credit amount. Both will have the balance value as shown in the following case.

-> By original query we get the following result.
Name | Debit | Credit | Balance
-------------------------------------------------------
account 1 | 100 | 0 | 100
account 1 | 0 | 140 | -140

-> When we apply Group by Account, we the following result. (As you can see in the client.)
Name | Debit | Credit | Balance
-------------------------------------------------------
account 1 | 100 | 140 | -40

-> Now if we apply the filter Balance > 0, it will give the following result.
Name | Debit | Credit | Balance
-------------------------------------------------------
account 1 | 100 | 0 | 100

So whenever we filter the data with Balance > 0, it will show all the debited entries with with positive balance.

Hope I have made myself clear on this point. Can you please notify us if problem persists? Or can you please send us your screenshots?

Thanks,
Ujjvala