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

Notifications

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 - InventBatchID blank?

(0) ShareShare
ReportReport
Posted on by Community Member

Hi all, so I encounter a problem where my Inventory value report doesn't show any batch number,

I've check the configuration and the batch number already checked in inventory dimension (Inventory Management / Setup / Inventory / Inventory Value Reports).

inventdimreport.png

Is there config that maybe missing?

In the (Product Information Management / Setup / Dimension Group / Tracking Dimension Group), the Financial Inventory is not checked, is it cause the batch number not showing in Inventory Value report problem? since the checkbox already disabled and I can't test it.

tracking-dim-setup.png

Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Fredrik Sætre Profile Picture
    Fredrik Sætre 12,644 on at

    Yes.

    Inventory value is only posted at the level of details based on the financial inventory.

    You can not change this once an item has transactions... You need to create a new item.

    If you need to change it for an item, then do as this bloggpost suggest.

    [View:https://blogs.msdn.microsoft.com/axsupport/2015/10/01/how-to-change-the-storage-dimension-group-on-items-with-existing-inventory-transactions/]

  • Verified answer
    Fredrik Sætre Profile Picture
    Fredrik Sætre 12,644 on at

    You can not simply activate this parameter and then run the report. You would need transactions posted with this settings on the item.

    So to test it you need a new item.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Ahau,

    Frederik is completely right. Yet what I want to ask is why respectively who in your company need to track and reconcile inventory values at the batch level? Most corporate financial controllers that I know control inventory values at the site and (at best) at the warehouse level. So I am just wondering why this detailled level is needed in your case? Do you have some specific analysis / reporting requirements? Would be great if you could let us know to satisfy my curiosity :-)

    Many thanks and best regards,

    Ludwig

  • Fredrik Sætre Profile Picture
    Fredrik Sætre 12,644 on at

    Yes... It does up the level of data granularity in inventSum and might slow down some processes and reports like on hand inventory and such.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans