web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 no qty but show inventory value

(0) ShareShare
ReportReport
Posted on by Dexin 452

Hi Guys,

I wanna to ask, why is the inventory value report show inventory value without inventory qty?

I gen the inventory value report, report show me a inventory value but no inventory qty.

How can it happen and how to resolve this

IVR.png

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory Value report no qty but show inventory value

    Hello Dexin,

    Can you have a look at the following post and try to execute similar steps?

    ramdynamicsax.wordpress.com/.../removing-the-financial-cost-amount-for-items-with-zero-stockinventory-in-ms-dynamics-ax-2009

    Best regards,

    Ludwig

  • Dexin Profile Picture
    Dexin 452 on at
    RE: Inventory Value report no qty but show inventory value

    I did tried both of your suggestion

    1. Both the inventory counting and inventory closing adjustment couldn't allow to to adjust the inventory cost for no on-hand qty

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AX Inventory Value report no qty but show inventory value

    Hello Dexin,

    I see.

    The only other thing that I can imagine is posting a inventory counting journal for a quantity of 0.

    Alternatively, try to make use of the adjustment functionality in the inventory closing and adjustment form, which should become available with the inventory close and that allows you to modify the value.

    Best regards,

    Ludwig

  • Dexin Profile Picture
    Dexin 452 on at
    RE: AX Inventory Value report no qty but show inventory value

    Yes, i did done by inventory closing and recalculation but can't get ride of the figure. Anywhere to get ride of the figure?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AX Inventory Value report no qty but show inventory value

    Hello Dexin,

    Have you already run an inventory recalculation for those items?

    Best regards,

    Ludwig

  • Dexin Profile Picture
    Dexin 452 on at
    RE: AX Inventory Value report no qty but show inventory value

    Guys,

    Initially i am activating my inventory cost by site and warehouse.

    Lastly i have activated the financial cost by Site, Warehouse and by batch no.

    As a result, when i view my inventory value report by site, warehouse and batch, i can inventories have on physical qty but with inventory value (positive and negative value)

    Please refer to below:

    6253.inventory-value.png

    Anywhere to zerorize the inventory value for those inventory that with zero qty

  • Dexin Profile Picture
    Dexin 452 on at
    RE: AX Inventory Value report no qty but show inventory value

    Hi all,

    Thank you so much for sharing your valuable information.

    I manage to sort out the root cause.

    Actually the issue is explainable as below:

    Storage dimension = Financially for Site and Warehouse

    Tracking dimension = Financial marked for batch control

    1. Purchase FG0001 at difference costing at different batch no

    2. Issue out the is not sequential batch no, system will base on the FIFO method to allocate the cost, 

    ITL.png

  • MATTGUO Profile Picture
    MATTGUO 22,336 Moderator on at
    RE: AX Inventory Value report no qty but show inventory value

    Hi Dexin,

    Could you please show your the screenshot of tracking and storage dimension groups?

    Do you use the inventory model of moving average or weighted avg. date?

    If so, my screenshot can show one of the reasons.

    2248.snipaste_5F00_20190103_5F00_103343.png

    This post talked a lot about it: https://community.dynamics.com/ax/f/33/t/229915?pi61711=1#responses

  • Dexin Profile Picture
    Dexin 452 on at
    RE: AX Inventory Value report no qty but show inventory value

    Yes, I do activate financial cost by batch. What is the impact for this?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AX Inventory Value report no qty but show inventory value

    Hi,

    In addition, do you track financial inventory values at the batch level?

    Can you double check that in your tracking dimension group form?

    Best regards,

    Ludwig

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
KP-31070522-0 Profile Picture

KP-31070522-0 3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans