BeyondERP.Newsletter
Menu

Setup step on the Item list page · Sales and marketing

Set up Item list

Use this page to let order takers add a customer's usual items to a new sales order in one step instead of line by line.

Used by
Sales clerk, Sales manager, Sales representative
Business process
Enter sales orders
Menu item
MCRItemListTable
Main table
MCRItemListTable
Data entity
MCRSalesProductSetEntity
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 keep item lists, the items and quantities that a customer buys again and again.
What you do hereUse this page to let order takers add a customer's usual items to a new sales order in one step instead of line by line.
ExampleFor example, BEAT keeps item list BEAT-000017 for cafe customer BEAT-000456 with 24.00 ea of BEAT-ITEM-001 and 12.00 ea of BEAT-ITEM-014, so the weekly order is added to a new sales order in one step.
Item list 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 Item list1 screen

Use this page to let order takers add a customer's usual items to a new sales order in one step instead of line by line.

  1. Screen 1

    Create an item list

    Go to Sales and marketing > Setup > Items > Item list

    1. Make sure the released product exists (here the example item BEAT-ITEM-001)
    2. Select New; the item list number comes from the number sequence
    3. Enter a description
    4. Select Save
    5. Under Items, select Add, select the item number and enter the quantity
    6. Select Save
    1Item listBEAT-000001 (from the number sequence)
    2DescriptionItem list
    3Item numberBEAT-ITEM-001
    Quantity1.00 ea
    Create an item list (zoomed on the outlined fields)
    Show the full screenCreate an item list
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Setup > Items > Item list.
  2. Select New and, in the Item list field, enter an ID if one isn't created automatically, then a short description.
  3. On the Items FastTab, select Add, then select the Item number and enter the Quantity ordered.
  4. Select Dimensions to add dimension information for the item if needed.
  5. Add the list to a new sales order for the customer, or rebuild it from recent orders with Item list generation.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Item listThe ID of the item list; it can be created automatically.Microsoft Learn BEAT-000001 (from the number sequence)ItemListId
QuantityThe quantity of the item that the customer usually orders.Microsoft Learn 1.00 eaSalesQty
DescriptionA short description of the item list.Checked in Dynamics 365Weekly cafe orderDescription
Item numberThe item on the item list line.Microsoft Learn BEAT-ITEM-014ItemId

Common errors and fixes

MessageWhat to do
Changing a line on the sales order doesn't change the item list.That is expected: the list is copied to the order. Edit the list itself on this page. Microsoft Learn

Test checklist

  1. Create item list BEAT-000017 with 2 lines (24.00 ea and 12.00 ea).
  2. Create a sales order for the customer and add the item list.
  3. Check that the order has 2 lines with 24.00 and 12.00 ea.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Item listItem lists only for customers who reorder the same items, with Enable item list set on those customers.Item lists let order takers add a customer's usual items to a new order in one step; changes on the order don't flow back, so the list must be kept on this page.Maintain item lists by hand or generate them from order history?Expecting changes on a sales order to update the item list; they don't.Test: Item list fills a sales order

Number sequences

ReferenceShared or per companyNote
Item listPer companyNew records on this page take their Item list from the MCRItemListId reference; BEAT uses number sequence Acco_95. Checked in Dynamics 365

Feature management and licence

Licence or add-inOn the live system, Sales manager, Sales representative and Sales clerk can maintain 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: Lists can be edited at any time; orders already created are not changed.
If you change it laterChanging lines after an item list is copied to a sales order doesn't change the stored list; to change the list itself, edit it on this page. Microsoft Learn
Technical architect

6Technical

Menu itemMCRItemListTable Checked in Dynamics 365
FormMCRItemListTable Checked in Dynamics 365
TableMCRItemListTableShown as “Item list” in Record infoKey field: ItemListId, DescriptionChecked in Dynamics 365
Data entitiesMCRSalesProductSetEntitySales product sets Microsoft data model
Who can open itPrivilegesMaintain item lists MCRItemListTableMaintainDutiesEnable sales MCRSalesEnableMaintain sales order MCRSalesMaintain
4 security roles MCRTestUserRoleSales 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 TradeSalesManagerSales representative TradeSalesRepresentativeSales clerk TradeSalesClerkGive 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, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=MCRItemListTable
Integrate withMCRSalesProductSetEntity data entity Microsoft data model
Data migrationMCRSalesProductSetEntity (Sales product sets): the item lists on this page, loaded for each company.Load order: Load customers and released products first, because each item list line refers to an item number.Load first: Released products, CustomersMicrosoft Learn
Table definitionMCRItemListTable columns and relations Microsoft data model
Everyone

8Sources

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