Finance | Project Operations, Human Resources, ...

Need to extract invoices have been applied against PO

(4) Share

Report

Posted on by CU10121822-0

276

Hi team,

I am looking for solution to get list of invoices have been applied against PO in d365fo.

Can anyone please let me know the best approach.

Give me the thoughts pls. Thanks!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Paolo Cecchelli 344 on at

Like (1)

Report
Copy link

Link copied!

Hi,

if you just want to know which invoices were created from POs, the the simplest way is to go to "Accounts payable --> Inquiries and reports --> Invoice --> Invoice Journal" and add the column "Purchase type":

Purchase type has two values: "Journal" or "Purchase order". Purchase orders are the ones coming from a PO:

Pay attention that in Invoice journals the column "Purchase order" (the second in the screen) cannot be trusted because is filled only if there is one PO in the invoice, if multiple is blank.

If instead you want to know each invoice line which PO took into account, I do not think that there is a report OOB but what you can do is to go with the table browser on the VendInvoiceTrans and extract from there (fileds important for the extraction are OrigPurchID, InvoiceID, InternalInvoiceID).

Maybe someone else have better solutions.

Hope it helps

Was this reply helpful? Yes No
CU10121822-0 276 on at

Like (1)

Report
Copy link

Link copied!

Thanks Paolo,

Can anyone suggest on this... thanks!

Was this reply helpful? Yes No
CU10121822-0 276 on at

Like (0)

Report
Copy link

Link copied!

Please let me know in query what tables are required to get the respective invoice which belongs to the PO.

Please give me the thoughts. thanks!

Was this reply helpful? Yes No
Suggested answer

Paolo Cecchelli 344 on at

Like (0)

Report
Copy link

Link copied!

Hi Christina,

maybe I was not clear enough or maybe I am not getting your question :), let me try to rephrase: in the table VendInvoiceTrans table you have the list of all invoice lines and their respective InvoiceId (field InvoiceId) and also the voucher (InternalInvoiceID). You also have another field called OrigPurchID in which you have the PO number. You have to use the lines and you cannot use the Header (VendInvoiceJour) because you could have more than one PO per Invoice.

To get to the table you can use the table browser and add this URL after the environment URL:

?mi=SysTableBrowser&tableName=VendInvoiceTrans&cmp=PUTHERETHECOMPANYDATAAREAID

In this way you will see the fields in the table VendInvoiceTrans:

Moreover, if you want to link to the Purchase Order line, in the same table you have the InventtransID that is the unique identifier of the line on the PO that is also on the VendInvoiceTrans:

- PO line (PurchLine):

- VendInvoiceTrans:

Hope now is clearer, if not or if this does not fit your need please let us know

Was this reply helpful? Yes No
André Arnaud de Cal... 303,093 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you please clarify if your question is about Dynamics 365 or Dynamics AX? In the body of your question you mentioned Dynamics 365, but the tags contains the category Dynamics AX. That is conflicting.

In case the reply from Paolo is not what you are looking for, can you then please elaborate on your question? Do you need to run a report or query data on a form? Are you probably looking for help on a development task or do you need a list of invoices for a specific PO number?

Was this reply helpful? Yes No
CU10121822-0 276 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

Yeah it's from D365FO. I am looking for list of invoices for the PO.

Kindly elaborate pls. thanks!

Was this reply helpful? Yes No
André Arnaud de Cal... 303,093 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Did the first reply from Paolo not answer your question? If not, please elaborate with exact details.

Was this reply helpful? Yes No
Shubham Das 29 on at

Like (0)

Report
Copy link

Link copied!

Hi,

The response from Paolo is the best way to address this. Other possibilities (slightly complex and non-real time is developing reports using Business Performance Analytics).

Thanks,

Shubham

Was this reply helpful? Yes No