Odoo Help

1

Payment to reconcile invoices of a different customer

By
Maxime Chambreuil
on 7/15/15, 5:32 PM 1,132 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.

1
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

1

Ray Carnes

--Ray Carnes--
17138
| 9 7 9
Atlanta, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0.

Completed Odoo Functional and Technical Training.

Major Skills:

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

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. 

I am a skilled Communicator and I only take the serious things seriously!

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

About This Community

This platform 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.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

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