Inventory value report storage

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
End users by admins, makers, or analysts This feature is released. Sep 6, 2019 This feature is released. Oct 8, 2019

Business value

This new way of executing the inventory value report is beneficial in cases where the output contains a large number of lines. For example, requesting the inventory ending balance by item, site, and warehouse in a scenario with 50,000 items and 300 stores would yield a very long report, where data is difficult to review. Being able to sort and filter the results, or to export the results to an external system, makes the inventory value report results faster and easier to navigate.

Feature details

A new inventory value report storage capability has been introduced. When you initiate a new execution of the inventory value report, you will have to provide a unique name for the specific execution, and the results of the report generation will be stored under this name. This eliminates the need for running multiple inventory value reports for the same period.

The output of the report execution will be accessible in the inventory value report storage details form. This form dynamically adjusts columns and aggregates balances depending on the inventory value report layout configured. All your current inventory value report configurations can be used.

A new inventory value report data entity has also been introduced. This enables you to export the output of a specific, named inventory value report run to any format supported by data management.