BeyondERP.Newsletter
Menu

Report page · Procurement and sourcing

Vendor/Item statistics

A report that summarizes the products your organization bought from each vendor during a date range you choose.

Business process
Analyze procurement and sourcing
Menu item
output:PurchStatistics_VendItem
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 summarizes the products your organization bought from each vendor during a date range you choose.
What you do hereUse this report to review purchases by vendor and item, and to compare one period with a second period.
Vendor/Item statistics 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 › Vendor/Item statistics
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 prepare vendor reviews, contract negotiations or spend analysis by vendor.
How oftenOn demand, typically for periodic vendor reviews or before negotiations.
What the output showsPurchase statistics grouped by vendor, with the items bought from each vendor, for period 1 and period 2 side by side. A vendor with no figures in a period usually means no invoiced purchases fell inside those dates.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Procurement and sourcing > Inquiries and reports > Vendor statistics > Vendor/Item statistics.
  2. Under PERIOD 1, enter the From date and To date of the period you want to analyze, for example the current year to date.
  3. Under PERIOD 2, enter the From date and To date of the period to compare with, for example the same months last year.
  4. Filter on Vendor account in Records to include to see what you bought from one or more vendors; add an Item filter only when you want to narrow each vendor to certain items.
  5. Run the report and compare each vendor's purchases between the two periods. Here the vendor is the main grouping and items are listed under it.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
From dateThe start date of the first date range to report on.Microsoft Learn
To dateThe end date of the first date range.Microsoft Learn
ItemThe items whose transactions are included on the report.Microsoft Learn
Vendor accountThe vendor accounts whose transactions are included on the report.Microsoft Learn
Solution architect

4Design impact

Can it be undoneNothing to undo: The report only reads purchase history; it changes nothing. Microsoft Learn
Technical architect

5Technical

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

6Developer

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

7Sources