How can i group items in single row with respect to same delivery note serial number?

[hiteshmchaudhary]

Please pardon me for the new bee question, usually we have to make delivery note for whole month and then at the end of the month we have to make sales invoice and we also have to put one column referring delivery note serial number now the problem is it takes to much space with default format i wanted to group the column into single row with multiple items with “,” (coma) in between with respect to same delivery note serial number. Please help me out how can i do this?

[ROHAN_JAIN1]

You can build your customized print format

[hiteshmchaudhary]

I don’t know how to do it can you tell me what should i learn in order to be capable for making custom print format

[ROHAN_JAIN1]

https://docs.erpnext.com/docs/user/manual/en/setting-up/print/print-format-builder

See this it can help you

Jinja Tempalting Language: Reference

[kennethsequeira]

Refer these resources:

https://docs.erpnext.com/docs/user/manual/en/setting-up/print/print-format

https://docs.erpnext.com/docs/user/manual/en/setting-up/print/print-format-builder

Print Settings and Configuration in ERPNext

Mainly you’ll need a bit of knowledge of HTML, CSS, and Jinja to get this done.

[hiteshmchaudhary]

can anyone help me out getting this done i am willing to pay for the solution

[sanjay]

Check below to group items and calculate totals.

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

[hiteshmchaudhary]

Actually i am using default print format how can use this?