Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

(0) 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. 

 
Categories:
Financial Management
  • 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
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 283,860 Test role Public 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.

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,860 Test role Public

#2
Ludwig Reinhard Profile Picture

Ludwig Reinhard Microsoft Employee

#3
Martin Dráb Profile Picture

Martin Dráb 225,155 Moderator

Leaderboard

Featured topics

Test Comment 26-09-2024 16:14pm

Product updates

Dynamics 365 release plans