Pending Invoice Form

Hi Everyone,

I need to fetch records for all the pending vendor invoices as well as approved once with invocie amount and other details.For this i went to vendor invoice transaction and i am getting approved and non approved records as well .but the problem is when the approval are still pending on workflow of vendor invoice workflow the invoice doesn’t get recorded on VendTrans table due to which it doesn’t appear on report on the other hand its available on pending invoice form with workflow icon.So what i want is to get records of all apprvoed non approved or pending status or inprogress status even that is in workflow even if it needs to be approved or unapproved We are basically using it for Non PO invoices.
Version : AX2012 R3

So are you saying the approved ones show in vendtrans and the pending ones show in vendtrans, but the ones that are in a workflow waiting for approval do not?

I’m surprised the unapproved ones are showing in vendtrans unless they were on an invoice register or something first…