コンテンツへスキップ
この質問にフラグが付けられました
pythonodoo-13
2 返信
7438 ビュー
アバター
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)"}]}

アバター
破棄
アバター
Akshay
最善の回答 
<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.
アバター
破棄
Bryan
著作者

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
著作者

Thank you! My first time to develop in Odoo.

アバター
Equick ERP
最善の回答

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.

アバター
破棄
関連投稿 返信 ビュー 活動
new python env
python
アバター
0
3月 25
2322
What means "Too many values to unpack" message? 解決済
python
アバター
アバター
アバター
アバター
アバター
4
4月 24
175785
have no data in screen. read data in my own module from different model
python
アバター
0
12月 23
2945
How to insert value to a one2many field in table with create method? 解決済
python
アバター
アバター
アバター
アバター
アバター
5
7月 25
232029
Is it possible to get data in stock.picking from invoice?
python invoicing stock.picking odoo-13
アバター
アバター
1
8月 23
5438