Stock Balance, Stock Ledger and Stock Projected Qty showing different stock levels for an item

Hello Everyone. I am facing this issue where; when I reduce stock levels in a specific batch using the “Stock Reconciliation” document, the stock level information in the reports referenced above goes out of sync. On top of this, when a Sales Invoice is created, I get an “Insufficient Stock” notification despite having ample stock.
Has anyone faced a similar situation? Any idea what I might be missing?

I have a situation where BIN values and Stock Balance values are different.


image

Are you sure that “Stock Reconciliation” is causing this?

I’ve resolved the issue by

bench --site site1.local execute erpnext.stock.stock_balance.repost