I'm almost done with setting up automations, but stuck on the last step.

I need a trigger to do the following:

When a Purchase Order is paid and reconciled, the Next Activity for that Purchase Order would be set to "Paid, Done"

I can find there's a "partner_id.invoice_ids.payment_state" field that shows Paid, Unpaid, Partially Paid.

However, I'm finding discripencies in the status as some of the paid Vendor invoice that's paid is showing Not Paid for some strange reasons. Even though the Purchase Order has a Paid label showing on the top right corner and the Amount Due (amount_residual) is $0.00

Therefore, is there a way to do an automation in the Purchase Order module but trigger is based on  Amount Due (amount_residual)?

Thank you