Preload a streamlined on-hand query

Microsoft Dynamics 365 Supply Chain Management stores lots of information about your current on-hand inventory and makes it available for a wide range of purposes. However, many everyday operations and third-party integrations require just a small subset of the stored details. If the system is queried for all of them, the result can be large data sets that take time to assemble and transfer. Therefore, the Inventory Visibility service can periodically fetch and store a streamlined set of on-hand inventory data to make that optimized information continuously available. The stored on-hand inventory details are filtered based on configurable business criteria, to ensure that only the most relevant information is included. Because the filtered on-hand inventory lists are stored locally in the Inventory Visibility service and regularly updated, they support quick access, on-demand data exports, and streamlined integration with external systems.

Preloaded on-hand queries provide the following benefits:

• A cleaner view that stores an inventory summary that includes only the dimensions that are relevant to your daily business
• An inventory summary that's compatible with items that are enabled for warehouse management processes (WMS)

Important

We recommend that you use either the Preloaded onhand feature or the Inventory summary feature, but not both. If you enable both features, performance will be affected.

The Onhand index query preload results page provides a view for the On-hand Index Query Preload Results entity. Unlike the Inventory summary entity, the On-hand Index Query Preload Results entity provides an on-hand inventory list for products together with selected dimensions. Inventory Visibility syncs the preloaded summary data every 15 minutes.

Note

Like the Inventory summary feature, the Preloaded onhand feature tracks only on-hand inventory changes that occur after you turn on the feature. Data for products that haven't changed since you turned on the feature isn't synced from the inventory service cache to the Dataverse environment.

If you change the settings for a calculated measure, data on the Onhand index query preload results page isn't automatically updated until the related product data is modified.

If the Onhand index query preload results page doesn't show all the on-hand information that you expect, go to Inventory management > Periodic tasks > Inventory Visibility integration, disable the batch job, and then reenable it to do the initial push. All data will be synced to the On-hand Index Query Preload Results entity within 15 minutes. If you want to use this feature, we recommend that you turn it on before you create any on-hand changes and enable the Inventory Visibility integration batch job.

Turn on and configure preloaded on-hand queries in UI version 2

This section applies when you're using Inventory Visibility UI version 2.

To turn on and configure preloaded on-hand queries in UI version 2, follow these steps.

1. Sign in to your Power Apps environment, and open the Inventory Visibility app.

2. On the navigation pane, select Feature management.

3. On the Preloaded onhand tile, select Manage.

4. Set the Enable feature option to True.

5. In the Preload group by dimensions section, add a row for each dimension that you want to use for preloaded on-hand queries. The dimensions that you add here are used to group the preloaded on-hand data.

   • To add a row, select New onhand index query preload configuration on the toolbar. Set the Group by value field to the dimension that you want to group by, and then assign an order. Preloaded on-hand queries use only dimensions from set number 0 as group-by values. Other sets are ignored. When you've finished, select Save & Close on the toolbar.
   • To modify a row, select the Preload set number link to open the row settings, edit the fields as you require, and then select Save & Close on the toolbar.
   • To remove a row, select the Preload set number link to open the row settings, and then select Delete on the toolbar.

6. If you changed the group-by configuration, select Admin settings on the navigation pane, and then, on the Delete preloaded onhand data tile, select Manage. This step cleans up the database and makes it ready to accept your new group-by settings.

7. On the navigation pane, select Admin settings. Then, on the Update configuration tile, select Manage to update the configuration and activate your changes.

Turn on and configure preloaded on-hand queries in UI version 1

This section applies when you're using Inventory Visibility UI version 1.

To turn on and configure preloaded on-hand queries in UI version 1, follow these steps.

1. Sign in to your Power Apps environment, and open the Inventory Visibility app.
2. On the Change area menu at the bottom of the navigation pane, select Legacy UI.
3. On the navigation pane, select Configuration.
4. On the Feature Management & Settings tab, if the Preloaded onhand query results feature is already enabled, we recommend that you use the option to turn it off for now, because the cleanup process might take a long time. You'll turn the feature on again later in this procedure.
5. On the Preload Setting tab, in the Step 1: Clean up preload storage section, select Clean to clean up the database and make it ready to accept your new group-by settings.
6. In the Step 2: Set up group by values section, in the Group result by field, enter a comma-separated list of field names to group your query results by. After you have data in the preload storage database, you won't be able to change this setting until you clean the database as described in the previous step.
7. On the Feature Management & Settings tab, use the option to turn on the Preload on-hand query results feature.
8. Select Update configuration in the upper-right corner of the page to commit your changes.

Filter and browse the preloaded query

To filter and browser the preloaded query, follow these steps.

1. Sign in to your Power Apps environment, and open the Inventory Visibility app.

2. On the Change area menu at the bottom of the navigation pane, select Inventory visibility.

3. On the navigation pane, select Preloaded onhand.

4. On the Onhand index query preload results page, you can filter and browse your preloaded summary.

   • Use the Edit filters button to create a personal view that shows the rows that are important to you. These filter options let you create a wide range of views, from simple to complex. They also let you add grouped and nested conditions to the filters. For more information about how to use the advanced filter, see Edit or create personal views using advanced grid filters.
   • Because you've predefined the dimensions that are used to load summary data, the Onhand index query preload results page shows dimension-related columns. The dimensions aren't customizable. The system supports only site and location dimensions for preloaded on-hand lists. The page provides filters that are similar to the filters on the Inventory summary page. However, the dimensions are already selected.
   • The bottom of the page shows information such as 50 records (29 selected) or 50 records. This information refers to the records that are currently loaded from the Edit filters result. The text 29 selected refers to the number of records that have been selected by using the column header filters for the loaded records. There's a Load More button that you can use to load more records from Dataverse. By default, 50 records are loaded. When you select Load More, the next 1,000 available records are loaded into the view. The numbers on the Load More button indicate the number of currently loaded records and the total number of records that the Edit filters result found.

The following illustration highlights the filtering fields that are available on the Onhand index query preload results page.