[account] Error report third party balance

[Sébastien BEAU - http://www.akretion.com]

Hello everybody

I found a bug on the last version of Openerp v5 (source launchpad) with the module account installed

Situation :

Create a invoice, validate it (I create it the 19 October 2010)
Paid it and choose as date of payment a date in the future (for example a day in the next month, my date was the 19 November 2010)

==> Now we have a invoice and his payment, the two entries are reconciled

Now go in Financial Management > Reporting > Partner Ledger

- Partner : Receivable and Payable Accounts

- kept the option "include reconciled entries" to False

- Choose filter by date
        from (a date before your invoice) for me 1 October
        to (a date after your invoice but before the payment) for me the 31 October

- Print the report

====> you have an error in your report. The balance is totally wrong. Why?

Remember : By default the report print only the lines unreconciled.
The 31 October the invoice is not paid (because the date of the payment is the 19 November) and so this line have to be in the report ! ! !

Problem : checking if a line is reconciled is not enough because an invoice can be reconciled with a payment which is not in the period filtered. So we have to check if the entries are reconciled and also if all of the entries are in the period !!

Moreover I try to select the option "include reconciled entries" which will solve my problem (yes I will have all of the reconciled entries, and so my report will have a lot of useless information but the balance will be right!!). But this option doesn't work!!! (only unreconciled line are printed) I made a path to make the it working (I made it quickly 10 min to find a quick solution for my customer, so take your time maybe it's not the best solution)

Thanks

[Sébastien BEAU - http://www.akretion.com (sebastien.beau)]

here is the patch

[Sébastien BEAU - http://www.akretion.com (sebastien.beau)]

here is the patch

[Fabien (Open ERP) (fp-tinyerp)]

not sure the patch is correct, we need unreconciled entries, not all entries in this report ?

[Jay Vora (Serpent Consulting Services) (jayvora)]

Hello,
Our R&D Teams are currently focused on the latest OpenERP version.

If you want this fixed as a higher priority, you may contact our Maintenance team via the OpenERP Publisher's Warranty, and they will quickly help you solve this issue. I am closing the bug for stable.

Thanks for your comprehension.

[Azazahmed Saiyed (OpenERP) (saz-openerp)]

Hello Sebastien,

We will discuss this concept with our accounting experts and let you know the further improvements are needed or not.

Thanks.

[Sébastien BEAU - http://www.akretion.com (sebastien.beau)]

Hi I was very busy. Sorry to don't had any comment before.
The first patch was just for saving time for my customer, the balance is right but you have all of the lines (very very very ugly)
Here is right patch. I change sql request in order to check the date of all reconciled entries.
It's works in production for my customer.

[Azazahmed Saiyed (OpenERP) (saz-openerp)]

Let the team will decide.

[Mustufa Rangwala (Open ERP) (mra-tinyerp)]

Hello Sébastien,

I have checked your scenario with Latest Trunk Addons (6.0). And it works fine without any problem.

If i include reconciled entries = False and print report it balance is not wrong and if i set include reconciled entries = True then we will have Sale journal entries (of invoices) on the report but not Payment entries on the report. So it seems correct.
So i make this bug invalid for trunk and if you have problem please first test on latest trunk and give us the case.

Thank you,
Mustufa