Hi all,

My scenario is quite simple. I want to post a large down payment to my supplier and later on pay small invoices one at the time. For this, I am working with the 'account_voucher' module and what I do is the following:

1. Go to Accounting-> Suppliers -> Supplier Payment. In this form, just enter the Supplier, Total (1000), Date, Payment Method ('Cash') and 'Keep Open' as Payment Difference. I press 'Validate'.

2. Go to Accounting-> Suppliers -> Supplier Invoices. Here, I create an Invoice for the same Supplier with a Total of 200.

3. Then I go back to Accounting-> Suppliers -> Supplier Payment. I select my Supplier and I see that both transactions are being displayed correctly in the upper and lower grids. Moreover, the lower 'Credits' grid is displaying the Original Amount of 1000 and has suggested the editable amount of 200 automatically. So I just go ahead (leaving the header Total in zero and 'Keep Open' as payment difference) and press 'Validate'.

4. When I check back to Accounting-> Suppliers -> Supplier Payment and I select my Supplier, a line is shown in the upper 'Supplier Invoices' grid with an Original Amount of 200 and an Open Balance of 800. . Also, my initial 1000 down payment is no longer displayed in the lower 'Credits' grid, even though I still should have an amount to pay further Invoices.

So am I doing something wrong in my procedure? Or is such a scenario not supported?

I have dived a little bit into the data and the code and I see that the 'account.move.line' related to my initial 1000 payment is being skipped because it has an assigned 'reconcile_partial_id' (which makes no sense to me, because being a PARTIAL reconciliation it should still be good for further payments). Also, I see that the line that IS being displayed on the upper grid corresponds to one of the 'account.move.line' that got created as a result of my step 3 (which, even though has an assigned 'reconcile_partial_id' too, is being taken into consideration because it has no 'line.debit' and thus getting appended to the 'line_dr_ids' block).

Could there be a bug? Or can someone please explain to me the logic behind this code.


I'd really appreciate any help on this. Thanks a lot for the good work kept up on this forum.

Nicolas Bustillos

I think your problem is that OpenERP tries to use part of the $1000 to allocate to the invoice, even though this is a new payment.
In the supplier payment screen on the bottom half you will see an amount next to the original amount - set this to 0 and process the record. The advance payment will remain as an open item and appear on the next invoice to be paid.

Hi Kevin,
Thank you for your quick response.
Indeed, your suggested procedure does have the effect you predict. However, this does raise some new questions that I express here:
- By doing it like you suggest, I see that the resulting Journal Items (account.move.lines) no longer keep a reconcile relationship. Is this how it is supposed to work? Does this mean that I have no way of tracking the remaining credit that I have on a given down payment?
- On a related test, I see that if I create and additional Invoice whose amount exceeds my remaining credit (for example 900), I will be able to pay it against the same down payment by once again setting the Amount to zero. Are there some validations missing here?
- Also, even though the advance payment does remain with your suggested procedure, I see that the upper grid is still displaying the line with Open Amount of 200 as I describe in step 3 of my original post. Granted, the Open Balance is no longer showing 800 (since no partial reconciliation was made), but it does display an Open Balance of 200, which seems still incorrect I think. Is there some other workaround in the procedure to avoid this part of the problem?

Somehow, I’m inclined to believe that the procedure should maintain the reconciliation relation and that the problem lies in the logic by which OpenERP pulls the records when the Supplier is selected in the Supplier Payment form. By debugging and jumping coding lines, I have managed to force the inclusion of my partially reconciled down payment and then Validate it normally… the resulting postings seem correct to me accounting-wise. Hopefully someone can confirm which one is the right way to go.
I’ll keep doing more in-depth tests to get new clues. Thanks again.

Nicolas

In case anyone else wonders around this same subject, I did not find any explanation on this behavior after all this time. However, because of some other shortcomings with account_voucher module, the folks at Enapps did develop an alternate module to solve this and many other issues. You can read more about it in this post http://www.openerp.com/forum/topic28987.html. I recommend trying it.

Nico