[V6] Partner ledger without reconciled entries

[Frederic Clementi - Camptocamp]

This bug is similare to "https://bugs.launchpad.net/openobject-addons/+bug/698063/comments/10" which has been fixed by quentin few weeks ago.
This report has big limitation : as long as you want to see all entries it is fine but if you decide to print the partner ledger without the fully reconciled entries you are in trouble...
Why?
Because the opening entry is reconcilied (by itself), so if you untick "includes reconciled entries" you will miss the initial balance due to the filter on the fiscal year.

[Frederic Clementi - Camptocamp (frederic-clementi)]

I forgot to specify this has been request by our customer with contract No M10121668.

Thanks

[DBR (OpenERP) (dbr-openerp)]

Hello Frederic Clementi ,

I have tested your scenario with the help of following points but did not face any problem.
1) Create three Invoices : first for January second for February and third for March.
2) January's Invoice is not reconcile[in Open state] and Feb. and March Invoices are Reconciled.
3) Print the report with the help of Partner ledger.
   a) Print Report for 1/2/2011 - 31/12/2011, check "includes reconciled entries"
   b) Print Report for 1/2/2011 - 31/12/2011, uncheck "includes reconciled entries"
   c) Print Report for 1/3/2011 - 31/3/2011, check "includes reconciled entries"
   d) Print Report for 1/3/2011 - 31/3/2011, uncheck "includes reconciled entries"

I have attached that Report's Screnshots for your reference,
Please check and notify me where you face the problem.

Thank you.

[Frederic Clementi - Camptocamp (frederic-clementi)]

Thanks for your tests.

1 - I have created a new DB (addons rev : 4477) based on your example but I do not get the same result, my initial balance is wrongly computed (whereas in you do not seem to have this problem).

See the attached DB...

2 - Try to do the test with 2 fiscal years (2010) + opening entries (01/01/2011) and you will understand what I mean

Thanks

[DBR (OpenERP) (dbr-openerp)]

Hello Frederic Clementi ,

I have tested your attached DB and the Found that the problem occur just because you were not install account_payment module.
I have installed it in your DB and attached it back again .
Please check once again and inform me Is it ok for you.

Thank You.

[Frederic Clementi - Camptocamp (frederic-clementi)]

Hi Devishree,

yes, it works. thanks
now let's go back to my initial request : initial balance do not work on the partner ledger if you have previous year balance.
So I have created the previous fy (2010) and added few invoices + generated opening entries.

Now the DB looks like this:
- dec-2010 : Mediapole 150 unpaid
- dec-2010 : Asustek 75 paid in dec-2010 (so fully reconciled on the 31-12-2010)
- dec-2010 : Distrib PC 95 unpaid
- dec-2010 : Distrib PC 98 unpaid
------------------------------------------------------------------------------
- 01/01/2011 - Opening entries generated (reconciled by itself)
-------------------------------------------------------------------------------
- jan-2011 : Mediapole 150 unpaid
- feb-2011 : Distrib PC 95 - paid 01/04/2011 (full reconcile)
- mar-2011 : Asustek 75 - paid 01/04/2011 (full reconcile)

Now print the partner ledger fy 2011 (no filter on date specified) with initial balance without reconciled entries ; you will see that initial balance is wrong (see attached printscreen)
In my opinion we have 2 error here :
1 - opening entries are reconciled so, when you ask for the report without reconcile entries, opening entries are also excluded from the initial balance calculation - it should not be.
2 - initial balance is computed from before the 1st day of the fy by default (or the selected date if you use the filter date). This rule is Ok as long as you exclude opening entries.
ex : opening entries are posted on the 01/01/2011, you print you report for 2011 (no filter), initial balance shows 0 because 01/01/2011 is not not considered.

hope this help (see DB as attached doc)

Frederic

[DBR (OpenERP) (dbr-openerp)]

Thanks for Reporting.

[Frederic Clementi - Camptocamp (frederic-clementi)]

Where is the tag Maintenance ?

Frédéric CLEMENTI
Business Solutions
CamptoCamp SA
Tel : + 41 (0)21 619 1041
http://www.camptocamp.com

 <email address hidden>

2011/4/4 Devishree Brahmbhatt (OpenERP) <email address hidden>

> Thanks for Reporting.
>
> ** Changed in: openobject-addons
> Importance: Undecided => Wishlist
>
> ** Changed in: openobject-addons
> Status: Incomplete => Confirmed
>
> ** Changed in: openobject-addons
> Assignee: (unassigned) => OpenERP R&D Addons Team 3
> (openerp-dev-addons3)
>
> --
> You received this bug notification because you are a direct subscriber
> of the bug.
> https://bugs.launchpad.net/bugs/734823
>
> Title:
> [V6] Partner ledger without reconciled entries (M10121668)
>
> Status in OpenERP Modules (addons):
> Confirmed
>
> Bug description:
> This bug is similare to "
> https://bugs.launchpad.net/openobject-addons/+bug/698063/comments/10"
> which has been fixed by quentin few weeks ago.
> This report has big limitation : as long as you want to see all entries it
> is fine but if you decide to print the partner ledger without the fully
> reconciled entries you are in trouble...
> Why?
> Because the opening entry is reconcilied (by itself), so if you untick
> "includes reconciled entries" you will miss the initial balance due to the
> filter on the fiscal year.
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/openobject-addons/+bug/734823/+subscribe
>

[qdp (OpenERP) (qdp)]

should be solved in branch bzr+ssh://bazaar.launchpad.net/~openerp-dev/openobject-addons/trunk-bug-734823-qdp/

i'll be doing more tests and let you know

[qdp (OpenERP) (qdp)]

similar as bug 750308.

I tested more and the above branch doesn't fix anything.

Actually, this won't be that easy to fix because the way the initial balance is computed is incompatible with the boolean "include reconcile entries". More investigation is needed.

Maybe a very easy way would be to let the choice between:
*either we do display only the unreconciled entries, without any filter (and thus any initial balance) available
*either we do display entries based on some filters (with initial balance) but then we display also the already reconciled entries

Any opinion on these solutions would be appreciated,

Thanks,
Quentin

[Frederic Clementi - Camptocamp (frederic-clementi)]

Hi Quentin,

about your 2 possibilities :

*either we do display only the unreconciled entries, without any filter (and
thus any initial balance) available

--> if you only show unreconciled entries without any initial balance, we
will not match with the partner balance and the report will be useless.

*either we do display entries based on some filters (with initial balance)
but then we display also the already reconciled entries

--> this is how it works today and I am fine with that (I want to keep
this). But we also need the unreconciled amount only.

1st thing to do for me would be, whenever "unreconciled entries" is false
then excludes all reconciled entries EXCEPT opening entry (entry which is in
a journal type = situation)...what do you think?

[qdp (OpenERP) (qdp)]

Sorry for the delay, i wanted to make sure it was not possible and i wanted to get the advices from "above".

After those investigations, the decision we took is the following: we will disallow to select the 2 options "unreconciled entries" and "with initial balance" at the same time.

not really a perfect solution but at least the figures will be correct.

Thanks for the contribution Frédéric

[Purnendu Singh (OpenERP) (purnendu-singh)]

Hello Frederic Clementi,

We have fixed the problem in lp:~openerp-dev/openobject-addons/trunk-bug-744789-qdp

For that We are not allowing the user to select both 'Include Initial Balances' and 'Include Reconcile Entries' options at the same time

Revision No: 4646
Revision ID: <email address hidden>

Thanks,
Purnendu Singh

[Frederic Clementi - Camptocamp (frederic-clementi)]

Ok but initial balance is still computed from the 1st day of the fy... it does not take into account the balance brought forward (previous year balance).
Unfortunately it does not fix our problem :(

[qdp (OpenERP) (qdp)]

the branch containing the bugfix is merged at revision 4702, so i guess it's fixed in trunk. Let us know by reopening the bug if it's not the case.

Thanks,
Quentin