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”

Date time custom formats

Sometime we have to deal with custom date formats, scenarios like you want to append any custom date format in the file name. In such case we can use DateTime.ParseExact() method through .NET Interop:

Ax example can be :

System.Globalization.CultureInfo culture
    = System.Globalization.CultureInfo::get_InvariantCulture();

utcDateTime dt = System.DateTime::ParseExact(
                            '10/17/2014 0:00',
                            'MM/dd/yyyy H:mm',
                            culture);

Parameters details about DateTime.ParseExact():

s String

A string that contains a date and time to convert.

format String

A format specifier that defines the required format of s. For more information, see the Remarks section.

provider IFormatProvider

An object that supplies culture-specific format information about s.

Returns

DateTime

An object that is equivalent to the date and time contained in s, as specified by format and provider.

Abort an executing batch job

Sometimes canceling a batch job can take a long time then there is an option for abort the batch job for system administrator or batch job manager role. This provides a much faster mechanism to cancel a long running job that is impacting system usage elsewhere.

1. Go to System administration > Inquiries > Batch jobs.
2. Select a batch job that has a Status of Canceling.
3. Switch to enhanced form
4. On the Batch tasks tab, select Abort on the task, and then select OK.