BeyondERP.Newsletter
Menu

Report page · Procurement and sourcing

Top 100 vendors

A report that lists the top vendors, 100 by default, in the sort order you choose.

Business process
Analyze procurement and sourcing
Menu item
output:PurchRankingReport
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that lists the top vendors, 100 by default, in the sort order you choose.
What you do hereUse this report to see your leading vendors. You set the Number of records (100 by default) and the Sorting (Account by default).
Top 100 vendors page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAnalyze procurement and sourcing
Menu pathProcurement and sourcing › Inquiries and reports › Vendor statistics › Top 100 vendors
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itWhen you need a ranked view of your main vendors, for example for supplier segmentation or an annual purchasing review.
How oftenOn demand, typically for periodic purchasing reviews.
What the output showsA ranked list with up to the number of vendors you entered, in the sort order you chose. If the list looks like a plain account list, Sorting was left on Account.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Procurement and sourcing > Inquiries and reports > Vendor statistics > Top 100 vendors.
  2. In Number of records, keep 100 or enter how many vendors you want listed, for example 20 for a short management summary.
  3. In Sorting, keep Account to list vendors by account number, or choose another sort order to rank them by the figure you are interested in.
  4. Use Records to include to limit the vendors, for example to one vendor group, when you only want to rank part of your supplier base.
  5. Run the report and review the vendors at the top of the list for spend concentration.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The report only reads vendor data; nothing is changed. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:PurchRankingReport Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itPurchasing manager TradePurchasingManagerAccounting manager LedgerAccountingManagerChief executive officer CompanyChiefExecutiveOfficerGive people one of these roles. On this system, 3 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=output:PurchRankingReport
Everyone

7Sources