BeyondERP.Newsletter
Menu

Setup step on the Prospect turnover page · Sales and marketing

Compare actual and expected sales

Find customers whose sales differ most from what was expected.

Business process
Analyze sales
Menu item
output:smmProspectsTurnover
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that compares each customer's total sales with the sales expected from that customer.
What you do hereUse it in account planning to find customers who buy less or more than expected, by customer, customer group, sales group or postal code.
ExampleFor example, BEAT reviews sales group RETAIL for 2026: customer BEAT-000123 bought 82,500.00 against 120,000.00 expected, the largest gap in the group, so the account manager plans a visit.
Prospect turnover 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
Menu pathSales and marketing › Inquiries and reports › Sales and marketing reports › Prospect turnover
Set up firstAll customers Microsoft Learn
Used next byAll opportunities Microsoft Learn
Related pagesCustomer turnover report Microsoft Learn
In this process Review sales targets
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 itIn account planning, when you compare actual sales with what customers were expected to buy.
How oftenOn demand, for example quarterly.
What the output showsPer customer, total sales against expected sales.

Source: Microsoft Learn

Setup steps on this page

Compare actual and expected sales

Find customers whose sales differ most from what was expected.

Steps from Microsoft

  1. Go to Sales and marketing > Inquiries and reports > Sales and marketing reports > Prospect turnover.
  2. Filter on Sales group or Customer group for a segment review, or on ZIP/postal code for a territory.
  3. Read total sales against expected sales per customer and mark the customers with the largest gap.
  4. Open those customers and plan the follow-up activity or adjust the expected sales for next year.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Customer accountThe account number of the customer.Microsoft Learn BEAT-000123
Customer groupThe customer group the customer is in.Microsoft Learn
Sales groupThe sales group assigned to the customer.Microsoft Learn RETAIL
ZIP/postal codeThe postal code of the customer's location.Microsoft Learn

Common errors and fixes

MessageWhat to do
A customer of the segment is missing.The filters on Customer group, Sales group and ZIP/postal code work together; check that the customer has the group and postal code you filtered on. Microsoft Learn

Test checklist

  1. Pick one customer with posted sales.
  2. Run the report filtered on its Customer account.
  3. Check that the total sales match the customer's invoiced sales for the period you expect.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Compare actual and expected salesFilter on one Sales group or Customer group first.Expected sales are set per customer; a segment keeps the comparison to customers handled the same way.Which segment should account planning use?Reading a large gap as lost business when the expected sales were never updated for the year.Test: Turnover for one customer

Feature management and licence

Licence or add-inOn the live system, Sales manager, Collections manager, Customer service manager and Chief executive officer use this page; 4 roles can run it in total. No Feature management feature is needed to open it.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: the report reads the data of the legal entity you run it in. To compare legal entities, run it in each one. Checked in Dynamics 365
Can it be undoneReversible: Running the inquiry or report changes no data.
If you change it laterThe report reads customers and sales at run time. Customer and prospect data can come from Dynamics 365 Sales when prospect to cash is used. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:smmProspectsTurnover Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itSales manager TradeSalesManagerCollections manager CollectionLetterCollectionsManagerCustomer service manager TradeCustomerServiceManagerChief executive officer CompanyChiefExecutiveOfficerGive people one of these roles. On this system, 4 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:smmProspectsTurnover
Data migrationLoad order: Prospect turnover has no data entity in Data management. It is a report: it reads customers and their sales and stores nothing of its own.Checked in Dynamics 365
Everyone

8Sources

To cite this step: SM-INQ-100, Compare actual and expected sales. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SM-INQ-100