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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

zero qty but with item value on inventory valuation report

(1) ShareShare
ReportReport
Posted on by 382
Hi Everyone, I'm working on an issue that a FIFO item has zero qty on hand but shows positive value on inventory valuation report.
To replicate the issue, I did the following
 
1. turn off the Auto post item cost and Auto post cost adjustment flags. prevent negative inventory flag is also off.
2. post and invoice purchase order for an item with qty of 20, then sold and invoice that item.
 
I expect the inventory valuation report shows zero qty of that item but with a positive value 248.82. But the report doesn't include that item.
 
The value entries seem correct/as expected. Any thought why BC behave this way? 
 
 
 
I have the same question (0)
  • Suggested answer
    Valentin Castravet Profile Picture
    31,340 Super User 2025 Season 2 on at
    The last entry where the item was sold has the sales shipment with a cost of 0, but it doesn't contain the sales invoice. Was this item invoiced or only shipped? The issue might be related to that.
     
  • Suggested answer
    YUN ZHU Profile Picture
    95,391 Super User 2025 Season 2 on at
    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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,990

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,576 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,028 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans