BeyondERP.Newsletter
Menu

Job page · Sales and marketing

Calculate sales quotation totals for Sales

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

Business process
Estimate and quote sales
Menu item
action:SalesQuotationTotalsCalculate
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 quotations 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 quotation totals to Dynamics 365 Sales as a one-time calculation.
ExampleFor example, BEAT updates the freight on 15 open quotations for customer BEAT-000123 and runs the job with Ignore documents updated before = 1 and a filter on that customer, so Dynamics 365 Sales shows the new totals while unit prices stay as quoted.
Calculate sales quotation 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 quotations were updated in Supply Chain Management and their totals must be sent to Dynamics 365 Sales once, without recalculating prices or discounts.
How oftenOn demand only; the quotation version can't recur either, so routine syncing is left to Calculate sales totals.
Batch settingsRuns synchronously or asynchronously according to Calculate and push prices and totals in batch in Accounts receivable parameters.
What the output showsNew line and header totals for the selected sales quotations, synced to Dynamics 365 Sales. A quotation whose totals still differ usually needs its prices recalculated with Push price and totals.

Source: Microsoft Learn

Setup steps on this page

Push sales quotation totals to Dynamics 365 Sales

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

Steps from Microsoft

  1. Go to Sales and marketing > Periodic tasks > Calculate sales quotation totals for Sales.
  2. In Ignore documents updated before, enter the age in days of the oldest sales quotation to process.
  3. On the Records to include FastTab, select Filter to choose the quotations to push.
  4. Use it for quotations whose prices are already right; it calculates totals only, so use Push price and totals on the quotation when prices or discounts must be recalculated.
  5. Run it, then open the quotations in Dynamics 365 Sales and compare their Total amount with the quotation in 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
Totals in Sales still differ after the job ran.The job doesn't recalculate unit prices or discounts; use Push price and totals on the quotation for a full recalculation. Microsoft Learn

Test checklist

  1. Change the freight on one quotation in Supply Chain Management.
  2. Run the job with Ignore documents updated before = 1 and a filter on that quotation.
  3. Check that the quotation'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 quotation totals to Dynamics 365 SalesUse it for quotations whose prices are already right, with a short look-back and a filter; use Push price and totals when prices or discounts must be recalculated.It calculates only new line and header totals and syncs them, and it can't be set to recur.Totals only, or full price recalculation?Running it to fix a wrong price: the unit prices and discounts are not recalculated.Test: Quotation 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 quotations 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 quotation lines; run it again after correcting them. Microsoft Learn
If you change it laterUpdates sales quotation totals in Supply Chain Management and syncs them to Dynamics 365 Sales. Microsoft Learn
Technical architect

6Technical

Menu itemaction:SalesQuotationTotalsCalculate 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:SalesQuotationTotalsCalculate
Data migrationLoad order: Calculate sales quotation 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