def execute(filters=None):
    from erpnext.stock.report.stock_balance.stock_balance import execute

    columns, data = execute(filters)
    prices = {
        "buying": frappe.db.get_single_value("Buying Settings", "buying_price_list"),
        "selling": frappe.db.get_single_value("Selling Settings", "selling_price_list"),
    }
    return _get_columns(columns, prices), _get_data(data, prices, filters)
Esempio n. 2
0
def execute(filters=None):
    from erpnext.stock.report.stock_balance.stock_balance import execute

    columns, data = execute(filters)

    warehouses = frappe.get_all(
        "Warehouse",
        filters={"is_group": 0, "disabled": 0},
        fields=["name", "warehouse_name"],
    )
    warehouse_data = {
        x.get("name"): x.get("warehouse_name").strip().lower().replace(" ", "_")
        for x in warehouses
    }

    return _get_columns(columns, warehouse_data), _get_data(
        data, columns, warehouse_data
    )
Esempio n. 3
0
def execute(filters=None):
    from erpnext.stock.report.stock_balance.stock_balance import execute

    columns, data = execute(filters)
    return _get_rearranged_data(_get_columns(columns), _get_data(data, columns))
Esempio n. 4
0
def stock_balance(filters):
	"""Get rows from stock balance report"""
	return [_dict(row) for row in execute(filters)[1]]