Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Quantity is Zero but Value not zero in the inventory valuation report

(0) ShareShare
ReportReport
Posted on by 225

I am on NAV 2009 R2. Using AVCo setup bu item & location. I am having this problem were quantity is Zero but Value not zero in the inventory valuation report. I got a hot fix that was published on the customer source around May 2013. I did make the modifications but I still dont know what to do next - how does the fix work? After applying the changes in codeunit 22 what do i do. Does the fix correct historical data or it prevents future re-occurrence of the problem.

Has anybody used this hot fix out there.

*This post is locked for comments

  • Mutsa Profile Picture
    Mutsa 225 on at
    RE: Quantity is Zero but Value not zero in the inventory valuation report

    Thank you so much Chris and the rest of the team. I am anwered and I am enlightened in a lot of things as I read through your input. Thank you

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Quantity is Zero but Value not zero in the inventory valuation report

    Hi,

    The issue reported on KB2845184 is due when entries of an average cost item have been fixed applied by using the item application worksheet. After the application worksheet been used, the valuation date of the outbound item ledger entries has an incorrect valuation date.

    The fix, will avoid next time you use the item application worksheet to generated an incorrect valuation date.

    The issue was "The Valuation Date (outbnd) is not updated when new Valuation Date (inbnd) is an earlier date and Posting Date = Valuation Date.

    The solution was Valuation Date (outbnd) is also updated to earlier dates when the application is fixed between ILEs to ensure that Valuation Dates are in sync between inbnd and outbnd which is essential to calculate the correct unit cost for average.

    To correct the data, customers experiencing the problems caused by this issue can get into correct state by redoing the fixed applications in application worksheet after this fix is implemented.

    Hope this helps. Then again, having zero quantity and value on the inventory valuation report might have many reasons so even if you merge the KB the issue could 're-appear' due to other reasons. The same counts for options to rectify the existing data.

    Best regards, Christiaan.

  • DMV Profile Picture
    DMV 1,040 on at
    RE: Quantity is Zero but Value not zero in the inventory valuation report

    So, is there any way to fix existing items with this issue?  The fix going forward is fine but, what do we do about the ones sitting on the Valuation report that are wrong?

  • Mutsa Profile Picture
    Mutsa 225 on at
    RE: Quantity is Zero but Value not zero in the inventory valuation report

    Thank you for your  help. The AVCO setup has always been set by Item, Location and Variant.

    And also you said i should give you the ID of the hotfix I reffered to; the ID is 2845184

    Thank you.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Quantity is Zero but Value not zero in the inventory valuation report

    Hi,

    In the past has the Average Cost Calc. type always been by Item&Location&Variant? Or has it also been by Item. You can find out this information from the Accounting Periods.

    When this is the case, and you run Inventory Valuation report by Location you might run into a situation where quantity is zero but a value is left (not in total but against certain locations). This even counts when at present the Average Cost Calc. type is by Location.

    None of the hotfixes will address this situation. Additionally as detailed any new hotfixes will likely only 'correct' a data issue on new transactions. You might also need to 'reopen' adjust cost to have the batch job re-visit pending adjustment but this time with the new hotfix merged. How this is done depends on various factors, but further details are described in the Inventory Costing Error Detection Whitepaper.

    mbs.microsoft.com/.../NAVCostingErrorDetectionWP

    Could you detail the ID of the hotfix you referenced?

    Best regards, Christiaan.

  • Alex Chow Profile Picture
    Alex Chow 4,481 on at
    RE: Quantity is Zero but Value not zero in the inventory valuation report

    It'll only address this for transactions going forward.

    This article may explain what's going on:

    www.dynamicsnavconsultant.com/.../why-you-have-negative-inventory-value-with-0-quantity-%E2%80%93-navision-37b-to-navision-50

  • X. GARONNAT Profile Picture
    X. GARONNAT on at
    RE: Quantity is Zero but Value not zero in the inventory valuation report

    You should look at KB2781950 which is a rollup dedicated to costing issues with Nav 2009.

    mbs2.microsoft.com/.../KBDisplay.aspx

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans