İçereği Atla
Menü
Bu soru işaretlendi
2 Cevaplar
1907 Görünümler

I need to Print the Product Expiry date and the Product Barcode in the sales Invoice.

Avatar
Vazgeç
En İyi Yanıt

Hi 

Inherit the account.invoice_report_document and add the following code .

<template id="report_invoice_document_barcode" inherit_id="account.report_invoice_document">
      <xpath expr="//table[@name='invoice_line_table']/thead/tr/th[3]" position="after">
            <th class="text-right">
                <strong>Product Barcode</strong>
            </th>
            <th class="text-right">
                <strong>Product Expiry Date</strong>
            </th>
    </xpath>
      <xpath expr="//table[@name='invoice_line_table']/tbody//tr[1]//td[3]" position="after">
        <td class="text-right">
            <span t-field="line.product_id.barcode" />
 
      </td>
        <td class="text-right">
            <span t-field="line.product_id.expiration_time"/>
        </td>
    </xpath>
</template>


Hope this Helps


Regards

Avatar
Vazgeç
Üretici En İyi Yanıt

Thanks Bella for your reply

The Product Barcode it printed in invoice but the expiry date didn't appear. 

the Expiry date is the Delivery Note related to Order.

Saad. 

Avatar
Vazgeç

Here I updated the product expiration date after installing the product_expiry addon. It gives the expiration time for each product. which date are you expecting?

Üretici

Dear Bella James
kindly, i need the product expiry date which in Delivery Note related Lot/Serial Number
Hope that is clear for you