Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 1,702 Super User 2024 Season 2 on at
    Inventory value mismatch in fields item card
    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.
  • Alexander Drogin Profile Picture
    Alexander Drogin 170 on at
    Inventory value mismatch in fields item card
    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?
  • himanshu rawat Profile Picture
    himanshu rawat 24 on at
    Inventory value mismatch in fields item card
    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 
  • Suggested answer
    Alexander Drogin Profile Picture
    Alexander Drogin 170 on at
    Inventory value mismatch in fields item card
    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.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans