Skip to Content
This question has been flagged
xmlqwebopenerpodooqweb-report
1 Reply
11251 Views
Avatar
Odoo Group Ecuador

I'm sorry for my English

I am writing a custom Qweb print report for Odoo invoices and my goal is add o.amount_untaxed + tax_amount_by_group(only positive values, excluding negative withholding); this is my code:

<t t-set="total" t-value="o.amount_untaxed"/>
<t t-foreach="o._get_tax_amount_by_group()"
   t-as="amount_by_group">
  <small> <tr>
    <td> <span t-if="amount_by_group[0] == 'Taxes'">
      <span t-esc="amount_by_group[1]"/> </span> <br></br>
    <t t-set="total" t-value="unicode(o.amount_untaxed)+amount_by_group[1]"/>
    <t t-esc="total"/>
    </td>
  </tr> </small> <br></br>
</t>

But the result is (based on actual DB records):

Subtotal $ 4,644.95
Taxes $ 557.39

Taxes 4644.95$ 557.39
Witholding 4644.95$ -167.21
Witholding 4644.95$ -46.45

My expected result need be (based on actual DB records):

Subtotal $ 4,644.95
Taxes $ 557.39

Total $ 5202.34

Total is the result of untaxed_amount + taxes (excluding withholding); I really tried many ways and I can not find the right one!

:'(

Avatar
Discard
Avatar
Farid Ghanchi
Best Answer

Hello,

please create report py file

You add context dictionary on init method like

class test_test(report_sxw.rml_parse):
    def __init__(self, cr, uid, name, context):
        super(test_test, self).__init__(cr, uid, name, context)
        self.localcontext.update({    
            'total_subtotat_plus_tax': self.total_subtotat_plus_tax,          
        })

class test_test(report_sxw.rml_parse):
    def __init__(self, cr, uid, name, context):
        super(test_test, self).__init__(cr, uid, name, context)
        self.localcontext.update({     
            'total_subtotat_plus_tax': self.total_subtotat_plus_tax,           
        })
    def total_subtotat_plus_tax(self, obj):
        return obj.amount_untaxed + obj._get_tax_amount_by_group[1]
 

now in xml

Total: <span t-esc="total_subtotal_plus_tax(o)" />

Thanks


Avatar
Discard
Related Posts Replies Views Activity
Print field One2many multi Ids in a single reporto ODOO 15
xml qweb odoo
Avatar
Avatar
1
Aug 22
1510
printout without left and right side margins or borders. Solved
xml qweb qweb-report odoo10
Avatar
Avatar
3
Nov 22
7116
edit qweb templates invoice pdf
xml qweb qweb template view qweb-report
Avatar
Avatar
Avatar
2
Aug 19
13049
How to get the page object in custom qweb report?
qweb odoo qweb-report odoo10
Avatar
0
Nov 18
4014
How to modify the position of the <tr> tags in reports under Accounting Reports and Journal in Odoo 8?
xml qweb odooV8 qweb-report
Avatar
0
Oct 16
3028