Přejít na obsah
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
This question has been flagged
pythonodoo-13
2 Odpovědi
6682 Zobrazení
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
Zrušit
Avatar
Akshay
Nejlepší odpověď 
<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
Zrušit
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
Nejlepší odpověď

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
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
new python env
python
Avatar
0
bře 25
1376
What means "Too many values to unpack" message? Vyřešeno
python
Avatar
Avatar
Avatar
Avatar
Avatar
4
dub 24
174291
have no data in screen. read data in my own module from different model
python
Avatar
0
pro 23
2172
How to insert value to a one2many field in table with create method? Vyřešeno
python
Avatar
Avatar
Avatar
Avatar
Avatar
5
čvc 25
228083
Is it possible to get data in stock.picking from invoice?
python invoicing stock.picking odoo-13
Avatar
Avatar
1
srp 23
4588