Passa al contenuto
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
La domanda è stata contrassegnata
pythonodoo-13
2 Risposte
6676 Visualizzazioni
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
Abbandona
Avatar
Akshay
Risposta migliore 
<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
Abbandona
Bryan
Autore

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
Autore

Thank you! My first time to develop in Odoo.

Avatar
Equick ERP
Risposta migliore

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
Abbandona
Post correlati Risposte Visualizzazioni Attività
new python env
python
Avatar
0
mar 25
1375
What means "Too many values to unpack" message? Risolto
python
Avatar
Avatar
Avatar
Avatar
Avatar
4
apr 24
174278
have no data in screen. read data in my own module from different model
python
Avatar
0
dic 23
2172
How to insert value to a one2many field in table with create method? Risolto
python
Avatar
Avatar
Avatar
Avatar
Avatar
5
lug 25
228050
Is it possible to get data in stock.picking from invoice?
python invoicing stock.picking odoo-13
Avatar
Avatar
1
ago 23
4574