| What it is | A periodic task that fills the Distinct product table for the existing products in Supply Chain Management. |
|---|---|
| What you do here | Use 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. |
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
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone1What it is and why
Functional consultant · Solution architect2Where it fits
| Business process | Develop product strategy › Define product policies |
|---|---|
| Menu path | Product information management › Periodic tasks › Warehouse Management › Populate distinct product table |
End user · Functional consultant3How 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 it | Once, before you synchronize products from Supply Chain Management to Dynamics 365 Sales for the first time. |
|---|---|
| How often | Once only. |
| What the output shows | The 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
- Go to Product information management > Periodic tasks > Warehouse Management > Populate distinct product table.
- 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.
- Run the job only once, before the first product synchronization; existing products aren't synchronized until it has completed.
- Then run the Products task in the Data integration project and check that existing sellable products appear in Sales.
Source: Microsoft Learn
Solution architect4Design impact
| Can it be undone | Nothing 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 later | Fills the Distinct product table that the product synchronization to Sales reads from. Microsoft Learn |
Technical architect5Technical
| Menu item | action:InventDistinctProductPopulator |
|---|---|
| Roles to set it up and use it | To use itInformation technology manager SysServerITManagerGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365 |
Developer6Developer
| Open it by URL | https://<your-environment>/?mi=action:InventDistinctProductPopulator |
|---|