Calculate in Custom Print Format (Calculate in Jinja)

[Osama_Al-mutawakel]

Hi Everyone,

I have been created a custom print format for “Journal Ledger”,
what I want is how to calculate debit and credit accounts for each currency as the photo below!

Thank you in advance!

[sanjay]

Check below

[Tutorial] Jinja How To : Group data and calculate sum

You can use below code to group data and calculate sum in Jinja Script: {% set items = [ {'item_code':'item1', 'qty': 100, 'amount': 1000}, {'item_code':'item2', 'qty': 200, 'amount': 2000}, {'item_code':'item1', 'qty': 100, 'amount': 1000}, {'item_code':'item3', 'qty': 300, 'amount': 3000}, {'item_code':'item2', 'qty': 200, 'amount': 2000} ] %} <table> <thead> <tr> <th>Item Code</th> <th>Qty</th> <th>Total</th> </tr> </thead> <tbody> <!-- group items by item_code //--> {% for item, i…