BeyondERP.Newsletter
Menu

Setup page · Product information management

Approved customer list setup

A setup page where you link customers or customer groups to the items or item groups they are approved to buy.

Used by
Accounts receivable manager, Customer service manager, Customer service representative and 3 more roles
Business process
Define order management policies for Dynamics 365 Supply Chain Management
Menu item
QMSApprovedCustomerListSetup
Main table
QMSApprovedCustomerList
Data entity
QMSApprovedCustomerGroupEntity
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 link customers or customer groups to the items or item groups they are approved to buy.
What you do hereUse this page to make sure a product is sold only to customers who are authorized to buy it.
ExampleFor example, a juice maker sells a retailer's privately labeled apple juice only to that retailer's warehouse and its retail store, and to no other customer.
Approved customer list setup 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 Approved customer list setup1 screen

Use this page to make sure a product is sold only to customers who are authorized to buy it.

  1. Screen 1

    Approve a customer for an item

    Go to Sales and marketing > Setup > Approved customer list > Approved customer list setup

    1. Make sure the customer and the released product exist (here the example customer BEAT-000001 and item BEAT-ITEM-001)
    2. Select New
    3. Leave Customer code as Table and select the customer
    4. Leave Item code as Table and select the item
    5. Set the effective and expiration dates
    6. Select Save
    1Customer relationBEAT-000001
    Customer codeTable
    Item codeTable
    Item relationBEAT-ITEM-001
    Effective10/18/2026
    ExpirationNever
    Approve a customer for an item (zoomed on the outlined fields)
    Show the full screenApprove a customer for an item
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Product information management > Setup > Approved customer list > Approved customer list setup.
  2. Select New to add a relationship between a customer or customer group and an item or item group.
  3. In the Item code field, select Table, Group or All, and then select the item or item group in the Item relation field.
  4. In the Customer code field, select Table, Group or All, and then select the customer or customer group in the Customer relation field.
  5. In the Effective and Expiration fields, set the approval period.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Item codeWhether the approval is for one item, an approved item group, or all items.Microsoft Learn TableItemCode
Item relationThe approved item or item group.Microsoft Learn BEAT-ITEM-001ItemRelation
Customer codeWhether the approval is for one customer, an approved customer group, or all customers.Microsoft Learn TableCustomerCode
Customer relationThe approved customer or customer group.Microsoft Learn BEAT-000001CustomerRelation
EffectiveThe date when the approval starts; it defaults to today.Microsoft Learn 10/18/2026ValidFrom
ExpirationThe date when the approval ends; it defaults to Never.Microsoft Learn Never

Test checklist

  1. Set Approved customer list check method to Not allowed on a released product and its customer.
  2. Add a line with Item code Table and Customer code Table for one approved customer.
  3. Create a sales order for the approved customer: the line is accepted.
  4. Create a sales order for another customer: an error stops the line.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Approved customer list setupGroup-to-group relationships (approved customer group to approved item group), with an Expiration date only where the approval really ends.If an approved item group is linked to an approved customer group, every customer in that group can buy every item in it, which speeds up approval when the same items are approved for several customers.Which Approved customer list check method should customers and items use?The list does nothing while the customer and item use the No check method; dates are validated only with Warning only or Not allowed, against the Date type set in Sales and marketing parameters.Test: Unapproved customer is blocked from buying a restricted item

Feature management and licence

Feature to turn onApproved customer list (Must be on)Advanced quality management (Mandatory, on by default)

Microsoft Learn

Solution architect

5Design impact

Can it be undoneReversible: Lines can be added, deleted, or have their dates edited at any time. Sales orders are validated when a line is added; sales quotations and agreements when they're confirmed, so documents already processed aren't rechecked. Microsoft Learn
If you change it laterEffective and expiration dates are checked only when the check method is Warning only or Not allowed, not when it is No check. Microsoft Learn
Technical architect

6Technical

Menu itemQMSApprovedCustomerListSetup Checked in Dynamics 365
FormQMSApprovedCustomerList Checked in Dynamics 365
TableQMSApprovedCustomerListShown as “Approved customer list” in Record infoChecked in Dynamics 365
Data entitiesQMSApprovedCustomerGroupEntityApproved customer groups Checked in Dynamics 365QMSApprovedCustomerItemAssignmentEntityApproved customer item assignments Checked in Dynamics 365QMSApprovedItemGroupEntityApproved item groups Checked in Dynamics 365
Who can open itPrivilegesMaintain approved customer list QMSApprovedCustomerListMaintainView approved customer list QMSApprovedCustomerListViewDutiesInquire into approved customer list QMSApprovedCustomerListInquireMaintain approved customer list QMSApprovedCustomerListMaintain
7 security rolesAccounts receivable manager CustInvoiceAccountsReceivableManager MCRTestUserRoleCustomer service manager TradeCustomerServiceManagerCustomer service representative TradeCustomerServiceRepresentativeSales clerk TradeSalesClerkSales manager TradeSalesManagerSales representative TradeSalesRepresentative
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerCustomer service manager TradeCustomerServiceManagerTo use itAccounts receivable manager CustInvoiceAccountsReceivableManagerCustomer service representative TradeCustomerServiceRepresentativeSales representative TradeSalesRepresentativeSales clerk TradeSalesClerkGive people one of these roles. On this system, 6 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=QMSApprovedCustomerListSetup
Integrate withQMSApprovedCustomerGroupEntity data entity Checked in Dynamics 365
Everyone

8Sources