Jinja code is not working to fetching ledger balance in print designer
Here is code
{% if doc.party %}
{% set party_type = doc.party_type %}
{% set party = doc.party %}
{% set balance = frappe.db.get_value("GL Entry",
{"party_type": party_type, "party": party},
"SUM(debit) - SUM(credit)") %}
{% if balance is not none %}
{{ _("Ledger Balance") }}: {{ frappe.format_value(balance, { "fieldtype": "Currency", "precision": 0 }) }}
{% else %}
{{ _("No ledger balance available.") }}
{% endif %}
{% endif %}
As on: {{ frappe.utils.format_datetime(frappe.utils.now_datetime(), "dd-MM-yyyy HH:mm") }}