BeyondERP.Newsletter
Menu

Job page · Sales and marketing

Cumulate rebates

A periodic job that recalculates a customer's rebate claims in To be calculated status on the total sales of the rebate period, adds an adjustment claim for the difference and sets the claims to Calculated. Unlike the claims created per invoice line, the result reflects the whole period's volume. 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:pdsRebateCumulate
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 recalculates a customer's rebate claims in To be calculated status on the total sales of the rebate period, adds an adjustment claim for the difference and sets the claims to Calculated. Unlike the claims created per invoice line, the result reflects the whole period's volume. 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 periodic task to bring claims that are waiting for recalculation up to date, so they can be approved.
ExampleFor example, BEAT-000123 buys 40 and then 60 units in one week under a 2.00 / 4.00 per-unit agreement. Cumulate rebates for that week moves the customer to 4.00 for all 100 units and adds an adjustment claim of 80.00.
Cumulate 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 › Cumulate rebates
Set up firstRebates Microsoft Learn
Used next byProcess rebates Microsoft Learn
Related pagesCalculate 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 invoicing, when claims from periodic rebate agreements are in To be calculated status and must reflect the period's total sales volume.
How oftenAt the end of each cumulation period of the agreements (week, month, year or customized period).
What the output showsClaims in Calculated status, with an adjustment claim when the period's volume reaches a higher threshold. For amount-based agreements with item rebate groups, the threshold is checked per item.

Source: Microsoft Learn

Setup steps on this page

Cumulate periodic rebate claims before approval

Use this job to bring claims that wait for recalculation up to date so they can be approved.

Steps from Microsoft

  1. Go to Sales and marketing > Customer rebates > Rebate update > Cumulate rebates.
  2. Select the customer whose claims are in the To be calculated status.
  3. Enter the start date and end date of the rebate period that the agreement cumulates sales by, for example the week or month.
  4. Select OK. The claims are recalculated on the customer's total sales in the period, and a difference is recorded as a new adjustment claim.
  5. Open Rebates and make sure the claims now have status Calculated before you approve them.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
CustomerThe customer whose claims are recalculated.Microsoft Learn BEAT-000123
Start dateThe start of the rebate period to cumulate.Microsoft Learn 2026-11-02
End dateThe end of the rebate period to cumulate.Microsoft Learn 2026-11-08

Common errors and fixes

MessageWhat to do
Cumulation doesn't combine the amounts of items in an item rebate group.By design, amount thresholds are checked per item; group only items with the same threshold. Microsoft Learn

Test checklist

  1. Invoice 40 and 60 units in one week under a weekly agreement with breaks at 50.
  2. Run Cumulate rebates for the customer and the week.
  3. Open Rebates for the customer.
  4. Check that the claims are Calculated and an adjustment claim equals the extra rate times the first 40 units.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Cumulate periodic rebate claims before approvalRun it per customer for exactly the period the agreement cumulates sales by (for example the week), after all invoices of that period are posted, and before Approve.Claims are first created per invoice line at that line's rate; Cumulate recalculates them on the period's total volume and records the difference as an adjustment claim.Choosing dates that don't match the agreement's cumulation period, or approving claims still in To be calculated, so the customer is paid at the lower rate.Test: Cumulate adds the adjustment claim

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: Recalculated and adjustment claims aren't posted until they are approved and processed. Microsoft Learn
If you change it laterRecalculates claims for the period and adds adjustment claims; nothing is posted. Microsoft Learn
Technical architect

6Technical

Menu itemaction:pdsRebateCumulate 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:pdsRebateCumulate
Data migrationLoad order: Cumulate rebates has no data entity in Data management: it is a periodic job and stores no data of its own. The claims it recalculates are covered by the Customer rebates entity (SalesRebateEntity) of the Rebates page.Checked in Dynamics 365
Everyone

8Sources