Odoo Help


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.


Payment to reconcile invoices of a different customer

Maxime Chambreuil
on 7/15/15, 5:32 PM 721 views

Here is my scenario:

  • I have a partner Company A which have 2 affiliates companies : Company B and C.

  • I send one invoice to Company B and another one to Company C

  • I received one payment from Company A to pay for the 2 previous invoices.

Do you have a solution to enter the payment from Company A and reconcile the invoices to B and C ?

We are considering the use of res_partner_affiliate to structure the Company/Affiliate relationship.

Eric Caudal
On 7/16/15, 5:04 AM

Reconciliation will be based on the AR account+associated partner so you cannot directly pay an invoice for another partner

Original vouchers are similar to:

DR AR - company B 100

CR sales 100

DR AR - company C 200

CR sales 200

If the mother company is always paying for the children you might want to share the AR account in all partners (but not mandatory see below)

You probably have to go through an intermediate voucher (intercompany payment) such as:

DR AR - Company A 300

CR AR - Company B 100

CR AR - Company C 200

You could simply create a journal with the account AR for company A.

Then you can issue your payment against line 1 and reconcile the other 2 lines with the original invoices


Ray Carnes

--Ray Carnes--
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

Ray Carnes
On 7/15/15, 9:41 PM

Since partner_id must match to reconcile a payment with an invoice, I have in the past supported this by:

1.  Overriding the definition of res_partner.commercial_partner_id so it can be edited.

2.  Adding commercial_partner_id to a res_partner form view so it shows on the UI.

3.  Telling users that Company B and Company C must be setup with Company A as the Commercial Entity (commercial_partner_id).

Invoices for Company B or Company C will now be booked in the Sales Journal as partner_id = Company A.

When a payment for Company A is entered, invoices for Company A and the two affiliates will show as being able to be paid.

Note that with this setup, Company B and Company C will never be able to pay their own Invoices, so this may not support all Use Cases.

Bista Solutions US, Ray Carnes
on 7/15/15, 9:43 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

1 follower(s)


Asked: 7/15/15, 5:32 PM
Seen: 721 times
Last updated: 7/16/15, 5:04 AM