Precision fixed in batch-wise balance report
diff --git a/erpnext/stock/report/batch_wise_balance_history/batch_wise_balance_history.py b/erpnext/stock/report/batch_wise_balance_history/batch_wise_balance_history.py
index 9b94ee6..3679457 100644
--- a/erpnext/stock/report/batch_wise_balance_history/batch_wise_balance_history.py
+++ b/erpnext/stock/report/batch_wise_balance_history/batch_wise_balance_history.py
@@ -4,7 +4,7 @@
from __future__ import unicode_literals
import frappe
from frappe import _
-from frappe.utils import flt
+from frappe.utils import flt, cint
def execute(filters=None):
if not filters: filters = {}
@@ -57,6 +57,7 @@
conditions, as_dict=1)
def get_item_warehouse_batch_map(filters):
+ float_precision = cint(frappe.db.get_default("float_precision")) or 3
sle = get_stock_ledger_entries(filters)
iwb_map = {}
@@ -67,14 +68,14 @@
}))
qty_dict = iwb_map[d.item_code][d.warehouse][d.batch_no]
if d.posting_date < filters["from_date"]:
- qty_dict.opening_qty += flt(d.actual_qty)
+ qty_dict.opening_qty += flt(d.actual_qty, float_precision)
elif d.posting_date >= filters["from_date"] and d.posting_date <= filters["to_date"]:
if flt(d.actual_qty) > 0:
- qty_dict.in_qty += flt(d.actual_qty)
+ qty_dict.in_qty += flt(d.actual_qty, float_precision)
else:
- qty_dict.out_qty += abs(flt(d.actual_qty))
+ qty_dict.out_qty += abs(flt(d.actual_qty, float_precision))
- qty_dict.bal_qty += flt(d.actual_qty)
+ qty_dict.bal_qty += flt(d.actual_qty, float_precision)
return iwb_map