BeyondERP.Newsletter
Menu

Job page · Sales and marketing

Calculate sales order totals for Sales

A periodic job that calculates new line and header totals for sales orders and syncs them to Dynamics 365 Sales, without recalculating prices or discounts.

Business process
Manage sales orders
Menu item
action:SalesOrderTotalsCalculate
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 periodic job that calculates new line and header totals for sales orders and syncs them to Dynamics 365 Sales, without recalculating prices or discounts.
What you do hereUse this periodic task to push up-to-date sales order totals to Dynamics 365 Sales as a one-time calculation.
ExampleFor example, after BEAT corrects delivery charges on 40 sales orders in Supply Chain Management, it runs the job with Ignore documents updated before = 1 and a filter on customer BEAT-000123, so the new totals reach Dynamics 365 Sales without a full price recalculation.
Calculate sales order totals for Sales 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 itWhen sales orders were updated in Supply Chain Management and their totals must be pushed to Dynamics 365 Sales once, without a full price recalculation.
How oftenOn demand only. The job can't be set to recur; for regular syncing, schedule Calculate sales totals.
Batch settingsWhether it runs synchronously or in the background depends on Calculate and push prices and totals in batch in Accounts receivable parameters; Microsoft recommends Yes.
What the output showsNew line and header totals for the selected sales orders, synced to Dynamics 365 Sales. Prices and discounts stay as they are; if the totals in Sales still differ, the order probably needs a full Push price and totals.

Source: Microsoft Learn

Setup steps on this page

Push sales order totals to Dynamics 365 Sales

Send updated sales order totals to Sales once, without recalculating prices or discounts.

Steps from Microsoft

  1. Go to Sales and marketing > Periodic tasks > Calculate sales order totals for Sales.
  2. In Ignore documents updated before, enter the age in days of the oldest sales order to process.
  3. On the Records to include FastTab, select Filter to choose the sales orders to push.
  4. Keep in mind that this job doesn't recalculate unit prices or discounts; use Push price and totals on the sales order when prices must be recalculated.
  5. Run it, then open the orders in Dynamics 365 Sales and check that the line and header totals match Supply Chain Management.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Ignore documents updated beforeThe age, in days, of the oldest document to include.Microsoft Learn
Records to includeA filter that controls which documents are processed.Microsoft Learn

Common errors and fixes

MessageWhat to do
The job can't be set to recur.It is meant for one-time calculations; schedule Calculate sales totals for regular syncing. Microsoft Learn

Test checklist

  1. Change a charge on one sales order in Supply Chain Management.
  2. Run the job with Ignore documents updated before = 1 and a filter on that order.
  3. Check that the order's Total amount in Dynamics 365 Sales equals the total in Supply Chain Management.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Push sales order totals to Dynamics 365 SalesUse it for one-time pushes with a short look-back and a filter; set Calculate and push prices and totals in batch to Yes so it runs through the message processor.It calculates only line and header totals and can't recur; Microsoft recommends asynchronous processing so users don't wait.Run the push synchronously or in batch?Expecting it to correct prices: it doesn't recalculate unit prices or discounts; use Push price and totals for that.Test: Totals reach Sales

Feature management and licence

Feature to turn onIntegrate Sales Quotation lifecycle with Dynamics 365 SalesCalculate and push prices, discounts and totals for selective sales orders and sales quotations when integrated to Dynamics 365 Sales
Licence or add-inOn the live system, Sales manager runs this job. It needs Calculate and push prices on the Dynamics 365 Sales integration tab of Accounts receivable parameters, which requires the features Integrate Sales Quotation lifecycle with Dynamics 365 Sales and Calculate and push prices, discounts and totals for selective sales orders and sales quotations when integrated to Dynamics 365 Sales.

Microsoft Learn

Solution architect

5Design impact

Shared or per companySales orders updated within the number of days you enter and selected by the Records to include filter. Microsoft Learn
Can it be undoneNot needed: Totals are recalculated from the current order lines; run it again after you correct lines. Microsoft Learn
If you change it laterUpdates sales order totals in Supply Chain Management and syncs them to Dynamics 365 Sales. Microsoft Learn
Technical architect

6Technical

Menu itemaction:SalesOrderTotalsCalculate Checked in Dynamics 365
FormSysOperationTemplateForm 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:SalesOrderTotalsCalculate
Data migrationLoad order: Calculate sales order totals for Sales has no data entity in Data management. It calculates and syncs totals; there is nothing to migrate.Checked in Dynamics 365
Everyone

8Sources