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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Pending vendor invoice...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Pending vendor invoice report with workflow information

(1) ShareShare
ReportReport
Posted on by Community member
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. 

 
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,731 Super User 2025 Season 2 on at
    Pending vendor invoice report with workflow information
    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
    Kevin Xia Microsoft Employee on at
    Pending vendor invoice report with workflow information
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 683 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 563 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 398 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans