Odoo Help


Invoice balance vs. overpayment

Karl Branyik
on 7/24/13, 4:27 PM 2,233 views


maybe I am missing something, but why is Balance field on invoice (just after Total) not showing NEGATIVE numbers, when an invoice was overpaid? E.g. Given a Customer Invoice for 100 Eur, received bank statement for the Customer 200 Eur, reconciled, Balance on Invoice Lines page shows 0. On the Payment tab you can get the overpaid value (with reconciliation id) in the field "reconcile_partial_id". Would be useful to see this right on the Invoice Lines page of the invoice automatically.

Thanx a lot for a hint!!!


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

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

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • 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/25/13, 2:57 AM

An overpayment ends up as an AR credit that can be applied to any other open Invoice, or used to pay a Credit/Refund Invoice for that Customer.

Either way It isn't related to the original Invoice, it is a credit on their ACCOUNT, not their INVOICE.

Thank you very much for the quick answer - just to repeat myself from yesterday - I agree (I assume that theoverpaid amount was written-off), but as far as this overpayment was reconciled with that particular invoice, I still think there could be a sign, that it was overpaid - what do you think?

enterpreneur, Karl Branyik
on 7/25/13, 3:08 AM

The payment was partially reconciled to close the invoice. This is no different than a customer paying $200 for two $100 invoices. Each will show the same partially reconciled payment information. Showing the 'overpaid value' in this case will NOT be accurate - and you have no way of telling the difference.

Ray Carnes
on 7/25/13, 3:15 AM

This is just for the sake: information that can be put easily into the system, should be easily retrieved as well (overviews etc. e.g. for managers)

enterpreneur, Karl Branyik
on 7/25/13, 3:17 AM

I understand. An invoice that was overpaid (and where the credit remains) and an invoice that was simply paid with an amount that was also used to pay another invoice (and where no credit remains) will be stored in exactly the same way. If you 'retrieve' this information for your managers it won't tell them the correct status of the account. They need to look at the AR balance to know.

Ray Carnes
on 7/25/13, 3:22 AM

Thank you very much!

enterpreneur, Karl Branyik
on 7/25/13, 10:43 AM

I have a similar problem which is the opposite of what is being discussed here. When I create an invoice and register a part payment, I expect the balance column on the invoice the record the balance but it records 0. I have this working well on another database I created but I don't know how it worked. Could anyone help please.

Henry Padi Nyaunu
on 10/23/13, 3:03 PM

Compare each database to see what is different. Journal, account types, accounts, partner settings.

Ray Carnes
on 10/27/13, 2:55 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.


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

0 follower(s)


Asked: 7/24/13, 4:27 PM
Seen: 2233 times
Last updated: 3/16/15, 8:10 AM