How to get customers total unpaid

bahaou · December 30, 2021, 9:32am

Hello community . is there a way to get this field as a variable (for a print format) ? because the doctype doesn’t have a field named total unpaid .

dj12djdjs · December 30, 2021, 7:54pm

You can use this method in Jinja to get the balance of the party at time of printing

github.com

frappe/erpnext/blob/56b9ad8303e90648f4f0a34f009dd20a0f4081fe/erpnext/accounts/utils.py#L117


      
          
          
def validate_fiscal_year(date, fiscal_year, company, label="Date", doc=None):
          	years = [f[0] for f in get_fiscal_years(date, label=_(label), company=company)]
          	if fiscal_year not in years:
          		if doc:
          			doc.fiscal_year = years[0]
          		else:
          			throw(_("{0} '{1}' not in Fiscal Year {2}").format(label, formatdate(date), fiscal_year))
          
          
@frappe.whitelist()
          def get_balance_on(account=None, date=None, party_type=None, party=None, company=None,
          	in_account_currency=True, cost_center=None, ignore_account_permission=False):
          	if not account and frappe.form_dict.get("account"):
          		account = frappe.form_dict.get("account")
          	if not date and frappe.form_dict.get("date"):
          		date = frappe.form_dict.get("date")
          	if not party_type and frappe.form_dict.get("party_type"):
          		party_type = frappe.form_dict.get("party_type")
          	if not party and frappe.form_dict.get("party"):
          		party = frappe.form_dict.get("party")
          	if not cost_center and frappe.form_dict.get("cost_center"):

bahaou · December 31, 2021, 7:12am

That is exactly what I did