Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Conciliation of invoices and pays

By
José
on 4/9/15, 6:21 AM 1,040 views

Hello, I have Odoo 8.

Follow this situation: a customer pays me $1000. I generate a "Customer payment" in "Accounting -> Customer payments". Then, the same customer, buys me two invoices of $100 each one. I want to set the two invoices paid and that the client has $800 of balance.

What is the best way to do this? Thanks!    

2

zbik

--zbik--
5941
| 6 4 7
Lodz, Poland
--zbik--


zbik
On 4/9/15, 2:32 PM

The first way ->

a) menu Accounting/Periodic Processing/Reconcilation/Manual Reconcilation

b) menu Accounting/Payment Follow-up/Reconcile Invoices & Payments  (module account_followup must be installed)

The second way -> Customer view -> Jurnals Items -> check selected -> More -> Reconcile Entries

You select entries with the same account number (one debit and one credit). If Credit != Debit  you click on button Partial reconcile in next step (or Reconcile with Write-Off if expected is to divide the payment for parts). How to select correct Account number? -  this account has ... type = Receivable ... and has checked ... Allow Reconciliation = 1

The third way  -> menu Accounting/Bank and Cash/Bank Statements.

Create new bank Statement, insert new payment and reconcile with selected invoices or other entries

The fourth way -> install and use module account_voucher + The first way or/and The second way


PS. Invoice is Paid if all corresponding account move lines are reconciled, see method test_paid() in account_invoice.py


First way: I don't have menu "Payment follow-up" inside Accounting tab. Need I to install any other module? I have "account_accountant" module. Second way: I do this, but what entries I have to select? I have two entries for each transaction, one in the debit and one in the credit. And then, have I to do a partial conciliation or a reconciliation cancellation? Thanks!

José
on 4/9/15, 4:38 PM

Another way. Answer updated.

zbik
on 4/10/15, 5:42 AM

The reconciliation with bank statements works for cash pays?

José
on 4/10/15, 7:04 AM

In menu Bank and Cash you have both: Bank Statements and Cash Registers, works similar.

zbik
on 4/10/15, 7:15 AM

Queston 2) In the "other way", in the most cases credit != debit. So I do a partial reconcile. But the entries are still there! Only Odoo adds a "Ref of conciliation" which is a code like "A1, A2, etc". How works this? And the invoices are still "Open", not "Paid".

José
on 4/10/15, 7:25 AM

Ref of conciliation ... see my answer: https://www.odoo.com/forum/help-1/question/please-what-is-the-link-between-vouchers-and-invoices-in-the-tables-75860#answer-75861

zbik
on 4/10/15, 9:07 AM

Ok, moves with the same reconcile_id.name are reconciled, but still I can see there in the "Manual reconciliation" with the filter "unreconciled" and the invoice are still "open". I only want to set invoice -> "paid" in the most simple way when the payment is before the invoice...

José
on 4/10/15, 9:24 AM

Answer updated. I reconcilation is full and ok, invoice sate = Paid.

zbik
on 4/10/15, 10:33 AM

I have the module account_voucher. The partial reconciliation, is not a full reconciliation? I know that the invoice is paid if I do a "reconciliation with cancellation" but if I do a partial reconciliation, why not?

José
on 4/10/15, 2:47 PM

When you select Partial Reconcile invoice is not "Piad", only value "to pay" = 0. Your needs are waiting "Reconcile with Write-Off".

zbik
on 4/10/15, 3:13 PM

Ok. I am searching a way to automatically set the invoices paid if the customer has "balance ($)" > "total invoice ($)" and decrease the balance. Is there any way? Thanks you a lot for the patient!

José
on 4/10/15, 3:58 PM

The third way

zbik
on 4/10/15, 4:19 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 4/9/15, 6:21 AM
Seen: 1040 times
Last updated: 4/10/15, 6:19 PM