Edit

Inventory aging report storage

  • Article

In Microsoft Dynamics 365 Supply Chain Management, you can run an Inventory aging report storage report and make the output available as a form and a chart. In the form, columns and aggregate balances are dynamically adjusted, depending on the layout that is configured. The chart provides a visual overview that supports filtering and lets you drill down into details. Additionally, a data entity that is named Inventory aging report lets you export the results of an Inventory aging report storage report run to a format such as a Microsoft Excel file or a PDF file.

This method of running an Inventory aging report storage report is helpful in cases where the output contains many lines. For example, the output will contain many lines if you have 50,000 items and 300 stores that are created as warehouses, and you request inventory aging by item, site, and warehouse.

Turn the Inventory value storage report feature on or off

To use this feature, it must be turned on for your system. As of Supply Chain Management version 10.0.32, it's turned on by default. As of Supply Chain Management version 10.0.36, the feature is mandatory and can't be turned off. If you're running a version older than 10.0.36, then admins can turn this functionality on or off by searching for the Inventory aging report storage feature in the Feature management workspace.

Run an Inventory aging report storage

  1. Go to Cost management > Inquiries and reports > Inventory aging report storage.

  2. Select New.

  3. In the Process Identifier – Name field, enter a unique name for the report.

  4. Select the Identification – ID report, and filter it as you require.

    Report execution is always done in a batch job.

  5. After the batch job is completed, the output is shown on the Inventory aging report storage page.

  6. To view the output as a form that has a traditional grid layout, select View details. To view the output as an aggregated chart, select View chart.

    Note

    The form won't include subtotals that are defined in the report layout.

The Inventory aging report data entity lets you export the output of an Inventory aging report storage report by applying a filter for the Process Identifier – Name field to any format that Data management supports.