In this blog, I will try to explain the new inventory value report storage. How we can configure, generate, and work with exported data.

Many of us already know but there are many people out there who are new to system, it will help them.

What is inventory value report? Inventory value report is the configurable report for inventory transactions which provide us the clear view of value and quantity. This report can be generated in different ways, and we can have multiple configurations as per our data requirements e.g. We can configuration for Transaction level data, only closing balance data, only for manufacturing related data, only for purchase related data, only for sales related data etc….

So, it all depends on our creativity and customer requirement to utilize this report in multiple ways.

This is one of the report which really helps us in doing reconciliation between finance and inventory, validating inventory valuation method and so on.

In this blog we will see following

• Configuration
• Generation process (Transaction and Total level both)
• Analysis of output data using personalization options available in D365 without exporting in excel

Configuration

Configuration has three parts General tab, Column definition and row definition. We need to define the parameters for ach tab as per requirement.

General Tab:

Column:

Row:

Generation:

Usecase-1: Transaction level

Cost management > Inquiry and reports > Inventory value storage report

View data

Uasecase-2: Total level

We need to change or create new ID with row at Total level and follow same process of generation

Analyzing of data

Use personalization for Total , group and freeze to have clear view

That’s it for this blog, hope this will help you in triggering the thoughts on utilizing this report along with different options available.

Thank you !!! Keep Reading and sharing !!!