Skip to Content
This question has been flagged
1 Reply
8711 Views
Avatar
Karl Branyik

Hello,

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!!!

Avatar
Discard
Avatar
Ray Carnes
Best Answer

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.

Avatar
Discard
Karl Branyik
Author

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?

Ray Carnes

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.

Karl Branyik
Author

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)

Ray Carnes

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.

Karl Branyik
Author

Thank you very much!

Henry Padi Nyaunu

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.

Ray Carnes

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