BeyondERP.Newsletter
Menu

Page · Sales and marketing

Rebate agreements

A page where you set up customer rebate agreements: who and what qualifies, how sales are cumulated, the rebate thresholds and amounts, and how the rebate is paid. 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.

Used by
Accounts payable manager, Auditor, Accounts receivable clerk and 2 more roles
Business process
Process customer rebates
Menu item
PdsRebateAgreements
Main table
PdsRebateAgreement
Data entity
SalesRebateAgreementHeaderV2Entity
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 page where you set up customer rebate agreements: who and what qualifies, how sales are cumulated, the rebate thresholds and amounts, and how the rebate is paid. 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 define which customers and items qualify for a rebate, how it is calculated and how it is paid.
ExampleFor example, BEAT gives customer BEAT-000123 a rebate of 2.00 per unit on item BEAT-ITEM-0042 when weekly purchases are 1 to 50 units and 4.00 per unit above 50, with Cumulate sales by Week and Price taken from Gross.
Rebate agreements 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

Set up and approve customer rebate agreements

Use this page to define which customers and items qualify for a rebate, how it is calculated and how it is paid.

Steps from Microsoft

  1. Go to Sales and marketing > Customer rebates > Rebate agreements.
  2. Select New and, in the Rebate program ID field, select the rebate program.
  3. Select the customer or customer rebate group, and the item or item rebate group.
  4. Set the unit, Payment type, Cumulate sales by, Price taken from and Rebate line break type.
  5. On the lines, enter each threshold range with its value and Amount type.
  6. Select Validation on the Action Pane so that the Workflow approval status becomes Approved before orders are invoiced.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Rebate program IDThe rebate program type the agreement uses; it sets the kind of rebate and the default accrual and expense accounts.Microsoft Learn VOLUMEPdsRebateType
Payment typeHow the customer receives the rebate, for example through accounts payable, a customer deduction, trade spending or freight.Microsoft Learn Customer deductionsPdsPaymtType
Cumulate sales byThe period over which sales are added up to calculate the rebate, for example Invoice, Week, Month, Year, a customized period or Lifetime.Microsoft Learn WeekPdsCumulateSalesBy
Price taken fromGross means the rebate is based on the line amount before the line discount; Net uses the amount after it.Microsoft Learn Gross
Rebate line break typeWhether the thresholds on the lines are sales quantities or sales amounts.Microsoft Learn QuantityPdsRebateLineBreakType
Amount typeWhether the line's value is an amount per unit, a fixed amount or a percentage.Microsoft Learn Amount per unitRebateAmtType

Common errors and fixes

MessageWhat to do
The Price details option or its Rebates section doesn't show the rebate on a sales order line.Set Enable price details to Yes on the Prices tab of Accounts receivable parameters, and approve the agreement with Validation so its Workflow approval status is Approved. Microsoft Learn

Test checklist

  1. Set Enable price details to Yes on the Prices tab of Accounts receivable parameters.
  2. Create a rebate agreement for one customer and item with Rebate line break type Quantity and two quantity breaks, then select Validation to approve it.
  3. Create a sales order for that customer and item, open Price details on the line and check the Rebates section shows the estimated rebate.
  4. Invoice the order and check a claim appears on Customer rebates > Rebates.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up and approve customer rebate agreementsDecide Cumulate sales by, Price taken from and Rebate line break type with the sales manager before approval, then approve the agreement with Validation before the first qualifying order is invoiced.Claims are created from invoiced sales lines under the approved agreement. A periodic agreement cumulates the customer's sales for the period, so these three settings decide every claim amount.Should the company use the older customer rebates of Sales and marketing or the Rebate management module?Invoicing qualifying orders while the agreement isn't approved yet, or reading the estimate on Price details as the final rebate; the final amount depends on the period's total volume, returns and invoicing.Test: An approved rebate agreement creates claims at invoicing

Feature management and licence

Licence or add-inOn the live system, Sales manager (maintain), and Accounts receivable clerk, Accounts receivable manager, Accounts payable manager and Auditor (view) 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: An agreement applies once its Workflow approval status is Approved (select Validation to approve). From then on, every invoiced qualifying sales line generates a rebate claim that flows to the Rebates workbench. Get Cumulate sales by, Price taken from and Rebate line break type right before approval, because claims are already created from posted invoices. Microsoft Learn
If you change it laterFrom approval on, each invoiced sales line that meets the agreement creates a rebate claim. Claims from weekly, monthly or yearly agreements wait in To be calculated until Cumulate is run; the Price details page of a sales order line only shows an estimate. Microsoft Learn
Technical architect

6Technical

Menu itemPdsRebateAgreements Checked in Dynamics 365
FormPdsRebateAgreement Checked in Dynamics 365
TablePdsRebateAgreementShown as “Rebate agreements” in Record infoKey field: PdsRebateType, PdsRebateProgramType, RebateAgreementIdChecked in Dynamics 365
Data entitiesSalesRebateAgreementHeaderV2EntityCustomer rebate agreement headers V2 Microsoft data model TAMTradeAllowanceAgreementMerchandisingEventBillBackEntityTrade allowance agreement merchandising event bill backs Microsoft data model
Who can open itPrivilegesMaintain rebate agreements PdsRebateAgreementsMaintainView rebate agreements PdsRebateAgreementsViewDutiesMaintains customer rebate agreements PdsRebateAgreementMaintainProcesses customer rebates PdsRebateProcessInquire into purchase order to invoice policies PurchOrderToInvoicePoliciesInquire
5 security rolesAuditor AuditPolicyManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerSales manager TradeSalesManagerAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounts payable manager VendInvoiceAccountsPayableManagerAuditor AuditPolicyManagerGive people one of these roles. On this system, 5 roles can open this page.Checked in Dynamics 365
Actions on the pageOptionsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=PdsRebateAgreements
Integrate withSalesRebateAgreementHeaderV2Entity data entity Microsoft data model
Data migrationSalesRebateAgreementHeaderV2Entity (Customer rebate agreement headers V2): loaded for each company.Load order: No default configuration template places this entity. Load the agreement headers after the rebate program types, customer and item rebate groups, customers and released products they refer to, then approve the agreements in the system.Load first: Rebate program types, Customer rebate groups, Item rebate groups, Customers, Released productsMicrosoft Learn
Table definitionPdsRebateAgreement columns and relations Microsoft data model
Everyone

8Sources