Hello,
I'm working in a query to display the invoices that are in the user's workflow, let's said:
User A: 50 invoices
User B: 10 invoices
and so on. However, I realized that when a user does a transaction in the invoice, sometimes it doesn't update in the WF_Notifications table, specially when it's a rejection. I've searching in internet why it happens and a possible solution to it, but I found nothing. I tracked some invoices trying to establish a pattern between the ones that are not in WF_Notifications table and the ones that are there with no succeed. This issue happens mainly with Rejected invoices, some rejections make an update in this table and others don't.
Does anyone have experienced this same issue? Or why it happens?
Thank you,
Ana