def get_balance_sheet_data(fiscal_year, companies, columns, filters):
asset = get_data(companies, "Asset", "Debit", fiscal_year, filters=filters)
liability = get_data(companies,
"Liability",
"Credit",
fiscal_year,
filters=filters)
equity = get_data(companies,
"Equity",
"Credit",
fiscal_year,
filters=filters)
data = []
data.extend(asset or [])
data.extend(liability or [])
data.extend(equity or [])
company_currency = get_company_currency(filters)
provisional_profit_loss, total_credit = get_provisional_profit_loss(
asset, liability, equity, companies, filters.get('company'),
company_currency, True)
message, opening_balance = check_opening_balance(asset, liability, equity)
if opening_balance and round(opening_balance, 2) != 0:
unclosed = {
"account_name":
"'" + _("Unclosed Fiscal Years Profit / Loss (Credit)") + "'",
"account":
"'" + _("Unclosed Fiscal Years Profit / Loss (Credit)") + "'",
"warn_if_negative":
True,
"currency":
company_currency
}
for company in companies:
unclosed[company] = opening_balance
if provisional_profit_loss:
provisional_profit_loss[company] = provisional_profit_loss[
company] - opening_balance
unclosed["total"] = opening_balance
data.append(unclosed)
if provisional_profit_loss:
data.append(provisional_profit_loss)
if total_credit:
data.append(total_credit)
report_summary = get_bs_summary(companies, asset, liability, equity,
provisional_profit_loss, total_credit,
company_currency, filters, True)
chart = get_chart_data(filters, columns, asset, liability, equity)
return data, message, chart, report_summary
def get_balance_sheet_data(fiscal_year, companies, columns, filters):
asset = get_data(companies, "Asset", "Debit", fiscal_year, filters=filters)
liability = get_data(companies, "Liability", "Credit", fiscal_year, filters=filters)
equity = get_data(companies, "Equity", "Credit", fiscal_year, filters=filters)
data = []
data.extend(asset or [])
data.extend(liability or [])
data.extend(equity or [])
company_currency = get_company_currency(filters)
provisional_profit_loss, total_credit = get_provisional_profit_loss(asset, liability, equity,
companies, filters.get('company'), company_currency, True)
message, opening_balance = check_opening_balance(asset, liability, equity)
if opening_balance and round(opening_balance,2) !=0:
unclosed ={
"account_name": "'" + _("Unclosed Fiscal Years Profit / Loss (Credit)") + "'",
"account": "'" + _("Unclosed Fiscal Years Profit / Loss (Credit)") + "'",
"warn_if_negative": True,
"currency": company_currency
}
for company in companies:
unclosed[company] = opening_balance
if provisional_profit_loss:
provisional_profit_loss[company] = provisional_profit_loss[company] - opening_balance
unclosed["total"]=opening_balance
data.append(unclosed)
if provisional_profit_loss:
data.append(provisional_profit_loss)
if total_credit:
data.append(total_credit)
chart = get_chart_data(filters, columns, asset, liability, equity)
return data, message, chart
