Small and medium business | Business Central, N...

Inventory value mismatch in fields item card

(0) Share

Report

Posted on by himanshu rawat

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)

All responses (4)

Answers (0)

Suggested answer

Yi Yong 2,349 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Alexander Drogin 262 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
himanshu rawat 24 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Alexander Drogin 262 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Community site session details

Inventory value mismatch in fields item card

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Inventory value mismatch in fields item card

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates