Update balance_sheet.py
diff --git a/erpnext/accounts/report/balance_sheet/balance_sheet.py b/erpnext/accounts/report/balance_sheet/balance_sheet.py
index 0a2a9e3..62d1940 100644
--- a/erpnext/accounts/report/balance_sheet/balance_sheet.py
+++ b/erpnext/accounts/report/balance_sheet/balance_sheet.py
@@ -10,9 +10,9 @@
def execute(filters=None):
period_list = get_period_list(filters.fiscal_year, filters.periodicity, from_beginning=True)
- asset = get_data(filters.company, "Asset", "Debit", period_list)
- liability = get_data(filters.company, "Liability", "Credit", period_list)
- equity = get_data(filters.company, "Equity", "Credit", period_list)
+ asset = get_data(filters.company, "Asset", "Debit", period_list, filters.accumulated_value)
+ liability = get_data(filters.company, "Liability", "Credit", period_list, filters.accumulated_value)
+ equity = get_data(filters.company, "Equity", "Credit", period_list, filters.accumulated_value)
provisional_profit_loss = get_provisional_profit_loss(asset, liability, equity,
period_list, filters.company)
@@ -23,12 +23,13 @@
if provisional_profit_loss:
data.append(provisional_profit_loss)
- columns = get_columns(period_list)
+ columns = get_columns(filters.periodicity,period_list,filters.accumulated_value)
return columns, data
def get_provisional_profit_loss(asset, liability, equity, period_list, company):
if asset and (liability or equity):
+ total_column=0
provisional_profit_loss = {
"account_name": "'" + _("Provisional Profit / Loss (Credit)") + "'",
"account": None,
@@ -49,6 +50,9 @@
if provisional_profit_loss[period.key]:
has_value = True
+
+ total_column=total_column+provisional_profit_loss[period.key]
+ provisional_profit_loss["total"]=total_column
if has_value:
return provisional_profit_loss