web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Pending vendor invoice report with workflow information

(1) ShareShare
ReportReport
Posted on by
Hello!

I would like how to find or create a report showing pending vendor invoices and approval steps. The purpose is for an AP manager to extract a report which tells all no final approved vendor invoices and at what step in the approval process the invoice is at and who the approver is for the step. Like a list of being to remind the approvers before month end closing. 

 
  • André Arnaud de Calavon Profile Picture
    308,247 Super User 2026 Season 2 on at
    Hi Eva,
     
    There isn't an out of the box report for this. You can use the Workflow history form as a System Administrator or Information Technology Manager to check all pending workflows. There is a public data entity work open workflow work items. You can use this one to e.g. load data into Excel and try to configure a report. Otherwise, you would need to consider a customization.
  • Suggested answer
    Kevin Xia Profile Picture
    Microsoft Employee on at
    Hi,
    There is no such out-of-the-box report, you may need to consider creating a custom report. Here are some steps to create such a custom report:
    1. Data Extraction: First, you need to extract supplier invoices and related approval information from the Dynamics 365 F&O database. You can use reporting tools or SQL queries to extract this data.

    2. Data Preparation: After extracting the data, clean and prepare it. Ensure that you have detailed information about supplier invoices, including supplier names, invoice numbers, invoice amounts, and data related to the approval process, such as approval status, approval steps, and approvers.

    3. Reporting Tool: Choose an appropriate reporting tool, such as Microsoft Power BI, Excel, or other report generation tools, to create a report based on the prepared data.

    4. Report Design: In the reporting tool, design a table or chart that displays detailed information about pending supplier invoices, including approval steps and approvers. Ensure that your report clearly presents this information.

    Best regards,
    Kevin

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284 Super User 2026 Season 2

#2
Aayush Tiwari Profile Picture

Aayush Tiwari 213

#3
Subra Profile Picture

Subra 200 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans