Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Inventory valuation in minus

Posted on by 47

Hi all,

We have registered a production of shrimps in NAV in June, which was then sold in July. Only just now, we have found out that for some reason the output on the shrimps has a sales and cost amount of 0 despite there's close to zero remaining of the item and it's clearly shown that all of the produced shrimps have been shipped and invoiced - with an amount. We cannot ship and invoice without item tracking and there's only the one output of shrimps to use as tracking

We're not sure what has gone wrong or how to fix it because in our inventory valuation, those shrimps now show up as -1000 kg and with a negative value as well, which is definitely wrong as we have 100kg left of product as of today.

Would anyone be able to guess at what has gone wrong? And much more importantly - how to fix it? I've attached a screenshot of the item ledger entries for the shrimpSk_E600_rmbillede-2022_2D00_08_2D00_26-093350.png

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,472 Super User 2024 Season 2 on at
    RE: Inventory valuation in minus

    Hi, please check the following setting in Inventory Setup first.

    pastedimage1662076646723v1.png

    If automatic posting is not turned on, please run the batch below manually.

    pastedimage1662076866194v2.png

    Hope this helps as well.
    Thanks.

    ZHU

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,025 on at
    RE: Inventory valuation in minus

    Hi,

    Pls Run "Item Adjust Cost/Price" then run the report.

    Regards

    Amit Sharma

    www.erpconsultors.com

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Inventory valuation in minus

    Have you executed the cost adjustment routine for june and july? I would start by doing that to see if the values are the same after cost adjustment.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans