BeyondERP.Newsletter
Menu

Inquiry page · Retail and Commerce

Customer item statistics

An inquiry page that shows the items a customer has ordered in the past.

Used by
Retail service, Customer service manager, Customer service representative and 3 more roles
Business process
Analyze sales performance
Menu item
MCRSalesStatsCust
Main table
MCRSalesStatsCustTable
Show what matters for
PAGE GUIDEWhat the page does and how to use it6 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn inquiry page that shows the items a customer has ordered in the past.
What you do hereUse this page, typically from the call center Customer service page, to see which items a customer has previously ordered.
ExampleFor example, a call center agent can check what a caller ordered before to suggest a reorder.
Customer 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 sales performance
Menu pathRetail and Commerce › Inquiries and reports › Customer item statistics
Related pagesCustomer service 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.

How to use it

  1. Go to Retail and Commerce > Inquiries and reports > Customer item statistics.
  2. Use the Filter box to find a customer.
  3. Under General, review the Start date, End date, RFM score, order statistics (first and last order date, order frequency) and invoiced and returned amounts.
  4. Expand Lines for the item statistics, and select Recalculate to refresh them.

Source: Checked in Dynamics 365

Technical architect

4Technical

Menu itemMCRSalesStatsCust Checked in Dynamics 365
FormMCRSalesStatsCustTable Checked in Dynamics 365
TableMCRSalesStatsCustTableShown as “SALES STATISTICS” in Record infoKey field: CustAccountChecked in Dynamics 365
Who can open itPrivilegesMaintain customer item statistics MCRSalesStatsCustMaintainDutiesMaintain sales order MCRSalesMaintainMaintain sales order MCRSalesOrderMaintain
7 security roles MCRTestUserRoleRetail service RetailServiceCustomer service manager TradeCustomerServiceManagerCustomer service representative TradeCustomerServiceRepresentativeSales clerk TradeSalesClerkSales manager TradeSalesManagerSales representative TradeSalesRepresentative
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceSales manager TradeSalesManagerSales clerk TradeSalesClerkSales representative TradeSalesRepresentativeCustomer service representative TradeCustomerServiceRepresentativeGive people one of these roles. On this system, 6 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): RecalculateChecked in Dynamics 365
Developer

5Developer

Open it by URLhttps://<your-environment>/?mi=MCRSalesStatsCust
Table definitionMCRSalesStatsCustTable columns and relations Microsoft data model
Everyone

6Sources