Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Inventory Value Report - Zero Qty, With Beginning Inventory Amount

Posted on by 140

Hi,

I am having an issue in inventory value report in AX 2012.

The issue is that the report shows an inventory value for item 'A' without qty.

This happens for the report for any period.

I tried to run the report for a period when even transactions are not started in AX. Here also report shown same amount an beginning inventory value.

Please suggest.

Nisheet

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory Value Report - Zero Qty, With Beginning Inventory Amount

    Hello Nisheet,

    Can you share more details of what you identified in regards to the quarantine orders?

    Do you mean that only those items show a value where quarantine orders have been created?

    Can you check the inventory transactions for one of the items that shows the value but no quantity?

    Can you possibly share some details of those transactions especially the quantity, direction, cost amount and cost adjustment recorded?

    Many thanks and best regards,

    Ludwig

  • Nisheet Profile Picture
    Nisheet 140 on at
    RE: Inventory Value Report - Zero Qty, With Beginning Inventory Amount

    Hi,

    Thanks Ludwig.

    Inventory recalculation has already been done. After recalculation also these values appear.

    Unable to find out this value in inventtrans also.

    This issue comes mostly for the item where ever anytime there will we a quarantine order.

    Nisheet

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory Value Report - Zero Qty, With Beginning Inventory Amount

    Hello Nisheet,

    Depending on the inventory valuation principle that you have setup this can happen. Usually those negative amounts disappear at the time you run an inventory recalculation/close. Have you already done that? If you have not, I would recommend running an inventory recalculation and then starting the inventory value report again. If you still see negative amounts without quantity, please share more information.

    Many thanks,

    Ludwig

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,645 on at
    RE: Inventory Value Report - Zero Qty, With Beginning Inventory Amount

    Can you share screenshot etc. Do you have any other standard environment where u have this issue? If no, leverage developer to troubleshoot this.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans