We have a customer that has overpaid an invoice by say $200. When we receipt the payment we have a choice of converting excess into absolute discount or create a credit note.
If we create a credit note, we can then do a refund from the credit note, however this impacts on the sales totals as when you list invoices for the customer the credit note will come off the total, so you have to do an invoice to offset the credit note, then change the receipt of funds to apply across the original invoice plus the new one to offset the credit note. When this is done the total for invoices now correctly reflects sales and you see two bank transactions.
If you select “convert excess to absolute discount” it shows against the customer record, but there is no mechanism to issue a refund from this absolute discount. If you could enter a refund against a selected absolute discount then this would solve the problem.
I think the option is already there. How about this process:
issue invoice about e.g. 100 EUR
customer pays 150 EUR to you
record received payment of 150 EUR (overpayment) - do not close the invoice yet
now send back 50 EUR (the overpayment to the customer) (bank transfer or whatever)
record the payment of -50 EUR also with this invoice (note the - sign), it now can get closed
When reconciling transactions, the received payment and the refunded part will both get reconciled against the same invoice. Same procedure as if a customer makes several partial payments for the full amount of an invoice.
