Announcements
No record found.
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
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"
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'
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
Hello Brian,
where i can find the "Purchase order Listpage" (am not sure i would have access) - but if you can tell me if i can find, i will see with colleagues to try do perform the steps you emntioned.
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, 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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 510 Most Valuable Professional
André Arnaud de Cal... 302 Super User 2026 Season 2
CU-1234529-002 197
