BeyondERP.Newsletter
Menu

Job page · Sales and marketing

Purge rebates

A periodic job that permanently deletes the rebate records created before a date you enter: you enter the earliest date of the rebates to keep. 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:pdsRebatePurge
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 permanently deletes the rebate records created before a date you enter: you enter the earliest date of the rebates to keep. 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 remove outdated rebate information once it is no longer needed.
ExampleFor example, BEAT keeps two years of rebate history: when it purges at the start of a year, it enters the same date two years earlier, and every rebate created before that date is deleted.
Purge 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 › Purge rebates
Set up firstProcess rebates Microsoft Learn
Used next byRebates Microsoft Learn
Related pagesPurge rebates (vendor 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 itOnly when old rebate records are no longer needed, after their claims are processed and settled.
How oftenOn demand, for example once a year.
What the output showsRebate records created before the date you entered are deleted.

Source: Microsoft Learn

Setup steps on this page

Purge old customer rebates

Use this job to delete outdated rebate records before a cut-off date.

Steps from Microsoft

  1. Go to Sales and marketing > Customer rebates > Rebate update > Purge rebates.
  2. Agree the cut-off date with the accounts receivable manager: all rebates before it must be processed and settled.
  3. Run the purge with that date in a copy of the company data first and check the result on the Rebates page.
  4. Enter the earliest date of the rebates you want to keep; rebates created before that date are deleted.
  5. Select OK, then open Rebates and make sure the newest claims you kept are still there.

Source: Microsoft Learn

Common errors and fixes

MessageWhat to do
Claims that were still needed are gone after the purge.The date is the earliest date to keep, not the last date to delete: rebates created before it are deleted and can't be brought back from the page. Check the date in a copy of the company data before the real run. Microsoft Learn

Test checklist

  1. In a copy of the company data, count the rebates on the Rebates page created before the cut-off date.
  2. Run Purge rebates with the cut-off date.
  3. Check that no rebate created before the date is left.
  4. Check that the number of rebates on or after the date is unchanged.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Purge old customer rebatesRun it only on request of the accounts receivable manager, with a cut-off date before which all rebates are processed and settled, after a trial run in a copy of the company data.The job deletes every rebate created before the date entered, and deleted records can't be brought back from the application.Entering the last date to delete instead of the earliest date to keep, or purging rebates whose claims are still open.Test: Purge keeps the rebates from the cut-off date

Feature management and licence

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

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 undoneIrreversible: Purged rebate records can't be restored. Run it only after the claims are processed and settled, test the date in a copy first, and keep the job with the accounts receivable manager. Microsoft Learn
If you change it laterDeletes the rebate records created before the date you enter; they no longer show on the Rebates page. Microsoft Learn
Technical architect

6Technical

Menu itemaction:pdsRebatePurge 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:pdsRebatePurge
Data migrationLoad order: Purge rebates has no data entity in Data management: it is a periodic job and stores no data of its own. Before a purge, export the rebates to keep as history with the Customer rebates entity (SalesRebateEntity) of the Rebates page.Checked in Dynamics 365
Everyone

8Sources