fix: added total column
diff --git a/erpnext/accounts/report/dimension_wise_accounts_balance_report/dimension_wise_accounts_balance_report.py b/erpnext/accounts/report/dimension_wise_accounts_balance_report/dimension_wise_accounts_balance_report.py
index 7f38770..de7ed49 100644
--- a/erpnext/accounts/report/dimension_wise_accounts_balance_report/dimension_wise_accounts_balance_report.py
+++ b/erpnext/accounts/report/dimension_wise_accounts_balance_report/dimension_wise_accounts_balance_report.py
@@ -120,6 +120,7 @@
for d in accounts:
has_value = False
+ total = 0
row = {
"account": d.name,
"parent_account": d.parent_account,
@@ -137,8 +138,10 @@
if abs(row[frappe.scrub(item)]) >= 0.005:
# ignore zero values
has_value = True
+ total += flt(d.get(frappe.scrub(item), 0.0), 3)
row["has_value"] = has_value
+ row["total"] = total
data.append(row)
return data
@@ -199,5 +202,12 @@
"options": "currency",
"width": 150
})
+ columns.append({
+ "fieldname": "total",
+ "label": "Total",
+ "fieldtype": "Currency",
+ "options": "currency",
+ "width": 150
+ })
return columns