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

(1) Share

Report

Posted on by Ayushaman

275

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

I have the same question (0)

All responses (5)

Answers (0)

Sort by

André Arnaud de Cal... 306,859 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Ayushaman 275 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

I am filling a temporary table using a data provider class i tried to join the workflow but the data is only availble on VendInvoiceInfo Table and the standard Vendor invoice Transaction report has joins with VendTable,VendTrans,GeneralJournalentry and GeneralJournalaccount entry. I not only need if the invoice is approved or not I also want the invoice amount for the pending invoices or which are in progress in workflow and not the sum of Line items the invoice amount. This is currently important for me if you want any extra information feel free to revert me back.

Thanks,

Ayushaman

Was this reply helpful? Yes No
André Arnaud de Cal... 306,859 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Ayushaman,

I'm not able to understand where and how you need help. Can you share some more details? Did you create an own data provider class or are you trying to reuse existing F&O logic?

Was this reply helpful? Yes No
Ayushaman 275 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre ,

Their is a standard report that already exist i can reuse that report name is Vendor transaction report (vendInvoice) I need help in the aspect of when their are invoices that are in pending state in vendorinvoice workflow and needs approval of some user in that case the invoices records don't get mapped on Vendtrans table in the form of approved or not approved or even pending i want those pending records details in the vendinvoice report including invoice amount and other details. That where i am stucking at to be precise .
Version :AX2012 R3

Was this reply helpful? Yes No
André Arnaud de Cal... 306,859 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Ayushaman,

If you copied all objects from the Vendor transactions report, you can change the data provider class and get additional data from other tables and store it in the VendInvoiceTmp table which is used for the report data. In case you need additional fields, you can also extend or copy the temporary table.

Was this reply helpful? Yes No