BeyondERP.Newsletter
Menu

Setup step on the Rebates page · Sales and marketing

Cumulate, approve and process customer rebate claims

Use this page to recalculate claims for the period, approve them and process them so that rebate accruals are posted.

Used by
Accounts receivable clerk, Accounts receivable manager, Sales clerk and 1 more role
Business process
Process customer rebates
Menu item
PdsRebateTableListPage
Main table
PdsRebateTable
Data entity
SalesRebateEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA workbench page where you review, cumulate, approve and process customer rebate claims created from invoiced sales. 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 page to recalculate claims for the period, approve them and process them so that rebate accruals are posted.
ExampleFor example, BEAT invoices 40 and 60 units of BEAT-ITEM-0042 to BEAT-000123 in one week, creating claims of 80.00 and 240.00. Cumulate reaches the 4.00 rate for all 100 units and adds an adjustment claim of 80.00; Approve and Process then post the 400.00 accrual.
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

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.

Setup steps on this page

Cumulate, approve and process customer rebate claims

Use this page to recalculate claims for the period, approve them and process them so that rebate accruals are posted.

Steps from Microsoft

  1. Go to Sales and marketing > Customer rebates > Rebates.
  2. Review the claims; claims of periodic agreements are in To be calculated.
  3. Select Cumulate, select the customer and the start date, and select OK; an adjustment claim is added when the period's volume reaches a higher break.
  4. Mark the claims and select Approve.
  5. Select Process, select the customer and select OK.
  6. Check that the claims have status Mark, then create the credit note from the customer's Settle transactions page.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
StatusWhere the claim is in the process: To be calculated (waiting for Cumulate), Calculated, Approved, Mark (processed: the rebate accrual journal is posted) and Processed.Microsoft Learn To be calculated

Common errors and fixes

MessageWhat to do
Claims stay in To be calculated and can't be approved and processed.Run Cumulate for the customer and the period first; the claims change to Calculated and can then be approved. Microsoft Learn

Test checklist

  1. Invoice two sales orders that qualify under a periodic rebate agreement and open Customer rebates > Rebates.
  2. Check the claims are in To be calculated, then select Cumulate for the customer and check an adjustment claim is created and the status changes to Calculated.
  3. Mark the claims, select Approve, then Process for the customer.
  4. Check the status changes to Mark and the voucher credits the rebate accrual account and debits the rebate expense account.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Cumulate, approve and process customer rebate claimsAt the end of each cumulation period, run Cumulate for the customer before approving, then Approve and Process the claims of that period together.Claims of periodic agreements are first created per invoice line at the rate of that line. Cumulate recalculates them on the period's total volume and adds an adjustment claim; Process posts the Rebate accrual journal.Processing claims before Cumulate, so the customer is accrued at the lower rate; in Microsoft's example 40 and 60 units only reach the 40 USD rate for all 100 units after Cumulate.Test: Cumulate adds the adjustment claim and Process posts the accrual

Feature management and licence

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

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: Process posts the Rebate accrual journal: the accrual account is credited, the expense account debited and the claims move to the customer's temporary balance as deductions.
If you change it laterProcessing claims posts a rebate accrual journal and moves the claims to the customer's temporary balance as deductions. Microsoft Learn
Technical architect

6Technical

Menu itemPdsRebateTableListPage Checked in Dynamics 365
FormPdsRebateTableListPage Checked in Dynamics 365
TablePdsRebateTableShown as “Rebate” in Record infoChecked in Dynamics 365
Data entitiesSalesRebateEntityCustomer rebates Microsoft data model
Who can open itPrivilegesMaintain TMA rebate groups PdsRebateTableMaintainView TMA rebate groups PdsRebateTableViewDutiesViews customer rebate agreements PdsRebateAgreementViewProcesses customer rebates PdsRebateProcessMaintain customer rebates PdsRebateTableMaintainInquire into product sales prices and discount master PriceDiscProdSalesPriceDiscMasterInquir
5 security rolesAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManager MCRTestUserRoleSales clerk TradeSalesClerkSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkTo use itSales clerk TradeSalesClerkGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=PdsRebateTableListPage
Integrate withSalesRebateEntity data entity Microsoft data model
Data migrationSalesRebateEntity (Customer rebates): loaded for each company.Load order: No default configuration template places this entity. Claims are created by invoicing; load open claims only after the approved rebate agreements they belong to.Load first: Rebate agreements, CustomersMicrosoft Learn
Table definitionPdsRebateTable columns and relations Microsoft data model
Everyone

8Sources