BeyondERP.Newsletter
Menu

Setup step on the Conditions page · Sales and marketing

Set up Conditions

Use this page to describe, field by field, the situation in which a product should be suggested, such as a customer group and a product on the order.

Used by
Sales manager
Business process
Enter sales orders
Menu item
MCRUpSellVarCondition
Main table
MCRUpSellVarCondition
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 isThe second up-sell/cross-sell setup page. A condition is a named set of field tests on one table (field, operand and value or variable) that must be true for a rule to suggest a product.
What you do hereUse this page to describe, field by field, the situation in which a product should be suggested, such as a customer group and a product on the order.
ExampleBEAT creates condition WHOLESALE-009 on CustTable: CustGroup = WHOLESALE. Rule GLOVES-UP then uses it, so an order line for 10 boxes of BEAT-ITEM-009 at 12.50 for a WHOLESALE customer triggers the suggestion of BEAT-ITEM-016.
Conditions 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 › Up-sell/cross-sell › Conditions
Set up firstVariables Microsoft Learn Set up Variables
Used next byRules Microsoft Learn Set up Rules
Related pagesUp-sell/cross-sell setup Microsoft Learn
In this process Set up Variables · Set up Rules
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 Conditions1 screen

Use this page to describe, field by field, the situation in which a product should be suggested, such as a customer group and a product on the order.

  1. Screen 1

    Create an up-sell/cross-sell condition

    Go to Sales and marketing > Setup > Up-sell/cross-sell > Conditions

    1. Make sure the variable exists (Sales and marketing > Setup > Up-sell/cross-sell > Variables)
    2. Select New
    3. Enter the condition name, select the condition table and enter a description
    4. Select Save
    5. Under Fields, select Add, then choose the field type, field, value type, operand and value
    6. Select Save
    1Condition nameBEAT-COND
    2Condition tableCustTable
    3DescriptionCondition
    4FieldCustGroup
    Field typeTable field
    Value typeVariable
    Operand=
    ValueBEAT-VAR
    Create an up-sell/cross-sell condition (zoomed on the outlined fields)
    Show the full screenCreate an up-sell/cross-sell condition
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Setup > Up-sell/cross-sell > Conditions.
  2. Select New and enter a Condition name and a Description.
  3. In Condition table, select the table the condition is based on, for example CustTable.
  4. On the Fields FastTab, select Add and enter Field type, Field, Value type, Operand and Value.
  5. Open Rules and add the condition to a rule.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Condition tableThe table that the condition is based on.Microsoft Learn CustTableConditionTable
Condition nameThe name of the condition.Checked in Dynamics 365HighValueConditionName
DescriptionA short description of the condition.Checked in Dynamics 365ConditionDescription
Field typeWhether the compared value comes from a table field or a method.Microsoft Learn Table fieldTablevaluetype
FieldThe field whose value is tested.Microsoft Learn CustGroupConditionField
Value typeWhether the condition compares the field with a fixed value or with a variable from the Variables page.Microsoft Learn VariableValueType
OperandThe comparison operator, such as equals.Microsoft Learn =Operand
ValueThe value or variable that the field is compared with.Microsoft Learn WHOLESALEValue

Common errors and fixes

MessageWhat to do
Test rule returns false for an order that should matchCheck the condition table, the operand and the value on each Fields line; every line of the condition has to be true. Microsoft Learn

Test checklist

  1. Create condition WHOLESALE-009 on CustTable with CustGroup = WHOLESALE.
  2. Add it to rule GLOVES-UP and select Test rule on the Rules page.
  3. Check that the test result is true for a WHOLESALE customer and false for a RETAIL customer.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up ConditionsOne condition per business situation, named after it (for example WHOLESALE-009), with as few field lines as needed.Up-selling suggests another product instead of the ordered one; cross-selling suggests a product in addition to it. A rule suggests a product only when its conditions are true, so each condition must describe one clear situation.Should a condition test fixed values or variables?Putting the condition on the wrong table (for example the order line instead of the customer), so it never evaluates as true.Test: Condition evaluates per customer group

Feature management and licence

Licence or add-inOn the live system, Sales manager use this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own conditions. Microsoft data model
Can it be undoneReversible: Conditions can be edited at any time; test the rules afterwards.
If you change it laterEvery rule that uses the condition changes with it; select Test rule on those rules after a change. Microsoft Learn
Technical architect

6Technical

Menu itemMCRUpSellVarCondition Checked in Dynamics 365
FormMCRVarCondition Checked in Dynamics 365
TableMCRUpSellVarConditionShown as “Condition” in Record infoChecked in Dynamics 365
Who can open itPrivilegesMaintain up-sell conditions MCRUpSellVarConditionMaintainDutiesMaintain up and cross-selling MCRUpSellCrossMaintain
1 security roleSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerGive people one of these roles. On this system, 1 role 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=MCRUpSellVarCondition
Data migrationLoad order: Conditions has no data entity in Data management. Create the conditions by hand in each legal entity after loading the variables, then test the rules that use them.Checked in Dynamics 365
Table definitionMCRUpSellVarCondition columns and relations Microsoft data model
Everyone

8Sources

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