Custom Print Format - Columns total in table footer

[tanuj82685]

Hi,
I am using custom print format to print sales invoices, I need to call column total in html table,

If a document pdf consists of two pages the table breaks within two pages, In my setup I need to call total of page column in table footer.

Please find the below mentioned screen shot of two pages - both are showing the total sum of the the document rather than page total. How do i achieve column total of the page ?

I am using this code in table footer

{{ doc.items|sum(attribute=‘qty’) }}

[ARUNVENUGOPAL111]

please send me the code for this print format.

[tanuj82685]

Hey there @ARUNVENUGOPAL111 sorry for late reply,

Which version of erpnext are you on ?

[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…