c2c-oerpscenario team mailing list archive

["vra \(openerp\)" <449549@xxxxxxxxxxxxxxxxxx>]

** Changed in: openobject-addons
       Status: New => Triaged

-- 
critical accounting regression: invoice residual after partial reconciliations
https://bugs.launchpad.net/bugs/449549
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Addons Modules: Triaged

Bug description:
Hello,

I think the problem is present in v5.0.6 and is a regression since the last month.
I'm using server 5.0 rev #1877 and addons 5.0 rev #2435

SUMMARY:
when partially re-conciliating a single payment with several invoices (which happens often for instance with partial pickings + invoice on picking), the amount due displayed in invoices can be completely wrong.

HOW TO REPRODUCE:

1) Install a fresh database with manufacturing profile and demo data, minimal chart of account.

2) create a new customer invoice for partner "Bank Wealthy and sons" with one line with 1 PC1; total price is 450 euros; validate the invoice.

3) duplicate that invoice to get a second invoice with total 450 euros (the bug is not related to invoice copy); validate that second invoice.

4) in Financial Management > Entries encoding > Entries by statement
create a new statement for journal CHK, partner: "Bank Wealthy and sons"
pay 900 euros (amount of both invoices)
validate the statement.
(see screenshot)

5) Open the reconciliations in Financial Management > Periodical Processing > Reconciliation > Reconcile entries
(select account 'Main receivable 400000)
You'll see 3 entries in the list: the two invoices and the payment.

6) select the payment mine and one invoice line and perform a partial reconciliation on them.
(see screenshot).
After that first reconciliation, things are OK. If you reload the invoices, you will see that in one amount due is still 450 euros (it has not been reconciled). And in the other invoice, amount due is -450 euros (since it's reconciled with a payment of 900 euros, that's OK).

7) Now, let's produce the bug: in the reconciliation list view, reconcile the second invoice with the same payment.
In the reconciliation list view, all entries are gone because everything is reconcile perfectly, that's correct. The partner balance is 0 which is correct too.

HOWEVER, if you reload the invoices, you will see that amount due in both invoice is -900 euros, which is absolutely WRONG! (it should be 0 on both invoices).
(see screenshot)

I think this is absolutely critical because you can't show the produced invoices to your customer. However, it looks like it's not a reconciliation bug (because balance is correct, things are properly reconciled) deep bug but rather a wrong update of the invoice after reconciliation. I think is was correct back around v 5.0.3/5.0.4 at least.