BeyondERP.Newsletter
Menu

Setup step on the Calculate sales totals page · Sales and marketing

Schedule Calculate sales totals

Keep order and quotation totals and workspace KPIs accurate.

Business process
Manage sales orders
Menu item
action:SalesTotalsCalculate
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 periodic job that recalculates and updates the summary totals for sales orders and sales quotations.
What you do hereUse this periodic task to keep the order and quotation totals, delivery figures and KPIs shown on inquiry pages, workspaces and analytics accurate.
ExampleFor example, after BEAT imports 3,500 sales orders with Data management, it runs the job once with Ignore documents updated before (days) = 2, and schedules it nightly at 01:00 with a 14-day look-back and Number of threads = 0.
Calculate sales totals 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

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 itAfter bulk data imports or mass updates to sales orders or quotations, as part of month-end closing, and on a nightly schedule.
How oftenNightly, plus extra runs after bulk imports or mass updates.
Batch settingsSchedule it as a recurring nightly batch job outside peak hours with a 7 to 30 day look-back; avoid full historical recalculations in high-volume environments.
What the output showsUpdated order and quotation totals, delivery figures and KPI totals on inquiry pages, workspaces and analytics. If totals still look wrong, check for customizations that bypass update triggers.

Source: Microsoft Learn

Setup steps on this page

Schedule Calculate sales totals

Keep order and quotation totals and workspace KPIs accurate.

Steps from Microsoft

  1. Go to Sales and marketing > Periodic tasks > Calculate sales totals.
  2. In Ignore documents updated before (days), enter how far back to look; Microsoft recommends 7 to 30 days for routine runs.
  3. Set Calculate totals for sales orders and Calculate totals for sales quotations to Yes for the document types you use; set quotations to No if you don't use sales quotations.
  4. In Number of threads, enter the maximum parallel threads, or 0 to let the system decide; raise it if the job takes too long.
  5. On the Run in the background FastTab, select Recurrence to set a nightly schedule.
  6. Afterwards, open a few recently changed orders and quotations and check that the totals on inquiry pages and workspaces match their lines.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Ignore documents updated before (days)Only documents updated after Today minus this number of days are recalculated; Microsoft recommends 7 to 30 days for routine runs.Microsoft Learn 14
Calculate totals for sales ordersYes recalculates order totals, delivery totals, remaining quantities and values, and KPI totals.Microsoft Learn Yes
Calculate totals for sales quotationsYes recalculates quotation totals; set No if you don't use sales quotations.Microsoft Learn Yes
Number of threadsThe most parallel threads the job can use; zero lets the system decide.Microsoft Learn 0

Common errors and fixes

MessageWhat to do
Totals still look wrong after the job ran.Check whether customizations bypass the update triggers, and check that the documents were updated within the look-back period. Microsoft Learn

Test checklist

  1. Totals on a recently changed sales order match its lines.
  2. Workspace KPI totals reflect the latest orders and quotations.
  3. The batch job finished within the night window.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Schedule Calculate sales totalsRecurring nightly batch job outside peak hours with a 7 to 30 day look-back, both document types Yes (quotations No if not used) and Number of threads 0; run it once more after bulk imports.Only documents updated within the look-back are recalculated, which balances freshness with performance; full historical runs are discouraged in high-volume environments.How far back should the nightly run look?A look-back shorter than the gap between runs, so documents changed in between are never recalculated.Test: Totals updated after import

Feature management and licence

Licence or add-inOn the live system, Sales manager runs this job. With the Dynamics 365 Sales integration, Microsoft recommends scheduling it so totals, taxes and freight charges are pushed to Sales regularly.

Microsoft Learn

Solution architect

5Design impact

Shared or per companySales orders and quotations last updated within the look-back period, for the document types set to Yes. Microsoft Learn
Can it be undoneReversible: The job only recalculates stored totals; running it again recalculates them.
If you change it laterRecalculates stored totals and KPI values for sales orders and quotations used by inquiries, workspaces and analytics. Microsoft Learn
Technical architect

6Technical

Menu itemaction:SalesTotalsCalculate Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Roles to set it up and use itTo use itSales manager TradeSalesManagerGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=action:SalesTotalsCalculate
Data migrationLoad order: Calculate sales totals has no data entity in Data management. It recalculates stored totals; run it in the target system after you load orders and quotations.Checked in Dynamics 365
Everyone

8Sources

To cite this step: SM-JOB-130, Schedule Calculate sales totals. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SM-JOB-130