BeyondERP.Newsletter
Menu

Setup page · Sales and marketing

Supplementary item - customer groups

A setup page where you create the customer groups for supplementary items, each with an ID and a name, and open the supplementary sales items for a group.

Used by
Accounts receivable clerk, Accounts receivable manager, Accounts receivable centralized payments clerk and 6 more roles
Business process
Enter sales orders
Menu item
SuppItemGroup_Cust
Main table
SuppItemGroup
Data entity
InventSupplementaryProductCustomerGroupEntity
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 the customer groups for supplementary items, each with an ID and a name, and open the supplementary sales items for a group.
What you do hereUse this page to group customers so that the same supplementary items, required or optional extra products, are proposed when they order.
ExampleFor example, BEAT creates the customer group HORECA for its 85 cafes and restaurants, so that 1 free bottle opener BEAT-ITEM-090 is proposed with every 12 cases of BEAT-ITEM-001 they order.
Supplementary item - customer 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 sales orders › Enter sales orders
Menu pathSales and marketing › Setup › Items › Supplementary item - customer groups
Set up firstAll customers Microsoft Learn
Used next byAll sales orders (supplementary items proposed) Microsoft Learn
Related pagesSupplementary item - item groups Microsoft Learn Supplementary item - customer groups (Inventory management) Checked in Dynamics 365
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 Supplementary item - customer groups1 screen
  1. Screen 1

    Create a customer group for supplementary items

    Go to Sales and marketing > Setup > Items > Supplementary item - customer groups

    1. Select New
    2. Enter the group code and name
    3. Select Save
    4. Assign the group to customers, then use Supplementary sales items to add the items that are offered with an order
    1Supplementary item groupBEAT-SIG
    NameSupplementary group
    Create a customer group for supplementary items (zoomed on the outlined fields)
    Show the full screenCreate a customer group for supplementary items
    page title tab to open what to set or check

How to use it

  1. Go to Sales and marketing > Setup > Items > Supplementary item - customer groups.
  2. Select New and enter the supplementary item customer group ID and the Name.
  3. Select Supplementary sales items on the Action Pane and add the supplementary items for the group.
  4. Set the group on the customers who should get these proposals.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
Supplementary item groupThe ID of the supplementary item customer group.Checked in Dynamics 365HORECAGroupId
NameThe name of the group.Checked in Dynamics 365Cafes and restaurantsName

Common errors and fixes

MessageWhat to do
No supplementary item is proposed on the sales order.Supplementary items are proposals for products related to the one ordered; check that the customer belongs to the group and that the supplementary sales item is set up for the ordered item. Microsoft Learn

Test checklist

  1. Create group HORECA and, under Supplementary sales items, add BEAT-ITEM-090 for BEAT-ITEM-001.
  2. Set HORECA on a customer.
  3. Add BEAT-ITEM-001 to a sales order for that customer.
  4. Check that 1 supplementary item, BEAT-ITEM-090, is proposed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Supplementary item - customer groupsCustomer groups only for customers who get different supplementary items (for example free accessories for one channel).Supplementary items propose related products, required, optional or free; a customer group lets one set of proposals apply to many customers.Propose supplementary items per customer group or for all customers?Setting up groups but not reviewing the proposals on the order; supplementary items are only proposed, so they can still be missed.Test: Supplementary item is proposed for the group

Feature management and licence

Licence or add-inOn the live system, Sales manager, Rental manager, Rental coordinator agent, Rental sales manager and Accounts receivable manager can maintain this page, and Accounts receivable clerk, Accounts receivable centralized payments clerk and Accounts receivable payments clerk can use it.

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 supplementary items can be changed or removed at any time. Microsoft Learn
If you change it laterThe group only drives the proposals made while order lines are entered; lines already on orders stay as they are. Microsoft Learn
Technical architect

6Technical

Menu itemSuppItemGroup_Cust Checked in Dynamics 365
FormSuppItemGroup Checked in Dynamics 365
TableSuppItemGroupShown as “Supplementary item groups” in Record infoKey field: Module, GroupIdChecked in Dynamics 365
Data entitiesInventSupplementaryProductCustomerGroupEntitySupplementary item - customer groups Microsoft data model InventSupplementaryProductProductGroupEntitySupplementary item - item groups Microsoft data model InventSupplementaryProductVendorGroupEntitySupplementary item - vendor groups Microsoft data model
Who can open itPrivilegesMaintain customer supplementary item groups SuppItemGroup_CustMaintainView customer supplementary item groups SuppItemGroup_CustViewDutiesEnable quotation to sales order process RentalSalesQuotationToSlsOrdProcessEnableEnable quotation to sales order process SalesQuotationToSalesOrderProcessEnableInquire into quotation to sales order reference data SalesQuotationToSalesOrderRefDataInquir
9 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 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, 9 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=SuppItemGroup_Cust
Integrate withInventSupplementaryProductCustomerGroupEntity data entity Microsoft data model
Data migrationInventSupplementaryProductCustomerGroupEntity (Supplementary item - customer groups): loaded for each company, in Microsoft's default template 330 - Sales and marketing.Load order: Microsoft's default template 330 - Sales and marketing loads Supplementary item - 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 definitionSuppItemGroup columns and relations Microsoft data model
Everyone

8Sources