Skip to main content

Notifications

Announcements

No record found.

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

View of vendor transactions and history

Posted on by 130

Hi community,

I have a request to improve a users' ability to pull up information on: Purchase Orders, Invoices, and approval history based on a specific vendors.

From investigating so far, in the standard user interface:

  • Vendor card links to invoices, but not purchase orders 
    • You can link to "History-Purchases" but this only lists invoices under "vendor ledger entries"
  • Purchase Orders can be filtered to get a list of open POs against a specific vendor
    • You can link to approvals associated with this purchase order from the header page
  • Purchase Order Archives do the same as above, but stores POs that have been invoiced and closed

So there are 3 places / views to click through to get the info above. I can not find a standard report that offers this level of detail. 

Are there any suggestions here, or do I need to create a custom report here?

Thank you

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: View of vendor transactions and history

    It is not a very hard report to create, but it will require customization to create it.

    Also remember that purchase order archives can store many versions of the same purchase order, so if you want to list all the different versions it can be a lot of date.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,698 Super User 2024 Season 2 on at
    RE: View of vendor transactions and history

    Hi, As far as I know, there is no standard report, and it can be customized if needed.

    In addition, if you only want to see the Purchase Order Line, it is recommended to filter the vendor on the following page faster.

    pastedimage1680479208536v1.png

    For Purchase Order Archives, because there are different versions, it may be difficult to only look at the lines.

    Hopefully other experts can give you better advice.

    Thanks

    ZHU

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans