BeyondERP.Newsletter
Menu

Setup page · Procurement and sourcing

Item discount groups

A setup page where you create item discount groups, such as line discount and multiline discount groups, that products can be assigned to.

Used by
Accounts payable manager, Accounts receivable clerk, Accounts receivable manager and 8 more roles
Business process
Procure goods and services
Menu item
PriceDiscGroup_Invent
Main table
PriceDiscGroup
Data entity
PriceDiscLineDiscountProductGroupEntity
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 discount groups, such as line discount and multiline discount groups, that products can be assigned to.
What you do hereUse this page to group items so that line or multiline discount trade agreements can apply to the whole group.
ExampleFor example, a company can give a multiline discount when a customer orders more than 10 items from the same item discount group.
Item 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 processProcure goods and services
Menu pathProcurement and sourcing › Prices and discounts › Price/discount groups › Item discount groups
Used next byTrade agreement journals Microsoft Learn
Related pagesActivate price/discount Microsoft Learn Vendor price/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 Item discount groups1 screen

Use this page to group items so that line or multiline discount trade agreements can apply to the whole group.

  1. Screen 1

    Create the item discount group

    Go to Procurement and sourcing > Prices and discounts > Price/discount groups > Item discount groups

    1. In Show, keep Line discount group
    2. Select New
    3. Enter the group and its name
    4. Select Save
    1ShowLine discount group
    2Price groupsBEAT-IDG
    Create the item discount group (zoomed on the outlined fields)
    Show the full screenCreate the item discount group
    page title tab to open what to set or check

How to use it

  1. Go to Procurement and sourcing > Prices and discounts > Price/discount groups > Item discount groups.
  2. Select the type of group to list in the Show list.
  3. Select New to add a group, then fill in the Price groups and Name columns.
  4. Select a group, then select Edit to change it.
  5. Select Trade agreements to work with the trade agreements for the selected group.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
ShowLine discount group
Price groupsThe identifier of the price group.Microsoft Learn VOLUMEGroupId

Test checklist

  1. Create a multiline discount group and assign two items to it on the Purchase FastTab.
  2. Activate the multiline discount combination on Activate price/discount and post a multiline discount agreement for the group.
  3. Create a purchase order with both items whose combined quantity meets the agreement and check the discount is applied.
  4. Remove one line and check the discount drops when the remaining quantity is below the threshold.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Item discount groupsLine discount groups for items that get the same line discount, and multiline discount groups for items whose quantities should count togetherLine discounts can be activated for items, item line discount groups or all items, while multiline discounts only work for item multiline discount groups or all items and apply when lines in the same group together meet the requirement.Expecting a multiline discount on items that aren't in the same multiline discount group, or setting both discount types without choosing the Discount rule in the parameters (Line, Multiline, MAX, MIN, Line + Multiline).
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Item discount groups can be reassigned on the released product at any time; they affect discount lookups on new order lines. Microsoft Learn
Technical architect

6Technical

Menu itemPriceDiscGroup_Invent Checked in Dynamics 365
FormPriceDiscGroup Checked in Dynamics 365
TablePriceDiscGroupShown as “Price groups” in Record infoKey field: Module, Type, GroupIdChecked in Dynamics 365
Data entitiesPriceDiscLineDiscountProductGroupEntityLine discount item groups Microsoft data model PriceDiscMultilineDiscountProductGroupEntityMultiline discount item groups Microsoft data model PriceDiscLineDiscountCustomerGroupEntityLine discount customer groups Microsoft data model PriceDiscLineDiscountVendorGroupEntityLine discount vendor groups Microsoft data model PriceDiscMultilineDiscountCustomerGroupEntityMultiline discount customer groups Microsoft data model PriceDiscTotalDiscountCustomerGroupEntityTotal discount customer groups Microsoft data model PriceDiscTotalDiscountVendorGroupEntityTotal discount vendor groups Microsoft data model PriceDiscMultilineDiscountVendorGroupEntityMultiline discount vendor groups Microsoft data model PriceDiscPriceCustomerGroupEntityPrice customer groups Microsoft data model PriceDiscPriceVendorGroupEntityPrice vendor groups Microsoft data model MCRPostageDiscountCustomerGroupEntityPostage discount customer groups Microsoft data model
Who can open itPrivilegesMaintain purchase trade agreements elements PriceDiscAdmNamePurchMaintainView purchase trade agreements elements PriceDiscAdmNamePurchViewMaintain sales trade agreements elements PriceDiscAdmNameSalesMaintainView sales trade agreements elements PriceDiscAdmNameSalesViewDutiesEnable purchase order to invoice process PurchOrderToInvoiceProcessEnableInquire into purchase order to invoice reference data PurchOrderToInvoiceReferenceDataInquireEnable quotation to sales order process RentalSalesQuotationToSlsOrdProcessEnableEnable quotation to sales order process SalesQuotationToSalesOrderProcessEnableInquire into quotation to sales order reference data SalesQuotationToSalesOrderRefDataInquir
11 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 service RetailServicePurchasing manager TradePurchasingManagerSales manager TradeSalesManagerAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itPurchasing manager TradePurchasingManagerAccounts payable manager VendInvoiceAccountsPayableManagerRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentRetail service RetailServiceTo use itAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkAccounts receivable clerk CustInvoiceAccountsReceivableClerkGive people one of these roles. On this system, 11 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_Invent
Integrate withPriceDiscLineDiscountProductGroupEntity data entity Microsoft data model
Data migrationPriceDiscLineDiscountProductGroupEntity (Line discount item groups): loaded for each company, in Microsoft's default template 300 - Inventory.PriceDiscMultilineDiscountProductGroupEntity (Multiline discount item groups): loaded for each company, in Microsoft's default template 320 - Procurement and sourcing.Load order: Microsoft's default template 300 - Inventory loads Line discount item 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