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

Community site session details

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

Inventory valuation in minus

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,045 Moderator 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.

  • Suggested answer
    Amit Baru Profile Picture
    3,037 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
    YUN ZHU Profile Picture
    93,438 Super User 2025 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

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,568

#2
Sumit Singh Profile Picture

Sumit Singh 2,536

#3
YUN ZHU Profile Picture

YUN ZHU 2,015 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans