How to filter by Invoice ID that has had the invoice approval state 'Automatic Rejected'.
I want to filter a dashboard to show all invoices that still require action to be taken, that were automatically rejected by the system.
I want to see all rows of "Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approval Action", for each "Payables Invoices - Transactions Real Time"."- General Information"."Invoice ID" where at least 1 "Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approval Action" = "Automatic rejected" AND "Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approval Status" = "Rejected".
I think I need to use the filter 'by' operator for the filter on approval action, but I'm not sure how to form the valid syntax. Can anyone advise?
0