BeyondERP.Newsletter
Menu

Inquiry page · Procurement and sourcing

Purchase and spend analysis

A Power BI analysis page that shows the Purchase spend analysis content, with purchase spending by vendor, product, period and vendor location.

Used by
Chief executive officer, Accountant, Accounting manager and 1 more role
Business process
Analyze procurement and sourcing
Menu item
PurchaseSpendAnalysisPowerBI
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 Power BI analysis page that shows the Purchase spend analysis content, with purchase spending by vendor, product, period and vendor location.
What you do hereUse this page to keep track of purchase spending and to spot changes in spending over time.
ExampleFor example, a manager can see which vendors and products have rising or falling spending.
Purchase and spend analysis 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 › Purchase performance analysis › Purchase and spend analysis
Set up firstEntity store Microsoft Learn
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.

Fields on the page

FieldWhat it means
Purchase by periodA report page that shows purchases for the current and previous years, and growth by procurement category.Microsoft Learn
Total purchaseA tile on the Purchase by vendor report page that shows total purchase spending.Microsoft Learn
Year-over-year purchase growthA tile that shows how much purchase spending changed compared with the previous year.Microsoft Learn
Solution architect

4Design impact

If you change it laterThe report shows the current calendar year by default; change the date or company filter to see other data. Microsoft Learn
Technical architect

5Technical

Menu itemPurchaseSpendAnalysisPowerBI Checked in Dynamics 365
FormPurchaseSpendAnalysisPowerBI Checked in Dynamics 365
Who can open itPrivilegesPurchase and spend analysis PurchaseSpendAnalysisPowerBIViewDutiesReview purchase order process performance PurchOrderProcessPerformanceReview
4 security rolesChief executive officer CompanyChiefExecutiveOfficerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerPurchasing manager TradePurchasingManager
Checked in Dynamics 365
Roles to set it up and use itTo use itPurchasing manager TradePurchasingManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerChief executive officer CompanyChiefExecutiveOfficerGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Share, Power BIChecked in Dynamics 365
Developer

6Developer

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

7Sources