when i delete payments, it also deletes “payment details” as they are
considered a part of the “payment” record. how do i update the invoice
status and balance without using virtual columns. to create
payment/details and update invoice i use a series...