How can We get such type of preview at print format level at quotation using HTML?
<table>
<thead>
<tr>
<th>Item Code</th>
<th> Quantity </th>
<th> Rate </th>
</tr>
</thead>
<tbody>
{% for item in doc.items %} <tr>
<td>{{loop.index}}</td>
<td>{{item.item_name}}</td>
<td>{{item.qty}}</td>
<td>{{item.rate}}</td>
</tr>
{% endfor %}
</table>
Do the same for all the fields
@Yamen_Zakhour @NCP how can I get the below tax amount into the above item fields (HTML Code)
<!DOCTYPE html>
<html>
<head>
<style>
/* Add your custom styles here */
table {
width: 100%;
border-collapse: collapse;
font-size: 6pt;
}
th, td {
border: 1px solid black;
padding: 3px;
text-align: left;
}
th {
background-color: #f2f2f2;
}
</style>
</head>
<body>
<div>
<table>
<thead>
<tr>
<th>Item Code</th>
<th>Description</th>
<th>Rate</th>
<th>Quantity</th>
<th>Amount</th>
<th>Item Tax Template</th>
<th>Tax Amount</th>
<th>Total</th>
</tr>
</thead>
<tbody>
{% for item in doc.items %}
<tr>
<td>{{ item.item_code }}</td>
<td>{{ item.description }}</td>
<td>{{ item.rate }}</td>
<td>{{ item.qty }}</td>
<td>{{ item.amount }}</td>
<td>{{ item.item_tax_template or "" }}</td>
<td>{{ item.tax_amount or 0 }}</td>
<td>{{ item.amount + (item.tax_amount or 0) }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</body>
</html>
Any solution?
Hi @Humming_Bird,
The Tax Breakup needs to display based on the HSN code. If multiple items have the same HSN code and the same tax applied, you can’t simply set it on the print format directly. You need to add a custom field for each item’s tax calculation and set it accordingly. Then, you can include this custom field in the print format, and that should resolve the issue.
Thank You!
Alternatively, you can {{item.tax_amount * item.tax_rate}}