c2c-oerpscenario team mailing list archive

["Frederic Clementi - Camptocamp.com" <734823@xxxxxxxxxxxxxxxxxx>]

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


** Attachment added: "DB with 2 fy: 2010 and 2011"
   https://bugs.launchpad.net/openobject-addons/+bug/734823/+attachment/1976983/+files/payment_20110401_18_15_20110404_12_33.sql

-- 
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/734823

Title:
  [V6] Partner ledger without reconciled entries (M10121668)

Status in OpenERP Modules (addons):
  Incomplete

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.