BeyondERP.Newsletter
Menu

Setup page · Sales and marketing

Customer price/discount groups

A setup page where you create customer price and discount groups for trade agreements.

Used by
Accounts receivable clerk, Accounts receivable manager, Accounts receivable centralized payments clerk and 7 more roles
Business process
Develop sales pricing strategy
Menu item
PriceDiscGroup_Cust
Main table
PriceDiscGroup
Data entity
PriceDiscPriceCustomerGroupEntity
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 customer price and discount groups for trade agreements.
What you do hereUse this page to group customers so that prices and discounts can be set up once for the whole group.
ExampleFor example, BEAT gives the same prices to its 12 wholesale customers. It creates price group WHOLESALE, sets it on each customer's Sales order details FastTab and posts one trade agreement line per item with Party code type Group, instead of 12 lines per item.
Customer price/discount 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 processDevelop sales policies › Develop sales pricing strategy
Menu pathSales and marketing › Prices and discounts › Customer price/discount groups
Set up firstActivate price/discount Microsoft Learn
Used next byAll customers Microsoft Learn Trade agreement journals Microsoft Learn
Related pagesItem discount groups 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 Customer price/discount groups1 screen

Use this page to group customers so that prices and discounts can be set up once for the whole group.

  1. Screen 1

    Create a customer price group

    Go to Sales and marketing > Prices and discounts > Customer price/discount groups

    1. In Show, select the kind of group (here Price group)
    2. Select New
    3. Enter the group code and name
    4. Select Save
    5. Assign the group to customers and set up trade agreements for it
    1ShowPrice group
    2Price groupsBEAT-PG
    NamePrice group
    Price/Discount group typePrice group
    Create a customer price group (zoomed on the outlined fields)
    Show the full screenCreate a customer price group
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Prices and discounts > Customer price/discount groups.
  2. In Show, choose the kind of group to list, for example Price group.
  3. Select New and enter the group code and Name.
  4. Open each customer and select the group in the Discount field group of the Sales order details FastTab.
  5. Select the group and select Trade agreements, or create a trade agreement journal line with Party code type Group for the group.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
ShowChooses which kind of customer group the list shows, for example price groups or line discount groups.Checked in Dynamics 365Price group
Price groupsThe identifier of the group, selected on the customer and in trade agreement lines with Party code type Group.Microsoft Learn WHOLESALEGroupId
NameThe descriptive name of the group.Microsoft Learn Wholesale customersName
Price/Discount group typeThe kind of group the row is, such as a price group or a line, multiline or total discount group. It decides which type of trade agreement can use the group.Microsoft Learn Price groupType

Common errors and fixes

MessageWhat to do
A customer in the group gets the base price instead of the group price.Activate the customer group combination for Price on Activate price/discount, and check the group is set on the customer and on the sales order header. Microsoft Learn

Test checklist

  1. Create a customer price group and assign it to two customers on the Sales order details FastTab.
  2. Check the Customer group combination for Price is activated on Activate price/discount.
  3. Post a trade agreement journal line with Party code type Group, the new group and an item price.
  4. Create a sales order for each customer and check both order lines get the group price.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Customer price/discount groupsOne price group per set of customers that get the same prices, attached to each customer on the Sales order details FastTab and used with Party code type Group in trade agreementsWhen several customers get the same prices, the group lets you enter the agreed prices once and price every order for those customers automatically.Setting up groups and Group trade agreements without activating the customer group combinations on Activate price/discount; trade agreements are used only for the combinations that are activated.Test: Group price applies to every customer in the group

Feature management and licence

Licence or add-inOn the live system, Sales manager, Accounts receivable manager and the rental managers (maintain), and Accounts receivable clerk and the accounts receivable payments clerks (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 undoneReversible: Groups and their assignment to customers can be changed at any time. The group on the customer defaults to the sales order header, so a change affects new orders; posted trade agreements for the old group stay in place. Microsoft Learn
If you change it laterThe group on the customer is copied to the sales order header, where it can be changed per order. Trade agreements posted for the group then price every new order line of the customers in it; orders already priced keep their prices. Microsoft Learn
Technical architect

6Technical

Menu itemPriceDiscGroup_Cust Checked in Dynamics 365
FormPriceDiscGroup Checked in Dynamics 365
TablePriceDiscGroupShown as “Price groups” in Record infoKey field: Module, Type, GroupIdChecked in Dynamics 365
Data entitiesPriceDiscPriceCustomerGroupEntityPrice customer groups Microsoft data model PriceDiscLineDiscountCustomerGroupEntityLine discount customer groups Microsoft data model PriceDiscMultilineDiscountCustomerGroupEntityMultiline discount customer groups Microsoft data model PriceDiscTotalDiscountCustomerGroupEntityTotal discount customer groups Microsoft data model
Who can open itPrivilegesMaintain sales trade agreements elements PriceDiscAdmNameSalesMaintainView sales trade agreements elements PriceDiscAdmNameSalesViewMaintain retail pricing RetailPricingMaintainDutiesEnable quotation to sales order process RentalSalesQuotationToSlsOrdProcessEnableMaintain retail product pricing RetailProductPricingMaintainEnable quotation to sales order process SalesQuotationToSalesOrderProcessEnableInquire into quotation to sales order reference data SalesQuotationToSalesOrderRefDataInquir
10 security rolesAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkRental coordinator agent RentalCoordinatorAgentRental manager RentalManagerRental sales manager RentalSalesManagerRetail merchandising manager RetailMerchandisingManagerRetail service RetailServiceSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentRental sales manager RentalSalesManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkGive people one of these roles. On this system, 10 roles can open this page.Checked in Dynamics 365
Actions on the pageTrade agreementsOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=PriceDiscGroup_Cust
Integrate withPriceDiscPriceCustomerGroupEntity data entity Microsoft data model
Data migrationPriceDiscLineDiscountCustomerGroupEntity (Line discount customer groups): loaded for each company, in Microsoft's default template 140 - Accounts receivable.PriceDiscMultilineDiscountCustomerGroupEntity (Multiline discount customer groups): loaded for each company, in Microsoft's default template 330 - Sales and marketing.PriceDiscTotalDiscountCustomerGroupEntity (Total discount customer groups): loaded for each company, in Microsoft's default template 140 - Accounts receivable.Load order: Microsoft's default template 140 - Accounts receivable loads Line discount customer 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 definitionPriceDiscGroup columns and relations Microsoft data model
Everyone

8Sources