web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Inventory value report
Microsoft Dynamics AX (Archived)

Inventory value report

(0) ShareShare
ReportReport
Posted on by Julia Julia 1,480

Hello everybody,

I'm using Microsoft Dynamics AX 2012 R2, to display the value of the inventory I use the report  "Inventory and werhouse management>Reports>Status>Inventory value>Inventory value" but on the report much information is not displayed  like the werhousen the name of products,...! is that normal, have I to do any configuration in order to display more information in this report?

Thank you very much for your help.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at

    Hi Julia

    When you run the report, you have to choose a Identification ID.

    If you go in the main table ( Right Click, view detail ) you can choose which Inventory Dimension show on the report.

    The Product Name instead you have to add a new field on InventValueReportTmpLine table and move to the report.

    The same for other needed fields.

  • venkatesh vadlamani Profile Picture
    venkatesh vadlamani 3,180 on at

    There is a setup in inventory>setup>inventory value reports . You can have many configurations over there. As mentioned by denis you can open the report and on ID selction you can do a view details and set the configuration there

  • Julia Julia Profile Picture
    Julia Julia 1,480 on at

    Thank you very much for your answers

    I choosed the warehouse dimension, the column of warehouse is apeared on the report but it's clean, no information in all the column! I don't know why, have you any idea about this?

  • Verified answer
    Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at

    Hi Julia

    As you can read in the post below, seems that warehouse is displayed on the inventory value report only if the Financial Inventory box is checked in the item’s Storage Dimension Group

    community.dynamics.com/.../105435.aspx

  • munsif Profile Picture
    munsif 1,536 on at

    hi denis, i have question for the same, i want to display item name in same report, for this i have added new field in inventvalueReportTmpLine, but how to reference in Dp class,

  • Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at

    Hi

    Check the InventValueReportDP class and figure out :

    1- The Query InventValueReportTmpLine have the new field?

    2- Check the getInventValueReportTmpLine method and add the new field.

    To be honest, I don't know very well this report, but seems is present an Group by, so you have to understand how to handle the Itemname.

  • Mhmd_halem Profile Picture
    Mhmd_halem 35 on at

    Mr.Munsif have you found any solution to show the item name in the report?

  • Suggested answer
    Sagar Dedhia Profile Picture
    Sagar Dedhia 50 on at

    A quick solution that i have implemented is as follows

    1.  Add itemname field in InventValueReportTmpLine Table.
    2.  Modify insert() menthod of InventValueReportTmpLine  table. Fetch the item name before Super() method.
    3.  Modify getInventValueReportTmpLine() method of InventValueReportDP class. Add itemname field in #GroupByFields Macro.  (You can add at the end of the macro or after resourceid field.)
    4.  Call the newly added field in the report.

    Similarly you can add other fields which can be derived from already existing fields of the InventValueReportTmpLine  table.

     

    Hope this helps.

  • ali026 Profile Picture
    ali026 30 on at

    Hi

    To display additional information like product name, search name  on invent value report  need to customize on 2 classes.

    Add a new filed in InventValueReportTmpLine table and start the customization. I have added NameAlias filed.

    1. \Classes\InventValueReportPopulateItem\findReportLine here line no:13, I added below code

       tmpReportLine.ResourceId        = _inventTable.ItemId;

       tmpReportLine.NameAlias         = InventTable::find(tmpReportLine.ResourceId).NameAlias;

    2. \Classes\InventValueReportDP\getInventValueReportTmpLine Here we need to add our new filed in GroupByFields Macro

         #LOCALMACRO.GroupByFields

           TransactionId,

           ResourceType,

           ResourceGroupId,

           ResourceId,

           configId,

           InventSizeId,

           InventColorId,

           InventStyleId,

           InventSiteId,

           InventLocationId,

           WMSLocationId,

           WMSPalletId,

           InventBatchId,

           InventSerialId,

           // <GEERU>

           InventGTDId_RU,

           InventProfileId_RU,

           InventOwnerId_RU,

           // </GEERU>

           LineType,

           TransBeginTime,

           Voucher,

           TransDate,

           InventTransId,

           ReferenceCategory,

           Reference,

           NameAlias //added here

    #ENDMACRO

    3. Finally add NameAlias field inventvalue report design. Now you can able the see your new filed on invent value report.

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans