Reply To: Master2023 PDO Error when saving new invoice

#2164
fearless359
Keymaster

The payment_warehouse ia how excess payments are handled. Example: Invoice is for $35. Client sends in $40. You apply the $40 payment and see a warning that the payment exceeds the invoice amount. If you proceed to apply the $40 payment, $35 is applied to the invoice and $5 is warehoused. Same customer now has an invoice of $50. If you apply a payment, you are forced to apply the warehoused %5 before you can apply any other payment. After the warehoused payment has been applied, you can apply a new payment.

In the past, you could apply the $40 to the $35 balance and the $5 excess has no invoice item corresponding to it. You could adjust the $35 invoice to be $40 and apply the payment. But to my thinking, that invalidates the invoice that the client received and paid. If you want to do this without changing the invoice now, you apply the $40, let the excess be warehoused and then delete the warehoused record.

I have customer’s with recurring costs and they prepay several months in advance. I use the recurrence feather to generate their invoices. I don’t email the invoices when generated. First, I allow the warehoused payment to be applied. Then I regenerate the invoice and then send it to the client. This way, they see their excess has been applied with what the remaining balance of the invoice, if any, is left to be paid.

Hope this explanation helps.