BeyondERP.Newsletter
Menu

Job page · Sales and marketing

Update sales target

A page where you set sales targets for members of a sales unit, by year, quarter and month.

Used by
Information technology manager, Sales manager
Business process
Define sales strategy and policies
Menu item
smmSalesTarget
Main table
smmSalesUnitMembers
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA page where you set sales targets for members of a sales unit, by year, quarter and month.
What you do hereUse it to give each member of a sales unit a yearly sales target and adjust how it is spread over quarters and months.
ExampleFor example, BEAT gives sales unit member BEAT-000123 a 2027 target of 1,200,000.00 in the company currency; the page spreads it into 300,000.00 per quarter and 100,000.00 per month, and the sales manager raises December to 160,000.00 for the holiday peak.
Update sales target 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 processDefine sales strategy and policies
Menu pathSales and marketing › Periodic tasks › Update sales target
Set up firstSales unit/team Microsoft Learn
Used next bySales targets report Microsoft Learn
Related pagesSales unit/team 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.

When to run it

When to run itWhen you set or revise the yearly sales targets for the members of a sales unit, for example at the start of a fiscal year.
How oftenOnce a year, plus whenever targets are revised during the year.
What the output showsSales target lines per sales unit member, split into quarterly (amount / 4) and monthly (amount / 12) targets.

Source: Microsoft Learn

Setup steps on this page

Set yearly sales targets per sales unit member

Give each sales unit member a yearly target and decide how it is spread over the year.

Steps from Microsoft

  1. Go to Sales and marketing > Periodic tasks > Update sales target.
  2. In the left pane, expand the sales unit and select the members who need targets.
  3. On the Overview tab, select New and enter the date of the sales target and the yearly amount in the company currency.
  4. Change the quarterly or monthly amounts where the target isn't spread evenly; the yearly total is recalculated.
  5. Run the Sales targets report for the sales unit and check that each member's yearly target matches the amount you entered.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
DateThe date of the sales target line.Microsoft Learn 1/1/2027
AmountThe yearly target amount in the company currency; quarterly targets are the amount divided by 4 and monthly targets the amount divided by 12, and you can change them.Microsoft Learn 1,200,000.00
Start dateShown above the target lines for the selected sales unit member.Checked in Dynamics 365
End dateShown above the target lines for the selected sales unit member.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
The target amounts don't match the figures sales managers expect.Target amounts are entered in the company currency for the fiscal year; check the currency and the date of the target line. Microsoft Learn

Test checklist

  1. Select one sales unit member and enter a target line of 1,200,000.00.
  2. Check that the quarterly amounts show 300,000.00 and the monthly amounts 100,000.00.
  3. Change one month and check the yearly total changes by the same amount.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set yearly sales targets per sales unit memberEnter one yearly amount per member in the company currency and only change the quarterly or monthly amounts where the business has seasonal targets.The page divides the yearly amount by 4 for quarters and by 12 for months; changing a period recalculates the yearly total.Should targets be spread evenly or by season?Changing a month without noticing that the yearly total changes with it.Test: Yearly target spreads into quarters and months

Feature management and licence

Licence or add-inOn the live system, Sales manager and Information technology manager use this page. No feature in Feature management is needed.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: target lines are kept per sales unit member in each legal entity. Microsoft data model
Can it be undoneReversible: You can change or delete target lines at any time; nothing is posted. Microsoft Learn
If you change it laterCreates or changes target lines for the selected sales unit members; the Sales targets report then shows the new amounts. Nothing is posted. Microsoft Learn
Technical architect

6Technical

Menu itemsmmSalesTarget Checked in Dynamics 365
FormsmmSalesTarget Checked in Dynamics 365
TablesmmSalesUnitMembersShown as “Sales unit members” in Record infoKey field: SalesUnitId, IdentificationChecked in Dynamics 365
Who can open itPrivilegesMaintain sales targets smmSalesTargetMaintainView sales targets smmSalesTargetViewDutiesEnable the Sales and marketing process smmCRMProcessEnableInquire into Sales and marketing reference data smmCRMReferenceDataInquire
2 security rolesInformation technology manager SysServerITManagerSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerInformation technology manager SysServerITManagerGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=smmSalesTarget
Data migrationLoad order: Update sales target has no data entity in Data management. Enter the yearly targets by hand for each sales unit member after the sales units are set up.Checked in Dynamics 365
Table definitionsmmSalesUnitMembers columns and relations Microsoft data model
Everyone

8Sources