commit f8c852c54ccf7a33d26e15378b76557ceffd77e5
author Rohit Waghchaure <rohitw1991@gmail.com> Wed Feb 01 15:38:12 2023 +0530
committer Rohit Waghchaure <rohitw1991@gmail.com> Wed Feb 01 17:49:11 2023 +0530
tree 4e846452970f37a9ed01bd6d30e5685b730c2e87
parent 6b31c27ed6824e5422f6c349d5828fb67df9afe4

fix: incorrect actual qty in Bin

erpnext/stock/stock_ledger.py

diff --git a/erpnext/stock/stock_ledger.py b/erpnext/stock/stock_ledger.py
index 5d75bfd..d8b12ed 100644
--- a/erpnext/stock/stock_ledger.py
+++ b/erpnext/stock/stock_ledger.py
@@ -1179,7 +1179,7 @@
 def get_sle_by_voucher_detail_no(voucher_detail_no, excluded_sle=None):
 	return frappe.db.get_value(
 		"Stock Ledger Entry",
-		{"voucher_detail_no": voucher_detail_no, "name": ["!=", excluded_sle]},
+		{"voucher_detail_no": voucher_detail_no, "name": ["!=", excluded_sle], "is_cancelled": 0},
 		[
 			"item_code",
 			"warehouse",