removed old report
diff --git a/erpnext/accounts/report/profitability_based_on_cost_center/__init__.py b/erpnext/accounts/report/profitability_based_on_cost_center/__init__.py
deleted file mode 100644
index e69de29..0000000
--- a/erpnext/accounts/report/profitability_based_on_cost_center/__init__.py
+++ /dev/null
diff --git a/erpnext/accounts/report/profitability_based_on_cost_center/profitability_based_on_cost_center.js b/erpnext/accounts/report/profitability_based_on_cost_center/profitability_based_on_cost_center.js
deleted file mode 100644
index c66cc4c..0000000
--- a/erpnext/accounts/report/profitability_based_on_cost_center/profitability_based_on_cost_center.js
+++ /dev/null
@@ -1,55 +0,0 @@
-// Copyright (c) 2016, Frappe Technologies Pvt. Ltd. and contributors
-// For license information, please see license.txt
-
-frappe.require("assets/erpnext/js/financial_statements.js", function() {
- frappe.query_reports["Profitability based on Cost Center"] = {
- "filters": [
- {
- "fieldname": "company",
- "label": __("Company"),
- "fieldtype": "Link",
- "options": "Company",
- "default": frappe.defaults.get_user_default("Company"),
- "reqd": 1
- },
- {
- "fieldname": "fiscal_year",
- "label": __("Fiscal Year"),
- "fieldtype": "Link",
- "options": "Fiscal Year",
- "default": frappe.defaults.get_user_default("fiscal_year"),
- "reqd": 1,
- "on_change": function(query_report) {
- var fiscal_year = query_report.get_values().fiscal_year;
- if (!fiscal_year) {
- return;
- }
- frappe.model.with_doc("Fiscal Year", fiscal_year, function(r) {
- var fy = frappe.model.get_doc("Fiscal Year", fiscal_year);
- query_report.filters_by_name.from_date.set_input(fy.year_start_date);
- query_report.filters_by_name.to_date.set_input(fy.year_end_date);
- query_report.trigger_refresh();
- });
- }
- },
- {
- "fieldname": "from_date",
- "label": __("From Date"),
- "fieldtype": "Date",
- "default": frappe.defaults.get_user_default("year_start_date"),
- },
- {
- "fieldname": "to_date",
- "label": __("To Date"),
- "fieldtype": "Date",
- "default": frappe.defaults.get_user_default("year_end_date"),
- }
- ],
- "formatter": erpnext.financial_statements.formatter,
- "tree": true,
- "name_field": "account",
- "parent_field": "parent_account",
- "initial_depth": 3
- }
-});
-
diff --git a/erpnext/accounts/report/profitability_based_on_cost_center/profitability_based_on_cost_center.json b/erpnext/accounts/report/profitability_based_on_cost_center/profitability_based_on_cost_center.json
deleted file mode 100644
index cc29860..0000000
--- a/erpnext/accounts/report/profitability_based_on_cost_center/profitability_based_on_cost_center.json
+++ /dev/null
@@ -1,18 +0,0 @@
-{
- "add_total_row": 0,
- "apply_user_permissions": 1,
- "creation": "2016-08-23 03:12:00.957918",
- "disabled": 0,
- "docstatus": 0,
- "doctype": "Report",
- "idx": 0,
- "is_standard": "Yes",
- "modified": "2016-08-23 03:12:00.957918",
- "modified_by": "Administrator",
- "module": "Accounts",
- "name": "Profitability based on Cost Center",
- "owner": "Administrator",
- "ref_doctype": "GL Entry",
- "report_name": "Profitability based on Cost Center",
- "report_type": "Script Report"
-}
\ No newline at end of file
diff --git a/erpnext/accounts/report/profitability_based_on_cost_center/profitability_based_on_cost_center.py b/erpnext/accounts/report/profitability_based_on_cost_center/profitability_based_on_cost_center.py
deleted file mode 100644
index 095936d..0000000
--- a/erpnext/accounts/report/profitability_based_on_cost_center/profitability_based_on_cost_center.py
+++ /dev/null
@@ -1,186 +0,0 @@
-# Copyright (c) 2013, Frappe Technologies Pvt. Ltd. and contributors
-# For license information, please see license.txt
-
-from __future__ import unicode_literals
-import frappe
-from frappe import _
-from frappe.utils import flt, getdate, formatdate, cstr
-from erpnext.accounts.report.financial_statements import filter_accounts
-from erpnext.accounts.report.trial_balance.trial_balance import validate_filters
-
-value_fields = ("income", "expense", "total")
-
-def execute(filters=None):
- validate_filters(filters)
- data = get_data(filters)
- columns = get_columns()
- return columns, data
-
-def get_data(filters):
- accounts = frappe.db.sql("""select name, parent_cost_center as parent_account, cost_center_name as account_name, lft, rgt
- from `tabCost Center` where company=%s order by lft""", filters.company, as_dict=True)
-
- if not accounts:
- return None
-
- accounts, accounts_by_name, parent_children_map = filter_accounts(accounts)
-
- min_lft, max_rgt = frappe.db.sql("""select min(lft), max(rgt) from `tabCost Center`
- where company=%s""", (filters.company,))[0]
-
- gl_entries_by_account = {}
-
- set_gl_entries_by_account(filters.company, filters.from_date,
- filters.to_date, min_lft, max_rgt, gl_entries_by_account, ignore_closing_entries=not flt(filters.with_period_closing_entry))
-
- total_row = calculate_values(accounts, gl_entries_by_account, filters)
- accumulate_values_into_parents(accounts, accounts_by_name)
-
- data = prepare_data(accounts, filters, total_row, parent_children_map)
-
- return data
-
-def calculate_values(accounts, gl_entries_by_account, filters):
- init = {
- "income": 0.0,
- "expense": 0.0,
- "total": 0.0
- }
-
- total_row = {
- "cost_center": None,
- "account_name": "'" + _("Total") + "'",
- "warn_if_negative": True,
- "income": 0.0,
- "expense": 0.0,
- "total": 0.0
- }
-
- for d in accounts:
- d.update(init.copy())
-
- # add opening
-
- for entry in gl_entries_by_account.get(d.name, []):
- if cstr(entry.is_opening) != "Yes":
- if entry.type == 'Income':
- d["income"] += flt(entry.credit) - flt(entry.debit)
- if entry.type == 'Expense':
- d["expense"] += flt(entry.debit) - flt(entry.credit)
-
- d["total"] = d.get("income") - d.get("expense")
-
- total_row["income"] += d["income"]
- total_row["expense"] += d["expense"]
-
- total_row["total"] = total_row.get("income") - total_row.get("expense")
-
- return total_row
-
-def accumulate_values_into_parents(accounts, accounts_by_name):
- for d in reversed(accounts):
- if d.parent_account:
- for key in value_fields:
- accounts_by_name[d.parent_account][key] += d[key]
-
-def prepare_data(accounts, filters, total_row, parent_children_map):
- data = []
- company_currency = frappe.db.get_value("Company", filters.company, "default_currency")
-
- for d in accounts:
- has_value = False
- row = {
- "account_name": d.account_name,
- "account": d.name,
- "parent_account": d.parent_account,
- "indent": d.indent,
- "from_date": filters.from_date,
- "to_date": filters.to_date,
- "currency": company_currency
- }
-
- for key in value_fields:
- row[key] = flt(d.get(key, 0.0), 3)
-
- if abs(row[key]) >= 0.005:
- # ignore zero values
- has_value = True
-
- row["has_value"] = has_value
- data.append(row)
-
- data.extend([{},total_row])
-
- return data
-
-def get_columns():
- return [
- {
- "fieldname": "account",
- "label": _("Cost Center"),
- "fieldtype": "Link",
- "options": "Cost Center",
- "width": 300
- },
- {
- "fieldname": "income",
- "label": _("Income"),
- "fieldtype": "Currency",
- "options": "currency",
- "width": 120
- },
- {
- "fieldname": "expense",
- "label": _("Expense"),
- "fieldtype": "Currency",
- "options": "currency",
- "width": 120
- },
- {
- "fieldname": "total",
- "label": _("Gross Profit / Loss"),
- "fieldtype": "Currency",
- "options": "currency",
- "width": 120
- },
- {
- "fieldname": "currency",
- "label": _("Currency"),
- "fieldtype": "Link",
- "options": "Currency",
- "hidden": 1
- }
- ]
-
-def set_gl_entries_by_account(company, from_date, to_date, root_lft, root_rgt, gl_entries_by_account,
- ignore_closing_entries=False):
- """Returns a dict like { "account": [gl entries], ... }"""
- additional_conditions = []
-
- if ignore_closing_entries:
- additional_conditions.append("and ifnull(voucher_type, '')!='Period Closing Voucher'")
-
- if from_date:
- additional_conditions.append("and posting_date >= %(from_date)s")
-
- gl_entries = frappe.db.sql("""select posting_date, cost_center, debit, credit,
- is_opening, (select root_type from `tabAccount` where name = account) as type
- from `tabGL Entry` where company=%(company)s
- {additional_conditions}
- and posting_date <= %(to_date)s
- and cost_center in (select name from `tabCost Center`
- where lft >= %(lft)s and rgt <= %(rgt)s)
- order by cost_center, posting_date""".format(additional_conditions="\n".join(additional_conditions)),
- {
- "company": company,
- "from_date": from_date,
- "to_date": to_date,
- "lft": root_lft,
- "rgt": root_rgt
- },
- as_dict=True)
-
- for entry in gl_entries:
- gl_entries_by_account.setdefault(entry.cost_center, []).append(entry)
-
- return gl_entries_by_account
\ No newline at end of file