BeyondERP.Newsletter
Menu

Job page · Product information management

Populate distinct product table

A periodic task that fills the Distinct product table for the existing products in Supply Chain Management.

Business process
Define product policies
Menu item
action:InventDistinctProductPopulator
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic task that fills the Distinct product table for the existing products in Supply Chain Management.
What you do hereUse this task to fill the Distinct product table before products are synchronised from Supply Chain Management to Dynamics 365 Sales for the first time, because existing products are not synchronised until the job is completed.
Functional consultant · Solution architect

2Where it fits

Business processDevelop product strategy › Define product policies
Menu pathProduct information management › Periodic tasks › Warehouse Management › Populate distinct product table
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 itOnce, before you synchronize products from Supply Chain Management to Dynamics 365 Sales for the first time.
How oftenOnce only.
What the output showsThe Distinct product table is filled for existing products, so they can be picked up by the Sellable released products entity. If existing products still don't reach Sales, check the price lists, units and value maps in the integration project.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Product information management > Periodic tasks > Warehouse Management > Populate distinct product table.
  2. Make sure the Products (Supply Chain Management to Sales) - Direct template is set up and price lists exist in Sales for every product sales currency.
  3. Run the job only once, before the first product synchronization; existing products aren't synchronized until it has completed.
  4. Then run the Products task in the Data integration project and check that existing sellable products appear in Sales.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The job only fills a helper table for synchronization; it doesn't change products. It doesn't need to run again. Microsoft Learn
If you change it laterFills the Distinct product table that the product synchronization to Sales reads from. Microsoft Learn
Technical architect

5Technical

Menu itemaction:InventDistinctProductPopulator
Roles to set it up and use itTo use itInformation technology manager SysServerITManagerGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=action:InventDistinctProductPopulator
Everyone

7Sources