Inventory Visibility – Modify OnHand Index with new Set number

I`ve already posted about Inventory visibility here.

In the onHand response, the data was grouped by Site & Location.

The new addition was to also get the onHand details for Batch Id.

The Site & location are based on the OnHand Index configurations and it doesn`t allow us to add a new field in the ‘Set Number’ 0.

So what is the solution?

I tried added a new Set Number 3 for capturing ‘BatchId’

But upon updating the configuration, it threw the below error.

correlation-id: 7ca01787-a86d-479f-96d6-61903c827a63, Request failed with status code 500, Configuration update failed due to ConfigurationValidationFailureException: Configuration validation failed: When truncated hierarchy for WHS items is enabled, Index hierarchy configuration with SetNumber 3 cannot contain dimensions including wmslocationid, licenseplateid, batchid, serialid. Please remove these dimensions from your index hierarchy configuration or contact Microsoft Customer Service and Support to disable truncated hierarchy for WHS items., {"error":{"namespace":"InventoryService","code":"ConfigurationUpdateFailureException","message":"Configuration update failed due to ConfigurationValidationFailureException: Configuration validation failed: When truncated hierarchy for WHS items is enabled, Index hierarchy configuration with SetNumber 3 cannot contain dimensions including wmslocationid, licenseplateid, batchid, serialid. Please remove these dimensions from your index hierarchy configuration or contact Microsoft Customer Service and Support to disable truncated hierarchy for WHS items."

After lots of struggle, I found it is in the UI version 2 of Inventory Visibility. Mine was using Version 1.

How to find which version I am using?

The version was mapped to 1 before my changes. Click on the ‘Configuration entity version’ and enter either 1 or 2.

If the change was made from 1 to 2, then the settings has to be migrated . Follow the below steps.

1. In Power Apps, open the Inventory Visibility app.
2. On the navigation pane, select Admin settings.
3. On the Migrate entities to V2 tile, select Manage.
4. In the dialog box that appears, enter the credentials that you used when you installed the Inventory Visibility service, and then select Login.
5. Enter the App registration details which were used while installing Inventory Visibility .
6. The system copies your existing settings from UI version 1 to UI version 2.

Job status will show the status of the migration.

Once this is done, Go to ‘Feature Management’ -> ‘Advanced warehouse settings’

and set the below flag ‘Truncate unused dimensions’ to No.

Now try updating the configuration for the new Batch Index and it will be successful.

In my next post, I will explain about the API which will be used to get the response with Site/Location/BatchId .

Original Post https://anithasantosh.wordpress.com/2025/07/23/inventory-visibility-modify-onhand-index-with-new-set-number/