BeyondERP.Newsletter
Menu

Setup step on the Variables page · Sales and marketing

Set up Variables

Use this page to name a table and field whose value the conditions and rules for up-selling and cross-selling check.

Used by
Sales manager
Business process
Enter sales orders
Menu item
MCRUpSellVarSys
Main table
MCRUpSellVarSys
Data entity
MCRUpSellCrossSellVariableEntity
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 first of three up-sell/cross-sell setup pages. A variable names a table and a field (for example the customer group on the customer) whose value conditions can test when deciding whether to suggest a product during order entry.
What you do hereUse this page to name a table and field whose value the conditions and rules for up-selling and cross-selling check.
ExampleBEAT wants order takers to offer premium gloves BEAT-ITEM-016 instead of standard gloves BEAT-ITEM-009 when a WHOLESALE customer orders them. It creates variable CUSTGROUP on table CustTable, field CustGroup, so a condition can test the customer group.
Variables 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 Variables1 screen

Use this page to name a table and field whose value the conditions and rules for up-selling and cross-selling check.

  1. Screen 1

    Create an up-sell/cross-sell variable

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

    1. Select New
    2. Enter the variable name
    3. Select the variable table and the field whose value is checked
    4. Enter a description
    5. Select Save
    1Variable nameBEAT-VAR
    Variable tableCustTable
    FieldCustGroup
    DescriptionCustomer group variable
    Create an up-sell/cross-sell variable (zoomed on the outlined fields)
    Show the full screenCreate an up-sell/cross-sell variable
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Setup > Up-sell/cross-sell > Variables.
  2. Select New and enter a Variable name, for example CUSTGROUP, and a Description.
  3. In Variable table, select the table that holds the value, for example CustTable.
  4. In Field, select the field whose value is used, for example CustGroup.
  5. Open Conditions and use the variable in a condition line.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Variable tableThe table that contains the field used as the variable.Microsoft Learn CustTableVariableTable
FieldThe field whose value is used as the variable.Microsoft Learn CustGroupVariableField
Variable nameThe name of the variable that conditions refer to.Microsoft Learn CUSTGROUPVariableName
DescriptionA short description of the variable.Microsoft Learn Customer group of the order customerDescription

Common errors and fixes

MessageWhat to do
A condition never matchesCheck that the variable's table and field are the ones the order actually carries, for example the customer group on the customer, not on another table. Microsoft Learn

Test checklist

  1. Create variable CUSTGROUP on CustTable, field CustGroup.
  2. On Conditions, create a condition line with Value type Variable and select CUSTGROUP.
  3. Check that the lookup on the condition line lists CUSTGROUP and the other variables you created, and nothing else.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up VariablesCreate only the variables that your rules really test, typically the customer group and the item number, with names the order team recognizes.Up-selling suggests another product instead of the ordered one; cross-selling suggests a product in addition to it. Rules are built from conditions, and conditions compare variables, so every rule depends on the variable's table and field.Should up-sell and cross-sell use rules, or plain item-level suggestions?Pointing a variable at the wrong table, so the condition compares a value the order never has and the suggestion never appears.Test: Variable is available to conditions

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 up-sell/cross-sell variables. Microsoft data model
Can it be undoneReversible: Variables can be changed at any time; test the rules again afterwards.
If you change it laterConditions and rules that use the variable change with it; test the rules again after changing a variable's table or field. Suggestions appear during call center order entry only when Enable direct selling is turned on for the call center channel. Microsoft Learn
Technical architect

6Technical

Menu itemMCRUpSellVarSys Checked in Dynamics 365
FormMCRUpSellVarSys Checked in Dynamics 365
TableMCRUpSellVarSysShown as “Up-sell/cross-sell variables” in Record infoChecked in Dynamics 365
Data entitiesMCRUpSellCrossSellVariableEntityUp-sell/cross-sell variables Microsoft data model
Who can open itPrivilegesMaintain up-sell variables MCRUpSellVarSysMaintainDutiesMaintain 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=MCRUpSellVarSys
Integrate withMCRUpSellCrossSellVariableEntity data entity Microsoft data model
Data migrationMCRUpSellCrossSellVariableEntity (Up-sell/cross-sell variables): loaded for each company.Load order: Load variables first, then create the conditions and rules that use them; Conditions and Rules have no data entity in Data management.Checked in Dynamics 365
Table definitionMCRUpSellVarSys columns and relations Microsoft data model
Everyone

8Sources

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