Analyze warehouse material movement through process mining

The Microsoft Power Automate Process Mining feature offers task mining and process mining capabilities to help you better understand your business processes, so that you can optimize them. Dynamics 365 Supply Chain Management offers a Warehouse material movement analysis template for the Power Automate Process Mining. Use this template to create processes that help warehouse and operations managers gain insights into the material flow in the warehouse. It helps find inefficiencies that you can remove to improve the performance of the warehouse.

The Warehouse material movement analysis template uses warehousing, product, and transactional data that's stored in your system. It lets you visualize and analyze material movements on the warehouse floor, based on closed warehouse work records. In process mining terminology, each warehouse work record corresponds to a case, and each pick or put work line corresponds to an event. Depending on your configuration, an activity can be any one of the following items:

• Warehouse location
• Warehouse location profile
• Warehouse zone

For more information about Power Automate Process Mining, see Overview of Power Automate Process Mining.

This article describes what's included in the Warehouse material movement analysis template, and explains how to deploy and access Power Automate Process Mining processes.

Prerequisites

The Warehouse material movement analysis template for Power Automate Process Mining has the following prerequisites:

• You're running Supply Chain Management version 10.0.35 or later.
• Your Supply Chain Management environment must be linked to a Dataverse environment.
• The user who deploys the process in Power Automate Process Mining must have the Warehouse manager, Warehouse planner, and/or System administrator role.
• The Supply Chain Manager user who deploys the process in Power Automate Process Mining must also be configured as a user in the linked Dataverse environment. To deploy the process, a user must have the Environment maker and/or System administrator role. After the process is deployed, it can be shared with other users. Those users automatically get the permissions required to use the process.

Deploy a new Power Automate Process Mining process based on the template

Set up as many processes as you need, each with a different name and filters. Follow these steps to deploy a Warehouse material movement analysis process.

1. Go to Warehouse management > Setup > Process mining > Warehouse material movement process configuration.

2. On the Action Pane, select Deploy process to open the deployment wizard.

3. Follow the on-screen instructions. Provide the following information:

   • Process name – Enter a name for the process. Include the legal entity (company) and other filter information in the name, so you can easily identify the process later.
   • Company – Select the legal entity that you want to use this process to analyze. Only warehouse work records in the selected legal entity are included in Power Automate Process Mining process.
   • Number of months to load – Specify the number of months to load at a time. This filter helps prevent excessive or irrelevant data from being loaded into Power Automate Process Mining. Only warehouse work records that were closed after the specified time threshold are included in Power Automate Process Mining process.
   • Activity – Specify which column Power Automate Process Mining should treat as an activity. To learn more about process mining terminology, see Glossary in Power Automate Process Mining.

   Note

   Try to limit the data by optimizing the Number of months to load filter value. Power Query Online includes several threshold checks. Therefore, if you try to load too much data, time-out or quota violation exceptions might occur, and the system might fail. Load less than 25 months of data into the Warehouse material movement analysis process and ensure that the total number of events in the process is less than 4 million.

When you complete the deployment wizard, the following actions occur:

• Initial data is loaded. The system loads 200 cases into the staging table. In the context of the Warehouse material movement analysis process template, each case corresponds to a single closed warehouse work record. Most likely, many more than 200 records meet the filtering criteria set in the deployment wizard. By loading only 200 cases, the system enhances performance and the user experience, so that you can access the visualization more quickly.
• You're prompted to complete the deployment process. Power Automate Process Mining user interface (UI) opens on a new tab in your browser. You might be asked to sign in. Power Automate Process Mining uses your credentials to read data from Supply Chain Management. Don't close the page right away. Otherwise, you interrupt the deployment. You don't have to do anything else on the page. Power Automate Process Mining lets you know when deployment is completed.

Refresh data in the staging table and Power Automate Process Mining

As mentioned earlier, after you deploy a new process, the system loads an initial set of 200 cases into the staging table and loads that data into Power Automate Process Mining. This behavior lets you get started quickly. However, to work with your full data set, you must refresh the staging table and Power Automate Process Mining. This section describes how to manually trigger this process.

Follow these steps to manually refresh data in the staging table and Power Automate Process Mining.

1. Go to Warehouse management > Setup > Process mining > Warehouse material movement process configuration.
2. In the list pane, select the process to refresh the data for.
3. On the Action Pane, select Refresh staging table. The batch job that's responsible for refreshing the staging table runs every five minutes. The next time that it runs, it picks up the request to refresh the table. It then loads all the data that matches the filters specified during deployment.
4. On the General FastTab, the Last staging table refresh field is updated to indicate that the table is refreshed. However, the new data isn't available in Power Automate Process Mining until you refresh it there. Select View process details on the Action Pane, and then select Refresh data in Power Automate Process Mining.

A staging table cleanup batch job runs daily and removes any records from the staging table that no longer satisfy the filter criteria. For example, it removes any records that are now too old.

Configure warehouse material movement processes

After you deploy a process, you can configure it at any time by following these steps.

1. Go to Warehouse management > Setup > Process mining > Warehouse material movement process configuration.

2. In the list pane, select the process to refresh the data for.

3. On the General FastTab, set the following fields:

   • Automatic refresh recurrence – Select how often the system should update the data table (None, Once per day, or Once per week). Although this update refreshes data in the staging table, it doesn't automatically load that data into Power Automate Process Mining. To set Power Automate Process Mining to periodically load this data from the staging table, select View process details on the Action Pane. Then, in Power Automate Process Mining, select Schedule refresh, and select a refresh schedule. You can also manually refresh the data in Power Automate Process Mining by selecting Refresh data in Power Automate Process Mining.
   • Last staging table refresh – This read-only field shows the date and time when the staging table was last refreshed.
   • Enforce offline hours – Set this option to Yes to prevent the system from refreshing the staging table during the specified hours. This option can be useful if you want to avoid refreshing the table during peak hours.

4. On the Process parameters FastTab, review the following fields:

   • Legal entity – This read-only field shows the legal entity specified during deployment.
   • Number of months to load – This read-only field shows the number of months to load, as specified during deployment.
   • Activity – This read-only field shows the activity specified during deployment.

   The Processing log FastTab shows a history of data refresh and cleanup operations. This information can be useful during troubleshooting.

Access the warehouse material movement analysis process

You can access the warehouse material movement analysis process from both Supply Chain Management and Power Automate Process Mining UI.

To access the process from Supply Chain Management, follow these steps:

1. Go to Warehouse management > Enquiries and reports > Warehouse performance analysis > Warehouse material movement analysis.

2. In the Process name field, select the name of the process to view. The list includes only processes that meet both the following conditions:

   • The process is ready for analysis. (In other words, it has been deployed and analyzed in Power Automate Process Mining.)
   • The current user can access the process. (In other words, the current user created or shared the process.)

3. The Power BI report for your selected process opens. You can interact with the report to view the process and analyze it in various ways.

4. To view the selected process in Power Automate Process Mining, select View process report on the Action Pane. Power Automate Process Mining UI opens on a new tab in your browser.

5. To perform advanced process analysis, assess process behavior with business rules, detect rework, and build your own business metrics, select Open Power Automate Process Mining to open process in Power Automate Process Mining desktop app. For more information about its capabilities, see Power Automate Process Mining overview.

FAQ

Why don't I see all the events (work lines) and cases (work headers) that I expect in Power Automate Process Mining process?

Several reasons might prevent you from seeing all the events and cases that you expect. Check the following items:

• Confirm that the staging table is recently refreshed. Go to Warehouse management > Setup > Process mining > Warehouse material movement process configuration, and review the Last staging table refresh field on the General tab and the information on the Processing log FastTab.
• Confirm that the warehouse work that you expect to see in the process is closed. The warehouse work closed date and legal entity (company) should meet the process filtering criteria that are specified during process deployment. You can check these details on the Warehouse material movement process configuration page.
• Confirm that Power Automate Process Mining process is recently refreshed. For information about how to view refresh information, and how to set up schedules to automatically refresh the staging table and Power Automate Process Mining process, see the Configure the warehouse material movement process section of this article.

Why don't I see the process that I'm looking for on the Warehouse material movement analysis page?

Several reasons might prevent you from seeing a process on the Warehouse material movement analysis page. Check the following items:

• Confirm that you have access to the process. Usually, to view a process, you must have created it yourself, or the creator must share it with you. To confirm that you have access, sign in to Power Automate Process Mining in Power Automate by using the same user account, and determine whether you can access the process.
• Confirm that the process is deployed and ready for analysis. The Warehouse material movement analysis page shows only processes that are ready for analysis. If the process is still being deployed, it might not yet appear on the page. To confirm that the process is ready for analysis, try to open the Power BI report for the process in Power Automate Process Mining UI.

Why do I receive an error during process deployment?

The system performs several checks while it's provisioning a process. Most failures occur either because the Supply Chain Management user account that's used isn't registered in Dataverse or because the account doesn't have the required privileges. If deployment takes a long time (about four hours), you're probably exceeding the threshold limits for Power Automate Process Mining integration. Consider changing the filters to reduce the number of events that are loaded into Power Automate Process Mining. You can typically lower the Number of months to load filter value.