SQL for auto-rejected invoices — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!