How to get account amount?

Denmark_Del_Puso · June 1, 2018, 11:46pm

is it possible to get account amount in my chart of accounts?

i create another field to link in accounts, then i need to read the amount.

ahmed-madi · June 2, 2018, 12:41am

You can return the balance of the required account by this white listed API which is used to calculate the amount of the accounts in the CoA

github.com

frappe/erpnext/blob/375db6181db45db094254d4c669b1084aea1b318/erpnext/accounts/utils.py#L86


      
          
          
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):
          	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")
          
          
	cond = []