In OpenERP first, create existing module and then inherits the account.invoice object in your own module and also create report file in your own module.
Follow these step given belowas
Step1- First create module like, test then create file in your module like, test.py and inherits the account.invoice object in your test.py file and pass this file in the __init__.py file.
Using this code given below
import time
from openerp.report import report_sxw
from openerp.osv import osv
Step2- Then create another file like: test.xml file in your own module and pass this file in your __openerp__.py file.
Using this file given below
<?xml version="1.0" encoding="utf-8"?>
<openerp>
<data>
<report
id="report_account_invoice_new"
string="Invoice"
model="account.invoice"
report_type="qweb-pdf"
name="test.account_invoice"
file="test_invoice"
/>
</data>
</openerp>
Step3- Then create another file like test_invoice.xml file. In this file we create templates of report and design.
Using this code given below
<openerp>
<data>
<template id="invoices_reports">
<t t-call="report.external_layout">
<div class="page">
<div>
<div align="center" style="font-size: 20px;">INVOICE</div>
<br/>
<div align="center" style="font-size: 15px;"><span t-esc="o.payment_ids.journal_id.name"/></div>
<div class="row">
<div class="col-xs-6">
<div style="font-size: 15px;">Invoice NO.<span t-field="o.number"/></div>
</div>
<div class="col-xs-5 col-xs-offset-1" >
<div style="font-size: 15px; margin-left: 1.0cm">Date: <span t-field="o.date_invoice"/></div>
</div>
</div>
</div>
<br/>
<br/>
<table class="table table-condensed" style="border: 1px solid black">
<thead>
<tr style="border: 1px solid black">
<th style="border: 1px solid black; text-align: center; width : 2.0cm">SNo.</th>
<th style="border: 1px solid black; text-align: center; width : 2.0cm">Code</th>
<th style="border: 1px solid black; text-align: center; width : 9.0cm">Descirption</th>
<th style="border: 1px solid black; text-align: center; width : 2.0cm">Qty</th>
<th style="border: 1px solid black; text-align: center; width : 3.0cm">Unit / Pack size</th>
<th style="border: 1px solid black; text-align: center; width : 3.0cm">Amount</th>
</tr>
</thead>
<tbody class="invoice_tbody">
<tr t-foreach="o.invoice_line" t-as="l">
<td style="border: 1px solid black; width : 2.0cm; text-align: center" > <span t-esc="l_index+1"/>
</td>
<td style="border: 1px solid black; width : 2.0cm; text-align: center"> <span t-field="l.product_id.default_code"/>
</td>
<td style="border: 1px solid black; width : 9.0cm; text-align: center"> <span t-field="l.name"/>
</td>
<td style="border: 1px solid black; width : 2.0cm; text-align: center">
<span t-field="l.quantity"/>
</td>
<td style="border: 1px solid black; width : 2.0cm; text-align: center"> <span t-field="l.qty_char"/>
</td>
<td style="border: 1px solid black; width : 3.0cm; text-align: center"> <span t-field="l.price_unit"/>
</td>
<td style="border: 1px solid black; width : 3.0cm; text-align: center"> <span t-field="l.price_subtotal"/>
</td>
</tr>
<tr style="height: 0.8cm">
<td style="border: 1px solid black; width : 2.0cm; text-align: center" >
</td>
<td style="border: 1px solid black; width : 2.0cm; text-align: center">
</td>
<td style="border: 1px solid black; width : 9.0cm; text-align: center">
</td>
<td style="border: 1px solid black; width : 2.0cm; text-align: center">
</td>
<td style="border: 1px solid black; width : 3.0cm; text-align: center">
</td>
<td style="border: 1px solid black; width : 3.0cm; text-align: center">
</td>
<td style="border: 1px solid black; width : 3.0cm; text-align: center">
</td>
</tr>
<tr style="height: 0.8cm">
<td style="border: 1px solid black; width : 2.0cm; text-align: center" >
</td>
<td style="border: 1px solid black; width : 2.0cm; text-align: center">
</td>
<td style="border: 1px solid black; width : 9.0cm; text-align: center">
</td>
<td style="border: 1px solid black; width : 9.0cm; text-align: center">
</td>
<td style="border: 1px solid black; width : 2.0cm; text-align: center">
</td>
<td style="border: 1px solid black; width : 3.0cm; text-align: center">
</td>
<td style="border: 1px solid black; width : 3.0cm; text-align: center">
</td>
</tr>
</tbody>
</table>
<div class="col-xs-6">
<table class="table table-condensed" style="border: 1px solid white;">
<tr style="border: 1px solid black">
<td style="border: 1px solid white; width : 2.0cm">
<strong>Amount Paid</strong></td>
<td style="border: 1px solid white; width : 2.0cm">
<span t-feild="o.amount_total"/>
</td>
</tr>
<tr style="border: 1px solid white;">
<td style="border: 1px solid white;; width : 2.0cm">
<strong>Payment Detail</strong></td>
<td style="border: 1px solid white; width : 2.0cm">
<span t-field="o.payment_term"/>
</td>
</tr>
<tr style="border: 1px solid white;">
<td style="border: 1px solid white; width : 2.0cm;">
<strong>Balance</strong></td>
<td style="border: 1px solid white; width : 2.0cm;">
<span t-field="o.residual"/>
</td>
</tr>
</table>
</div>
<div class="col-xs-5 col-xs-offset-1" >
<table class="table table-condensed" style="border: 1px solid black; margin-left: 0.5cm">
<tr style="border: 1px solid black">
<td style="border: 1px solid black; width : 1.0cm; text-align: center"><strong>Total</strong></td>
<td style="border: 1px solid black; width : 1.0cm; text-align: center">
<span t-field="o.amount_untaxed" t-field-options='{"widget": "monetary", "display_currency": "o.currency_id"}'/>
</td>
</tr>
<tr style="border: 1px solid black">
<td style="border: 1px solid black; width : 1.0cm; text-align: center">Discount</td>
<td style="border: 1px solid black; width : 1.0cm; text-align: center">
<span t-field="o.amount_tax" t-field-options='{"widget": "monetary", "display_currency": "o.currency_id"}'/>
</td>
</tr>
<tr style="border: 1px solid black">
<td style="border: 1px solid black; width : 1.0cm; text-align: center"><strong>Total Bill Amount</strong></td>
<td style="border: 1px solid black; width : 1.0cm; text-align: center">
<span t-esc="o.amount_untaxed*o.discount/100" t-field-options='{"widget": "monetary", "display_currency": "o.currency_id"}'/>
</td>
</tr>
</table>
</div>
</div>
</t>
</template>
<template id="external_layout_footer" inherit_id="report.external_layout_footer">
</template>
<template id="report_header_new" inherit_id="report.external_layout_header">
<xpath expr="//div[@class='header']" position="replace"/>
</template>
<template id="report_invoices">
<t t-call="report.html_container">
<t t-foreach="doc_ids" t-as="doc_id">
<t t-raw="translate_doc(doc_id, doc_model, 'partner_id.lang', 'test.invoices_reports')"/>
</t>
</t>
</template>
</data>
</openerp>
0 Comment(s)