Automatic code for detailed accounts

[LittleDaggers27]

Char Account Number Auto number in V-14

Server Script parentaccount=doc.parent_account #try: query_result = frappe.db.sql(""" SELECT Max(creation) FROM `tabAccount` WHERE parent_account = %s """, parentaccount) #frappe.errprint(query_result) frappe.errprint(query_result[0][0]) if query_result and query_result[0][0] is not None: frappe.errprint('in') lastinsertedaccountdate = query_result[0][0] accountnumber = frappe.db.sql(""" SELECT Max(account_number) FROM `tabAccount` WHERE creation =…

this is the solution