Hi Everyone,
I need to fetch records for all pending vendor invoices as well as approved ones, including invoice amounts and other details. When I go to the vendor invoice transaction, I am able to get both approved and non-approved records. However, the issue arises when the approvals are still pending in the vendor invoice workflow; these invoices are not yet recorded in the VendTrans
table and therefore do not appear in the report. Despite this, they are visible in the pending invoice form with a workflow icon. What I require is to retrieve records for all invoices, regardless of whether they are approved, non-approved, pending, or in progress, even if they are still in the workflow and awaiting approval or rejection. We are specifically dealing with non-PO invoices.
Version : AX2012 R3