BeyondERP.Newsletter
Menu

Setup step on the Approved customer list setup page · Sales and marketing

Set up Approved customer list setup

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

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
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 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, BEAT sells its private-label sparkling water BEAT-ITEM-001 only to customer BEAT-000123 and its store group RETAILCHAIN. A Group-to-Group line from 01/01/2027 lets every store in RETAILCHAIN order it, and a sales order line for BEAT-000456 is stopped because both the customer and the item use Not allowed.
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 Sales and marketing > 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

Common errors and fixes

MessageWhat to do
A sales order line for an unapproved customer is accepted without any message.Set Approved customer list check method to Warning only or Not allowed on the customer (Sales order defaults FastTab) and on the released product (Sell FastTab). With No check, no validation is done. Microsoft Learn
A sales quotation for an unapproved item is saved without a warning.That is expected: quotations and sales agreements are validated when they are confirmed, not when lines are added. Confirm the quotation to see the check. Microsoft Learn

Test checklist

  1. Set Approved customer list check method to Not allowed on a released product (Sell FastTab) and on a customer (Sales order defaults).
  2. Add a relationship for that item and a different customer, effective today.
  3. Add the item to a sales order for an unapproved customer and check that an error stops the line.
  4. Add it for the approved customer and check that the line is accepted; then set an Expiration in the past and check the line is blocked again.

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 (On by default as of 10.0.47)Advanced quality management (Mandatory as of 10.0.49)
Licence or add-inOn the live system, Sales manager and Customer service manager can maintain this page, and Accounts receivable manager, Sales clerk, Sales representative and Customer service representative can use it.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyOne list serves both menus: the same Approved customer list setup page opens from Sales and marketing and from Product information management. The check method that makes it act is set on each customer and on each released product. Microsoft Learn
Can it be undoneReversible: Relationships can be deleted and their dates edited at any time; checks apply when documents are entered or confirmed.
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 CustInvoiceAccountsReceivableManagerSales clerk TradeSalesClerkSales representative TradeSalesRepresentativeCustomer service representative TradeCustomerServiceRepresentativeGive 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
Data migrationQMSApprovedCustomerGroupEntity Approved customer groups; load first.QMSApprovedItemGroupEntity Approved item groups; load before the assignments.QMSApprovedCustomerItemAssignmentEntity The customer and item relationships on this page.Load order: Load customers and released products first, then the approved customer and item groups, then the customer and item assignments that refer to them.Load first: Customers, Released productsChecked in Dynamics 365
Everyone

8Sources

To cite this step: SM-SETUP-050, Set up Approved customer list setup. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SM-SETUP-050