Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
pythonodoo-13
2 Odpowiedzi
6817 Widoki
Awatar
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)"}]}

Awatar
Odrzuć
Awatar
Akshay
Najlepsza odpowiedź 
<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.
Awatar
Odrzuć
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.

Awatar
Equick ERP
Najlepsza odpowiedź

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.

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
new python env
python
Awatar
0
mar 25
1590
What means "Too many values to unpack" message? Rozwiązane
python
Awatar
Awatar
Awatar
Awatar
Awatar
4
kwi 24
174487
have no data in screen. read data in my own module from different model
python
Awatar
0
gru 23
2329
How to insert value to a one2many field in table with create method? Rozwiązane
python
Awatar
Awatar
Awatar
Awatar
Awatar
5
lip 25
228903
Is it possible to get data in stock.picking from invoice?
python invoicing stock.picking odoo-13
Awatar
Awatar
1
sie 23
4700