Query to select AP invoices that are in status : Selected for payments
Hello Community,
need a help on query to use to select invoices that are in status : Selected for payments.
I was used the field: APPROVAL_STATUS_LOOKUP_CODE = APPROVED, But this appear incoice with status validate and invoice with status : Slected for payments. i need onlu slected for payments.
which table / field can i use?
Thank you
Damya