BeyondERP.Newsletter
Menu

Setup step on the Search criteria page · Sales and marketing

Set up Search criteria

Use this page to add identifiers and dimensions, such as display product number, configuration, color, size and style, to product search.

Used by
Accounts receivable manager, Retail service, Sales manager
Business process
Enter sales orders
Menu item
MCRFullTextIndexField
Main table
MCRFullTextIndexField
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 choose the fields that customer, prospect and product search look in.
What you do hereUse this page to add identifiers and dimensions, such as display product number, configuration, color, size and style, to product search.
ExampleBEAT's order takers often know only the colour and size, for example RED and L. BEAT adds DisplayProductNumber, configId, InventColorId, InventSizeId and InventStyleId to the product criteria and runs Update search data, so typing RED L finds variant BEAT-ITEM-009 : RED : L among 12,000 variants.
Search criteria 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.

Setup steps on this page

Set up Search criteria

Use this page to add identifiers and dimensions, such as display product number, configuration, color, size and style, to product search.

Steps from Microsoft

  1. Go to Sales and marketing > Setup > Search > Search criteria.
  2. Filter the page to product search criteria by switching to Product.
  3. Select New and, in the Field name column, select a field such as DisplayProductNumber.
  4. Add more records for fields such as configId, InventColorId, InventSizeId and InventStyleId.
  5. Select Update search data, make sure Source is set to Product, and select OK.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Field nameThe field that search looks in, for example DisplayProductNumber or configId.Microsoft Learn InventColorIdField

Common errors and fixes

MessageWhat to do
Order takers get no match for a variant they know existsAdd the identifier or dimension field to the product criteria and run Update search data with Source = Product; schedule it in batch when the system isn't busy. Microsoft Learn

Test checklist

  1. On Search criteria, switch to Product and add DisplayProductNumber and configId.
  2. Select Update search data, set Source to Product and run it.
  3. On Search parameters, set Enable lookup for search to Yes and Search type to Full match.
  4. On a new sales order line, type part of a configuration ID in Item number and check the matching variant appears in the lookup.
  5. Type two words that don't appear together as one string (for example a name fragment and a configuration fragment) and check no result is returned.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Search criteriaSwitch the page to Product and add the identifiers your order takers actually type: DisplayProductNumber, configId, InventColorId, InventSizeId and InventStyleId. Then run Update search data with Source = Product as a batch job.Product search on the Item number field looks across every field enabled on Search criteria, so variants can only be found by configuration, color, size or style when those fields are listed here. Learn recommends scheduling the search table population on the batch server when it isn't busy, because the run can be long.Which fields should product search look in?Adding or changing criteria without running Update search data again. Until the search table is filled, product search doesn't return correct results, and order takers see no matches.Test: Variant found by configuration on a sales order line

Feature management and licence

Licence or add-inOn the live system, Sales manager, Accounts receivable manager and Retail service 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: You can add or remove criteria at any time, but each change needs a new Update search data run before search reflects it. Newly released products and variants are added to the search table automatically.
If you change it laterAfter you change the search criteria, run Update search data again; until the search table is filled, product search won't return correct results. Microsoft Learn
Technical architect

6Technical

Menu itemMCRFullTextIndexField Checked in Dynamics 365
FormMCRFullTextIndexField Checked in Dynamics 365
TableMCRFullTextIndexFieldShown as “Full text index fields” in Record infoChecked in Dynamics 365
Who can open itPrivilegesDefine criteria for full text searches MCRFullTextIndexFieldMaintainDutiesMaintain full text search MCRSearchMaintainEnable quotation to sales order process SalesQuotationToSalesOrderProcessEnable
3 security rolesAccounts receivable manager CustInvoiceAccountsReceivableManagerRetail service RetailServiceSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerRetail service RetailServiceGive people one of these roles. On this system, 3 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=MCRFullTextIndexField
Data migrationLoad order: Search criteria has no data entity in Data management. Add the criteria by hand in each legal entity and run Update search data afterwards; the search table is filled by that job, not by data import.Checked in Dynamics 365
Table definitionMCRFullTextIndexField columns and relations Microsoft data model
Everyone

8Sources

To cite this step: SM-SETUP-760, Set up Search criteria. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SM-SETUP-760