跳至內容
此問題已被標幟
pythonodoo-13
2 回覆
6698 瀏覽次數
頭像
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
1379
What means "Too many values to unpack" message? 已解決
python
頭像
頭像
頭像
頭像
頭像
4
4月 24
174294
have no data in screen. read data in my own module from different model
python
頭像
0
12月 23
2173
How to insert value to a one2many field in table with create method? 已解決
python
頭像
頭像
頭像
頭像
頭像
5
7月 25
228094
Is it possible to get data in stock.picking from invoice?
python invoicing stock.picking odoo-13
頭像
頭像
1
8月 23
4592