Compare item price 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	Feb 1, 2020	Apr 3, 2020

Business value

This new way of executing the Compare item price report is useful in cases where the output contains a large number of lines. For example, requesting a comparison of the current active standard cost against next year's pending standard cost for 60,000 items 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 report faster and easier to navigate.

Feature details

We are introducing new functionality for comparing item price storage. When you execute the "Compare item price" report, you must provide a unique name for the specific execution, and the results of the report will be stored under this name.

The output will be accessible on the Compare item price storage page. This page dynamically adjusts columns and aggregates balances depending on the configuration made by the user. You can add a filter so the items with the largest net change in price are listed at the top of the grid. A drill-through function provides the ability to see the net change by cost group type or cost group. In case a specific price requires further analysis, a link to the actual cost calculation is available.

We are also introducing a new "Compare item price" data entity. This data entity enables you to export the output of a specific, named Compare item price report to any format supported by data management, making the data available for use with external applications.

See also

Compare item price storage (docs)