BeyondERP.Newsletter
Menu

Setup step on the Customer rebate groups page · Sales and marketing

Set up Customer rebate groups

Use this page to assign rebates to a group of customers instead of to each customer one by one.

Used by
Accounts payable manager, Auditor, Sales manager
Business process
Process customer rebates
Menu item
PdsCustRebateGroup
Main table
PdsCustRebateGroup
Data entity
SalesRebateCustomerGroupEntity
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 setup page where you create customer rebate groups, so that one customer rebate agreement can cover a group of customers. 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 customers instead of to each customer one by one.
ExampleFor example, BEAT groups its three supermarket chains in customer rebate group CHAINS and sets up one quarterly volume rebate agreement for the group instead of three.
Customer 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

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 Customer rebate groups1 screen

Use this page to assign rebates to a group of customers instead of to each customer one by one.

  1. Screen 1

    Create a customer rebate group

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

    1. Select New
    2. Enter the group code and description
    3. Select Save
    4. Assign the group to customers on the customer record
    1Customer rebate groupBEAT-CRG
    DescriptionCustomer rebate group
    Create a customer rebate group (zoomed on the outlined fields)
    Show the full screenCreate a customer 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 > Customer rebate groups.
  2. Select New.
  3. In the Customer 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
Customer rebate groupThe unique name of the group, selected on rebate agreements for a group of customers and as a filter when rebates are processed.Microsoft Learn CHAINSPdsCustRebateGroupId
DescriptionA short description of the group.Checked in Dynamics 365Customer rebate groupDescription

Common errors and fixes

MessageWhat to do
A customer in the group gets no rebate claim after invoicing.Associate the customer with the customer rebate group and check that the group's agreement is approved and covers the item. Microsoft Learn

Test checklist

  1. Create customer rebate group CHAINS.
  2. Associate two customers with the group.
  3. Create and approve a rebate agreement for the group and invoice a qualifying order for each customer.
  4. Check that Rebates lists one claim per customer.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Customer rebate groupsOne customer rebate group per set of customers that get the same rebate terms, with the customers associated with the group before the agreement is approved.After the groups are set up, customers are associated with a group and rebate agreements are defined for the group; Process rebates can also be limited to one customer rebate group.Creating the group and the agreement but not associating the customers with the group, so their invoices create no claims.Test: A group agreement creates claims for each customer in the 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
Can it be undoneReversible: The group can be renamed or reassigned; claims already created keep their values.
If you change it laterA rebate agreement for the group applies to every customer associated with it, and Process rebates can be run for one customer rebate group. Moving a customer to another group affects claims from later invoices. Microsoft Learn
Technical architect

6Technical

Menu itemPdsCustRebateGroup Checked in Dynamics 365
FormPdsCustRebateGroup Checked in Dynamics 365
TablePdsCustRebateGroupShown as “Customer rebate groups” in Record infoChecked in Dynamics 365
Data entitiesSalesRebateCustomerGroupEntityCustomer rebate groups Microsoft data model
Who can open itPrivilegesMaintain customer rebate groups PdsCustRebateGroupMaintainView customer rebate groups PdsCustRebateGroupViewDutiesMaintains 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=PdsCustRebateGroup
Integrate withSalesRebateCustomerGroupEntity data entity Microsoft data model
Data migrationSalesRebateCustomerGroupEntity (Customer rebate groups): loaded for each company.Load order: No default configuration template places this entity. Load the groups before the rebate agreements that refer to them.Load first: Rebate program typesMicrosoft Learn
Table definitionPdsCustRebateGroup columns and relations Microsoft data model
Everyone

8Sources