BeyondERP.Newsletter
Menu

Page · Sales and marketing

Item rebate groups

A setup page where you create item rebate groups, so that one customer rebate agreement can cover a group of items that share the same threshold. 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, Sales manager
Business process
Process customer rebates
Menu item
PdsItemRebateGroup
Main table
PdsItemRebateGroup
Data entity
SalesRebateProductGroupEntity
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 setup page where you create item rebate groups, so that one customer rebate agreement can cover a group of items that share the same threshold. 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 assign rebates to a group of items instead of to each item one by one.
ExampleFor example, BEAT puts its four 55-inch televisions, which share the same 50-unit threshold, in item rebate group TV55 and sets up one quantity rebate agreement for the group.
Item rebate groups 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 groups › Item rebate groups
Set up firstRebate program types Microsoft Learn
Used next byRebate agreements Microsoft Learn
Related pagesCustomer rebate groups 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.

Step by step, with screenshots

Set up Item rebate groups1 screen

Use this page to assign rebates to a group of items instead of to each item one by one.

  1. Screen 1

    Create an item rebate group

    Go to Sales and marketing > Customer rebates > Rebate groups > Item rebate groups

    1. Select New
    2. Enter the group code and description
    3. Select Save
    4. Assign the group to items on the released product
    1Item rebate groupBEAT-IRG
    DescriptionItem rebate group
    Create an item rebate group (zoomed on the outlined fields)
    Show the full screenCreate an item rebate group
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Customer rebates > Rebate groups > Item rebate groups.
  2. Select New.
  3. In the Item rebate group field, enter a unique name.
  4. In the Description field, enter a description.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Item rebate groupThe unique name of the group, selected on rebate agreements for a group of items. Put only items with the same threshold in one group.Microsoft Learn TV55PdsItemRebateGroupId
DescriptionA short description of the group.Checked in Dynamics 365Item rebate groupDescription

Common errors and fixes

MessageWhat to do
Rebates are calculated, but cumulation fails for an amount-type agreement that uses an item rebate group.This is by design: the threshold is checked against the amount of each item, not the group's combined amount. Group only items with the same threshold, or set up the agreement per item. Microsoft Learn

Test checklist

  1. Create an item rebate group with two items that share the same threshold and assign it to both items.
  2. Create and approve an amount-type rebate agreement that uses the item rebate group.
  3. Invoice sales of both items for the customer and run Cumulate on the Rebates page.
  4. Check that the threshold is applied to each item's amount, not to the group's combined amount.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Item rebate groupsGroup only items that share the same rebate threshold conditionFor amount-type customer rebate agreements, the threshold is checked against the amount for each item, not against the combined amount of the items in the group.Grouping items with different thresholds and expecting the group's combined sales to reach the threshold; rebates are calculated, but cumulation doesn't work as expected. Microsoft confirms this is by design.Test: Amount thresholds are checked per item in an item rebate group

Feature management and licence

Licence or add-inOn the live system, Sales manager (maintain), and 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
If you change it laterPut only items with the same threshold in one group: for amount-based agreements, the threshold applies to each item and not to the group's combined amount. Microsoft Learn
Technical architect

6Technical

Menu itemPdsItemRebateGroup Checked in Dynamics 365
FormPdsItemRebateGroup Checked in Dynamics 365
TablePdsItemRebateGroupShown as “Item rebate groups” in Record infoChecked in Dynamics 365
Data entitiesSalesRebateProductGroupEntityItem rebate groups Microsoft data model
Who can open itPrivilegesMaintain rebate groups by item PdsItemRebateGroupMaintainView rebate groups by item PdsItemRebateGroupViewDutiesMaintains customer rebate agreements PdsRebateAgreementMaintainInquire into purchase order to invoice policies PurchOrderToInvoicePoliciesInquire
3 security rolesAuditor AuditPolicyManagerSales 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 payable manager VendInvoiceAccountsPayableManagerAuditor AuditPolicyManagerGive people one of these roles. On this system, 3 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=PdsItemRebateGroup
Integrate withSalesRebateProductGroupEntity data entity Microsoft data model
Data migrationSalesRebateProductGroupEntity (Item rebate groups): loaded for each company, in Microsoft's default template 320 - Procurement and sourcing.Load order: Microsoft's default template 320 - Procurement and sourcing loads Item rebate groups at execution unit 1, level 30, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to General ledger)Microsoft Learn
Table definitionPdsItemRebateGroup columns and relations Microsoft data model
Everyone

8Sources