invoice is inprogress in workflow not recorded on VendTrans and available at VendInvoiceInfoTable

(1) Share

Report

Posted on by Ayushaman

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

Categories:

Development / Customization / SDK

All responses (1)

Answers (0)

André Arnaud de Cal... 288,584 Super User on at

Like (0)

Report

invoice is inprogress in workflow not recorded on VendTrans and available at VendInvoiceInfoTable

Hi Ayushaman,

Do you have a query-based report or are you filling a temporary table using a data provider class? Using a query, you can try to create a union view. In case you are using X++ to fill your report data, you can check if the workflow is pending or not, then take data from one table or the other.