Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Report for approval date

(0) ShareShare
ReportReport
Posted on by 203

Hi

 

Is there a report I can run where it shows the approval date of a supplier invoice in Business Central ?

  • Suggested answer
    JAngle Profile Picture
    83 on at
    RE: Report for approval date

    As Alfredo’s screenshot shows you can in fact filter with the RecordID - which will require less lines of code. However, you could consider an excel report layout and add a power query to the approval entries and then have an excel lookup. Would potentially avoid any coding. You could achieve this without an excel layout report too. Just use power query to relevant pages you publish as web services.

  • Alfredo_Iorio Profile Picture
    1,260 on at
    RE: Report for approval date

    There isn't a standard report for that.

    You can add a new field to the purchase invoice using a link to the Approval Entry table.

    The purchase header table and the approval entry tables are linked through three fields

    Table No.

    Document Type.

    Document No.

    Here is an example of a link for an approved sales order

    pastedimage1661874015992v1.png

    Keep in mind that once posted, the purchase invoice will be archived and the approval entry will no longer be available.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,281 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,019 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans