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 :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Negative inventory val...
Small and medium business | Business Central, N...
Answered

Negative inventory value with no remaining quantity.

(1) ShareShare
ReportReport
Posted on by Esteban Navarro 241

Hello everyone,

Thanks in advance for any help.

I have multiple products with zero units in a location, but with remaining value. This happened because multiple negative and positive adjustments, as well as transfers, were made while modifying the cost. How can this be fixed or reversed? The main issue is that hundreds of products have this issue, and it has been happening for years.

For example, in one location, my value is through the roof, but there are no quantities.

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Ahmad Subhani Profile Picture
    Ahmad Subhani 553 on at
    Negative inventory value with no remaining quantity.
    Hi,
     
    Hope you are doing well.
     
    There is one field name as Average Cost Period. Check what you have select. For Example you do all the Adjustments on 1 December and you select Day over here. Then Try to check that what value is coming on 2nd Decemeber 
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 29,977 Super User 2025 Season 2 on at
    Negative inventory value with no remaining quantity.
    There could be several causes for this issue. Have you run 'Adjust Cost Item Entries?' What is your costing method? If it's 'Average,' check the inventory setup to see whether the 'Average Cost Calc. Type' is set to 'Item' or 'Item and Location.'

    If your costing method is 'Average' and the 'Average Cost Calc. Type' is set to 'Item' instead of 'Item and Location,' running the inventory valuation report for a specific location can result in these inconsistencies.
     
    If its neither of the above two, you can check this thread as well - Inventory Valuation (0 quantity but negative amount) — mibuso.com. This problem comes up once in a while so there are a lot of threads on it.
     
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 93,222 Super User 2025 Season 2 on at
    Negative inventory value with no remaining quantity.
    Hi, Microsoft explained this issue in its official documentation.
    Business Central Design Details: Known Item Application Issue (where the inventory level is zero although open item ledger entries exist)
    More details: https://learn.microsoft.com/en-us/dynamics365/business-central/design-details-inventory-zero-level-open-item-ledger-entries?wt.mc_id=DX-MVP-5004336
     
    Hope this helps.
    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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

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…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,828

#2
Sumit Singh Profile Picture

Sumit Singh 2,617

#3
YUN ZHU Profile Picture

YUN ZHU 1,861 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans