BeyondERP.Newsletter
Menu

Report page · Procurement and sourcing

Purchase requisition statistics

A report that lists purchase requisitions with their header and line details and the total amount of each.

Business process
Analyze procurement and sourcing
Menu item
output:PurchReqStatistics
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 purchase requisitions with their header and line details and the total amount of each.
What you do hereUse this report to review purchase requisitions for a date range and status, grouped and with or without line details.
Purchase requisition 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 › Purchase requisition statistics › Purchase requisition 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 requisition volume and spend by status, for example to see what is still in review or approved but not yet ordered.
How oftenOn demand, for example at month end or during procurement reviews.
What the output showsPurchase requisitions with header details and the total amount of each, grouped as you chose, with line details when Details is Yes. A requisition you expected but don't see is usually still a draft or was submitted outside the date range.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Procurement and sourcing > Inquiries and reports > Purchase requisition statistics > Purchase requisition statistics.
  2. Under Print, set All to Yes for every requisition, or No and choose a narrower option such as Requested for me.
  3. Under Date intervals, enter the From date and To date. These limit the requisitions by submission date.
  4. Choose the Status and the Grouping. Requisitions in Draft status never appear, even if you choose Draft, because they haven't been submitted.
  5. Set Details to Yes to add line details such as item number, item name and quantity, then run the report and review the total amount per requisition.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
AllSelect it to include all purchase requisitions in the report.Microsoft Learn
From dateThe earliest submission date of the requisitions to include.Microsoft Learn
To dateThe latest submission date of the requisitions to include.Microsoft Learn
StatusThe requisition status to include.Microsoft Learn
GroupingHow the report groups the information.Microsoft Learn
DetailsSelect it to show line details such as item number, item name and quantity.Microsoft Learn
Solution architect

4Design impact

Can it be undoneNothing to undo: The report only reads requisitions; nothing is changed. Microsoft Learn
If you change it laterRequisitions in Draft status never appear on the report, even if you choose Draft in the status filter. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:PurchReqStatistics Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itPurchasing manager TradePurchasingManagerPurchasing agent VendPurchasingAgentPurchasing Agent - Public Sector VendPurchasingAgent_PSNGive 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:PurchReqStatistics
Everyone

7Sources