Share
ReportHello dear All,
Would like to know if there is in D365 FO a report where i can extracted a list of PO´s that have attachments (type)
thank you
You’re offline. This is a read only version of the page.
8
Hello dear All,
Would like to know if there is in D365 FO a report where i can extracted a list of PO´s that have attachments (type)
thank you
Hi, Purchase orders listpage is All Purchase orders form
Procurement and sourcing > Purchase orders > All purchase orders.
same can be accessed from Accounts Payable> Purchase orders > All purchase orders.
Purchase order list page is the place where all the purchase order header are found as a form in d365fo ui. As others suggested, you can simply fire an SQL query to get the respective records.
Hi Aleja,
You can use Data management to export the entity "Purchase order header document attachments".
In this entity, you will see the attachment types assigned to each PO.
Hope that helps you.
Magno
Hi Aleja, I don't know if there is any standard report to display that information. However, it can be achieved by below SQL query. This query will return all Purchase order numbers that have an attachment. You can change value in DataAreaId for legal entity specific data. The result can be exported to csv, excel or other supported formats.
select PurchId from PURCHTABLE join docuref on PURCHTABLE.RECID = docuref.REFRECID And PURCHTABLE.DATAAREAID = 'USMF'
There is no standard report for this but a query can be built and added to the Purchase order Listpage to achieve the same result.
The table name is "DocuRef".
The field name is "TypeId"
#1
André Arnaud de Cal...
291,703
Super User 2024 Season 2
#2
Martin Dráb
230,433
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
