Skip to Content
This question has been flagged
pythonodoo-13
2 Replies
6681 Rodiniai
Portretas
Bryan

I'm creating a custom report in the Invoice module.

<span class="text-nowrap" t-esc="doc.invoice_payments_widget" />

I added the above code and it returns jSON format. But I need to get the amount only.

{"title": "Less Payment", "outstanding": false, "content": [{"name": "Customer Payment: INV/2021/0006", "journal_name": "Bank", "amount": 500.0, "currency": "$", "digits": [69, 2], "position": "before", "date": "2021-03-26", "payment_id": 25, "account_payment_id": 2, "payment_method_name": "Manual", "move_id": 11, "ref": "BNK1/2021/0002 (INV/2021/0006)"}]}

Portretas
Atmesti
Portretas
Akshay
Best Answer 
<t t-set="total" t-value="0"/>
<t t-set="payments_vals" t-value="doc.sudo()._get_reconciled_info_JSON_values()"/>
<t t-foreach="payments_vals" t-as="payment_vals">
    <t t-set="total" t-value="total + payment_vals['amount']" />
</t>
<span class="text-nowrap" t-esc="total" />

there will be cases where you will have more than one payment line. So its better to use the above code.
Portretas
Atmesti
Bryan
Autorius

Is it possible to display the currency as well?

Akshay

<span class="text-nowrap" t-esc="total" t-options='{"widget": "monetary", "display_currency": doc.currency_id}' />

Bryan
Autorius

Thank you! My first time to develop in Odoo.

Portretas
Equick ERP
Best Answer

Hello 

In json format you are getting the "account_payment_id". so using this account payment id you will get amount from the account payment.

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
new python env
python
Portretas
0
kov. 25
1376
What means "Too many values to unpack" message? Solved
python
Portretas
Portretas
Portretas
Portretas
Portretas
4
bal. 24
174288
have no data in screen. read data in my own module from different model
python
Portretas
0
gruod. 23
2172
How to insert value to a one2many field in table with create method? Solved
python
Portretas
Portretas
Portretas
Portretas
Portretas
5
liep. 25
228069
Is it possible to get data in stock.picking from invoice?
python invoicing stock.picking odoo-13
Portretas
Portretas
1
rugp. 23
4584