BeyondERP.Newsletter
Menu

Job page · Sales and marketing

Calculate rebates

A periodic job that runs the customer rebate calculation for a start date and an end date, now or in the background. Customer rebates are created when sales order lines are invoiced; claims of weekly, monthly or yearly agreements are then completed by Cumulate rebates. These are the older customer rebates of Sales and marketing. Microsoft describes Rebate management as the newer module for rebate deals, provisions and royalties; choose one of the two for a project.

Business process
Process customer rebates
Menu item
action:PdsRebateBatchCalcDialog
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 runs the customer rebate calculation for a start date and an end date, now or in the background. Customer rebates are created when sales order lines are invoiced; claims of weekly, monthly or yearly agreements are then completed by Cumulate rebates. These are the older customer rebates of Sales and marketing. Microsoft describes Rebate management as the newer module for rebate deals, provisions and royalties; choose one of the two for a project.
What you do hereUse this job to run the rebate calculation for a closed period before the claims are reviewed, cumulated and approved on the Rebates page.
ExampleFor example, on 1 December BEAT runs Calculate rebates in the background with Start date 1 November 2026 and End date 30 November 2026, then reviews November's claims for BEAT-000123 on the Rebates page.
Calculate rebates 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 processManage accounts receivable › Process customer rebates
Menu pathSales and marketing › Customer rebates › Rebate update › Calculate rebates
Set up firstRebate agreements Microsoft Learn
Used next byRebates Microsoft Learn
Related pagesCumulate rebates Microsoft Learn Customer rebate deals (Rebate management) 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 itAfter the sales invoices of the period are posted and before the claims are cumulated and approved.
How oftenAt the end of each rebate period, for example monthly.
Batch settingsRun it in the background when the period covers many invoices.
What the output showsRebate claims on the Rebates page with their status (To be calculated, Calculated, Approved, Mark, Processed).

Source: Microsoft Learn

Setup steps on this page

Run Calculate rebates for a closed period

Use this job to run the rebate calculation for a period before claims are approved.

Steps from Microsoft

  1. Go to Sales and marketing > Customer rebates > Rebate update > Calculate rebates.
  2. Make sure the period's sales orders are invoiced and the rebate agreements are approved.
  3. Enter the Start date and End date of the closed period.
  4. Run it in the background for a long period, then open Rebates and review the claims and their status before you cumulate and approve them.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Start dateThe first date of the period the calculation covers.Checked in Dynamics 3652026-11-01
End dateThe last date of the period the calculation covers.Checked in Dynamics 3652026-11-30

Common errors and fixes

MessageWhat to do
No claim appears for a customer with qualifying sales.Check that the rebate agreement's Workflow approval status is Approved and that the sales orders are invoiced; rebates are created when sales order lines are invoiced. Microsoft Learn

Test checklist

  1. Invoice a qualifying sales order in the period.
  2. Run Calculate rebates for the period's start and end dates.
  3. Open Rebates and filter on the customer.
  4. Check that the claim is listed with its status and amount.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run Calculate rebates for a closed periodRun it for a closed period, from the first to the last day, after all invoices of the period are posted, and in the background for long periods.Rebates are created from invoiced sales order lines, so a period with open orders gives incomplete claims; nothing is posted until claims are approved and processed.Treating the run as the end of the process: claims of weekly, monthly or yearly agreements still need Cumulate, Approve and Process before anything is posted.Test: Calculate rebates lists the period's claims

Feature management and licence

Licence or add-inOn the live system, Accounts receivable clerk and Accounts receivable manager use this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: the job works on the rebate claims of the legal entity it runs in; the claims table holds its records per company. Microsoft data model
Can it be undoneReversible: Claims aren't posted until they are approved and processed. Microsoft Learn
If you change it laterNothing is posted: claims are only posted when they are approved and processed, which posts the Rebate accrual journal. Microsoft Learn
Technical architect

6Technical

Menu itemaction:PdsRebateBatchCalcDialog Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Roles to set it up and use itTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerGive people one of these roles. On this system, 2 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=action:PdsRebateBatchCalcDialog
Data migrationLoad order: Calculate rebates has no data entity in Data management: it is a periodic job and stores no data of its own. The claims it works on are covered by the Customer rebates entity (SalesRebateEntity) of the Rebates page.Checked in Dynamics 365
Everyone

8Sources