Stock Balance wrong Balance Value

[YamanQD]

Hello
We’re facing issues regarding the “Balance Value” column in “Stock Balance” report.
Some items with zero “Balance Qty”, have a positive or negative non-zero “Balance Value”, even though the same item’s “Balance Value” appears as zero in “Stock Ledger” report.

I searched the forums and found some threads regarding the same issue, but non of the mentioned solutions worked.

Here is an example of one of the items with zero qty and non-zero value:

Stock Balance:

Stock Ledger:

How can we fix “Balance Value” for all items?

[YamanQD]

Update:
We found out where the wrong “Balance Value” comes from. It comes from the “Value Change” column in Stock Ledger report not adding up to (0).

Example: Item “CP965”

• (Stock Balance Report): The item has a quantity of (0) but a non-zero stock value of (4.03).
  

  

• (Stock Ledger Report): The sum of the “Value Change” column is 4.025, not the expected value of 0.00.
  

  

• Note: All stock transactions shown in (Stock Ledger Report) regarding this item and warehouse, are “Stock Entries” of the type “Material Transfer”.

[YamanQD]

We have identified another instance of this bug, which we were able to resolve.

Example: Item “V64”

1. Stock Balance Report: Shows (0) quantity but a non-zero (0.63) value.
   
   
2. Stock Ledger Report: Shows only two transactions: a Purchase Receipt and a Delivery Note, each with a different “Incoming Rate.” This discrepancy appears to trigger the same bug in the Stock Balance report.
   
   

Temporary Fix: We resolved the issue for this specific item by cancelling and re-submitting the single Delivery Note. Notably, we did not change any data (e.g., rates or quantities) during this process—the act of amending and resubmitting the document alone corrected the balance.

---

While this workaround fixed one item, the root cause is still unknown and the issue persists for other items. We’re also concerned it may affect future transactions.

What could be causing this bug?, and how can we fix it for all affected items without going over and cancelling every transaction?