Stock/Inventory Value Storage report

There are two types of inventory value report: Inventory/stock value (the standard report) and Inventory/Stock value report storage. this blog is about Inventory Value report storage and how can we used data management to export data into file.

The Inventory/Stock value report storage report provides output either as an interactive page in Microsoft Dynamics 365 Supply Chain Management or as an exported document in one of several formats.

When you view the report in your browser, columns and aggregate balances are dynamically adjusted, depending on the layout that you’ve configured. You can sort the results, filter them, drill down into the data, and more.

Report results are stored in the Inventory/Stock value report storage data entity. Therefore, you can filter and export the results to a format such as comma-separated values (CSV) or Microsoft Excel format.

The Inventory/Stock value report storage report is helpful when the output contains many lines. 

To access menu, navigate to Cost management -> Inquiries and reports -> Inventory/Stock value report storage.

Click “New” button on Stock value report storage form and enter execution name and other search parameters.

You can schedule the batch job and monitory the progress

Once the execution is completed, we can create export data management project for entity “Inventory value report storage”

select the filter in data management and define execution name like for this examples “SVR-Feb01” is used.

Execute the data management project and download the stock value report as file.

Change default “Purpose” of Address/Contact in D365FO

I was exploring how we can change the default purpose of Address or Contact, by default the purpose is “BUSINESS” and i was having the requirement to default it to “INVOICE”. Unfortunately i did not find any functional way, i was hoping this should be configuration somewhere to change it.

regardless i have to debug the code and produce technical solution.

Luckily there is a class LogisticsLocationEntity exists and it has “delegate” that allows subscribers to write custom defaulting logics

i did check if there are any existing references of the delegate and happy to see some examples.

after small study i was able to find existing example, so basically the defaulting logic is working based on Table Id and i can see the existing implementation of subscriber class “LogisticsLocationEntityAppUtil”