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 of action to update the invoice when the payment is created. but when i delete the payment i cant seem to figure out how to update that invoice as the action needs a reference to update a record.
any advice/help would be appreciated.