How to add expiry date in sales invoice

Suresh_Thakor · April 21, 2021, 1:26pm

@Prav94, Hope this will help as well as other. I have done little excersie.

Make enable Item >> Has Batch No and Has Expiry Date.

Customnize Sales Invoic Item., add custom field (Expiry Date) below batch no.

then Editing Row and set field as below

Save. Reload.

Add below code in Custom Print Format - Type Jinja

<table class="table table-bordered">
<tbody>
	<tr>
		<th>Sr</th>
		<th>Item Name</th>
		<th>Description</th>
		<th class="text-right">Qty</th>
		<th class="text-right">Rate</th>
		<th class="text-right">Amount</th>
	</tr>
	{%- for row in doc.items -%}
	<tr>
		<td style="width: 3%;">{{ row.idx }}</td>
		<td style="width: 20%;">
			{{ row.item_name }}
			{% if row.item_code != row.item_name -%}
			<br>Code: {{ row.item_code}}
			{%- endif %}
		</td>
		<td style="width: 37%;">
			<div style="border: 0px;">{{ row.item_name }} <br> BATCH : {{ row.batch_no }} | EXPIRY : {{ row.expiry_date }} </div></td>
		<td style="width: 10%; text-align: right;">{{ row.qty }} {{ row.uom or row.stock_uom }}</td>
		<td style="width: 15%; text-align: right;">{{
			row.get_formatted("rate", doc) }}</td>
		<td style="width: 15%; text-align: right;">{{
			row.get_formatted("amount", doc) }}</td>
	</tr>
	{%- endfor -%}
	</tbody>
 </table>

Result

Thanks