← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 768817] Re: account - entry analysis - can not filter balance

 

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

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/768817

Title:
  account - entry analysis - can not filter balance

Status in OpenERP Modules (addons):
  Confirmed

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

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/768817/+subscriptions


References