BeyondERP.Newsletter
Menu

Report page · Procurement and sourcing

Item/Vendor statistics

A report that shows purchase statistics by item and vendor for two periods.

Business process
Analyze procurement and sourcing
Menu item
output:PurchStatistics_ItemVend
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 shows purchase statistics by item and vendor for two periods.
What you do hereUse this report to compare purchasing by item and vendor across two periods. You enter a From date and To date for Period 1 and for Period 2.
Item/Vendor 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 › Item/Vendor 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 review sourcing per product, for example before you renegotiate prices for an item or decide to add a second vendor.
How oftenOn demand, when buyers review how each item is sourced.
What the output showsPurchase statistics grouped by item, with each vendor that supplied the item, for both periods. Unlike Vendor/Item statistics, the item is the main grouping. An item with an unexpected vendor often points to a purchase order placed outside the agreed source.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Procurement and sourcing > Inquiries and reports > Vendor statistics > Item/Vendor statistics.
  2. Under PERIOD 1, enter the From date and To date of the period you want to look at.
  3. Under PERIOD 2, enter the From date and To date of the comparison period, so you can see how purchasing of each item has moved.
  4. Filter on Item in Records to include when you only want certain products; this report groups by item first and then lists the vendors that supplied each item.
  5. Run the report and look for items whose volume shifted from one vendor to another between the two periods.

Source: Microsoft Learn

Solution architect

4Design impact

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

5Technical

Menu itemoutput:PurchStatistics_ItemVend 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_ItemVend
Everyone

7Sources