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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Inventory value mismat...
Small and medium business | Business Central, N...
Suggested Answer

Inventory value mismatch in fields item card

(0) ShareShare
ReportReport
Posted on by Himanshu Rawat 24
Hi every one,
I was working on the item card and found that the value in Inventory field and Net Invoiced qty field are different, The value in Net Invoiced qty in showing negative value as shown in screenshot, In the item ledger entries value is 136, can any one please guide me what was the root cause for this issue. 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Alexander Drogin Profile Picture
    Alexander Drogin 262 on at
    This is not necessarily an issue. Both fields are calculated from item ledger entries, but Inventory reflects the total quantity at hand, while Net Invoiced Quantity - as the name suggests - only invoiced quantity. This difference means that your sales orders have been invoiced, whilst some purchase orders are likely posted as received, but not invoiced. Click on any of these values, the drill down will take you to the list of item ledger entries where you can check which entries cause the difference (look for those where Quantity is not equal to Invoiced Quantity). This will lead you to uninvoiced documents.
  • Himanshu Rawat Profile Picture
    Himanshu Rawat 24 on at
    Yes i have cross checked the item ledger in the ledger entries values and found there are 3 entries which does not have equal quantity  and  invoiced quantity all of them are positive or  negative adjustment but still the value are not correct there is a sum difference can you please suggest some solution for that 
  • Alexander Drogin Profile Picture
    Alexander Drogin 262 on at
    It doesn't look like normal item ledger entries to me. At least, I can't recall any situation where invoiced quantity in a positive or negative adjustment entry could be anything other than Quantity of the same entry. These adjustments are the simplest type of inventory operation, and do not separate invoicing from shipping/receiving operations.
    Do you know how these entries were posted? Are there any customisations in the system? And what kind of value entries are applied to these item ledger entries?
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 2,647 Super User 2026 Season 1 on at
    Hello,
     
     
    It just means that you have posted more sales invoices than purchase invoices on this particular item.
     
    The Net Invoiced Qty. will be "normal" once you have converted purchase receipts into posted purchase invoices.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans