Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
pythonodoo-13
2 Vastaukset
7482 Näkymät
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
Hylkää
Avatar
Akshay
Paras vastaus 
<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
Hylkää
Bryan
Tekijä

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
Tekijä

Thank you! My first time to develop in Odoo.

Avatar
Equick ERP
Paras vastaus

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
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
new python env
python
Avatar
0
maalisk. 25
2338
What means "Too many values to unpack" message? Ratkaistu
python
Avatar
Avatar
Avatar
Avatar
Avatar
4
huhtik. 24
175826
have no data in screen. read data in my own module from different model
python
Avatar
0
jouluk. 23
2956
How to insert value to a one2many field in table with create method? Ratkaistu
python
Avatar
Avatar
Avatar
Avatar
Avatar
5
heinäk. 25
232102
Is it possible to get data in stock.picking from invoice?
python invoicing stock.picking odoo-13
Avatar
Avatar
1
elok. 23
5481