account - entry analysis - can not filter balance

[Ferdinand]

see screenshot
rows with balance 0.00 shouldn't show up
filter balance not equal 0 does not work either

[DBR (OpenERP) (dbr-openerp)]

Hello Dr. Ferdinand,

I have tested the Entries Analysis Report at my end but unfortunately not able to face any problem.
I have attached a video for your reference so please check and notify us where you face the problem.

Thank You.

[Ferdinand (office-chricar)]

OK I see the problem
to reproduce (may be you need more accounting data)

click group by "Acc Type"
(make sure that in one group are accounts with positive and negative balance)

now set a filter balance > 0
the is NOT applied on the group balance - what the user sees - but to sums "below" group level (which the user does not see)

hence the user (even myself) does not know what exactly is filtered ( I suppose the lowest level of the query , but without looking into the code I do not know what it is.)

IMHO it's a real life problem to allow/do analysis without knowing the data

to get correct/expected results it would be necessary to define on which level each filter has to be applied.

BTW why filter exists for account balance etc and not for products real stock ?

[Ferdinand (office-chricar)]

I have to answer myself
- balance in analyse entry is a database field (in a view)
whereas
- real stock of product and balance of accounts are a python fields

this is why nobody will understand why some fields are sometimes available for filtering and sometimes not.

[DBR (OpenERP) (dbr-openerp)]

Hello Dr. Ferdinand,

I have tested it again but still not able to face the problem.
Would you please attached your DB .
So, It will helpful for us to Qualifying the problem.

Thanks.

[Vinay Rana (OpenERP) (vra-openerp)]

You need to create supplier invoice and customer invoice. After paying all invoices add two filter condition with OR option in Entries Analysis Report.

Thanks.

[Ferdinand (office-chricar)]

any action from my side required?

I think #4 is the issue

[Ujjvala Collins (uco-openerp)]

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

[Ferdinand (office-chricar)]

well it seems to me to be a design and usability issue
you need very very educated users to make them understanding the logic behind

IMHO OPENERP needs 2 filter types
* apply on record level
* apply on group level

Example
Name | Debit | Credit | Balance
-------------------------------------------------------
account 1 | 100 | 0 | 100
account 1 | 0 | 100 | -100

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

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

[Ujjvala Collins (uco-openerp)]

Hello,

As the problem seems with the filters on the client side, I request community team to assign this bug to the respected team.

We will provide the needed information if there are any further requirements.

For the time being we're considering this bug as a wishlist.

Thanks,
Ujjvala

[Vinay Rana (OpenERP) (vra-openerp)]

As for Last above discussion I am assigning this issue to related team.

Thanks.