SQL for auto-rejected invoices
Hello
We are having an issue that the auto-rejected rule (by workflow) is not working. We need to check on the invoices that were rejected before we tried a few SQLs we have but it doesn't seem to get accurate result. We checked with users but they didn't have any records saved for the rejected invoices, as when the invoice was rejected (by this rule) they know it straight away and they corrected the invoice and then it's auto-approved by the workflow.
Could you please help if you have any SQL for this case? We need to get a sample of the auto-rejected invoice and provide diagnostic to the SR.