BeyondERP.Newsletter
Menu

Setup step on the Item list generation page · Sales and marketing

Run item list generation

Use this periodic task to build item lists per customer based on a number of recent days or orders and a minimum quantity.

Business process
Enter sales orders
Menu item
action:MCRItemListGeneration
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 periodic job that creates or updates a customer's item list from the items the customer ordered recently.
What you do hereUse this periodic task to build item lists per customer based on a number of recent days or orders and a minimum quantity.
ExampleFor example, BEAT runs the job for customer BEAT-000456 on Number of days with value 30 and Minimum quantity 5, and the item list gets the 7 items the cafe ordered at least 5 of in the last 30 days.
Item list generation 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 › Items › Item list generation
Set up firstAll customers Microsoft Learn
Used next byItem list Microsoft Learn
Related pagesItem list Microsoft Learn
In this process Run Post sales journal for agreed drafts · Set up supplementary item groups for items
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.

When to run it

When to run itAfter customers have enough order history, and again when their buying pattern changes (for example each quarter).
How oftenAs needed per customer
Batch settingsRun from the dialog
What the output showsItem lists on the Item list page

Source: Microsoft Learn

Setup steps on this page

Run item list generation

Use this periodic task to build item lists per customer based on a number of recent days or orders and a minimum quantity.

Steps from Microsoft

  1. Open the customer and, on the Sales order defaults FastTab, select the Enable item list check box.
  2. Go to Sales and marketing > Setup > Items > Item list generation.
  3. On the General tab, choose whether the list is based on a number of days or a number of orders, and enter it in the Value field.
  4. In the Minimum quantity field, enter the smallest quantity an order line needs to be included.
  5. Select the customer account, select OK, and then review the result on Item list.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Number of daysBuilds the list from sales orders created within the number of days you enter.Microsoft Learn 30
Number of ordersBuilds the list from the number of previous orders you enter.Microsoft Learn 4
Minimum quantityThe smallest quantity an order line must have to be included in the list.Microsoft Learn 5.00

Common errors and fixes

MessageWhat to do
The job runs but the customer's item list stays empty.Select Enable item list on the customer's Sales order defaults FastTab, and check that order lines reach the Minimum quantity in the chosen days or orders. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run item list generationRun per customer on a number of days that covers one buying cycle (for example 30), with a minimum quantity that leaves out one-off small lines.The list is built from orders within the days or orders you enter, and only lines at or above the minimum quantity are added, so these two values decide which items appear.Base item lists on a number of days or a number of orders?Running it for a customer without Enable item list on the Sales order defaults FastTab.Test: Job builds the list from recent orders

Feature management and licence

Licence or add-inOn the live system, Sales manager, Sales clerk and Sales representative can use this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyThe job builds or updates the item list of the customers you select in the current company. Microsoft Learn
Can it be undoneReversible: The job changes only item lists, which can be edited afterwards.
If you change it laterRerunning the job rebuilds the list from recent orders, so manual changes to the list can be replaced. Microsoft Learn
Technical architect

6Technical

Menu itemaction:MCRItemListGeneration Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Data entitiesMCRSalesProductSetEntitySales product sets Microsoft data model
Roles to set it up and use itTo use itSales manager TradeSalesManagerSales clerk TradeSalesClerkSales representative TradeSalesRepresentativeGive people one of these roles. On this system, 3 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=action:MCRItemListGeneration
Integrate withMCRSalesProductSetEntity data entity Microsoft data model
Data migrationMCRSalesProductSetEntity Load item lists directly instead of running the job when history isn't migrated.Load order: Run the job after sales history exists, or load item lists through the entity after customers and released products.Load first: Customers, Released productsMicrosoft Learn
Everyone

8Sources

To cite this step: SM-SETA-060, Run item list generation. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SM-SETA-060