Zum Inhalt springen
Sie müssen registriert sein, um mit der Community zu interagieren.
Alle Beiträge Personen Abzeichen
Stichwörter (Alle anzeigen)
odoo accounting v14 pos v15
Über dieses Forum
Diese Frage wurde gekennzeichnet
pythonodoo-13
2 Antworten
6671 Ansichten
Avatar
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)"}]}

Avatar
Verwerfen
Avatar
Akshay
Beste Antwort 
<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.
Avatar
Verwerfen
Bryan
Autor

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
Autor

Thank you! My first time to develop in Odoo.

Avatar
Equick ERP
Beste Antwort

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.

Avatar
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
new python env
python
Avatar
0
März 25
1374
What means "Too many values to unpack" message? Gelöst
python
Avatar
Avatar
Avatar
Avatar
Avatar
4
Apr. 24
174270
have no data in screen. read data in my own module from different model
python
Avatar
0
Dez. 23
2171
How to insert value to a one2many field in table with create method? Gelöst
python
Avatar
Avatar
Avatar
Avatar
Avatar
5
Juli 25
228042
Is it possible to get data in stock.picking from invoice?
python invoicing stock.picking odoo-13
Avatar
Avatar
1
Aug. 23
4573