_inherit = 'res.partner'

overdue_invoice_ids = fields.One2many('account.invoice', 'partner_id', 'Overdue Invoices', readonly=True,
                                      domain=[('state', 'in', ['open']), ('type', 'in', ['out_invoice']),
                                              ('date_due', '<', fields.Date.context_today)])

<field name="overdue_invoice_ids" nolabel="1">
    <tree string="Invoice">
        <field name="date_invoice"/>
        <field name="number"/>
        <field name="commercial_partner_id" invisible="1"/>
        <field name="reference" invisible="1"/>
        <field name="name" invisible="1"/>
        <field name="date_due"/>
        <field name="origin"/>
        <field name="amount_untaxed" string="Tax Excluded" sum="Total"/>
        <field name="amount_tax" sum="Total"/>
        <field name="amount_total_signed" string="Total" sum="Total"/>
        <field name="residual_signed" string="Amount Due" sum="Amount Due"/>
        <field name="currency_id" invisible="1"/>
        <field name="company_currency_id" invisible="1"/>
        <field name="state"/>
        <field name="type" invisible="context.get('type',True)"/>
    </tree>
</field>

thanhps

ผู้เขียน คำตอบที่ดีที่สุด

I tried to resolve it by myself and luckily it works.

Here is my solution in model, with nothing change in view:

_inherit = 'res.partner'

@api.model
def _get_overdue_invoices(self):
    today = fields.Date.context_today(self).strftime('%Y-%m-%d')
    self.overdue_invoice_ids = self.env['account.invoice'].search(
        [['state', '=', 'open'], ['type', '=', 'out_invoice'], ['date_due', '<', today]])

overdue_invoice_ids = fields.One2many('account.invoice', 'partner_id', 'Overdue Invoices',
                                      compute='_get_overdue_invoices')

Thanks all for your help!

Jainesh Shah(Aktiv Software)

Hello @ThanhPs,

You can use this,

domain=[('state', 'in', ['open']), ('type', 'in', ['out_invoice']),('date_due', '<', context_today().strftime('%Y-%m-%d'))]

Regards,

Email: odoo@aktivsoftware.com

Skype: kalpeshmaheshwari

thanhps

ผู้เขียน

@Aktiv software,

Thank you for your quick response! I already tried it but it seems valid in view only.

I am trying to add these domain in a model then it showed an error.

NameError: name 'context_today' is not defined

I also tried with ('date_due', '<', fields.Date.context_today) but it showed a SQL error:

ERROR: invalid input syntax for type date: "<function Date.context_today at 0x00000228D18407B8>"

LINE 1: ...invoice'))) AND ("account_invoice"."date_due" < '<function...

faOtools

context_today is a method, you should add '()'. Otherwise you compare string to built-in method. So:

('date_due', '<', fields.Date.context_today())

UPDATE:yes, context_today requires a record to check timezone. Hence, it might be used only 
in methods where you have self (recordset). In domain you can do it through lambda, like lamda self: self.env.user
(not sure about syntax here)

However, I guess it is better to use  today() instead of context_today, which doesn't require timezone.
I guess, timezone is not a big deal in your case:
('date_due', '<', fields.Date.today())

thanhps

ผู้เขียน

@Odoo Tools

I tried it and still got an error, because I don't have something like 'self' as an argument:

This below is the error message:

('date_due', '<', fields.Date.context_today())])

TypeError: context_today() missing 1 required positional argument: 'record'

faOtools

Have a look at the answer update

thanhps

ผู้เขียน

Thank you so much for your help!

However, I prefer to use date with timezone in my case.

I updated my answer, take a look at it, pls.

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
Open an invoice using XMLRPC invoice odoo12	2 พ.ค. 20	5826
How to modify validated invoice? invoice odoo12	2 พ.ย. 18	4993
How to control auto post for journal entry comes from invoices in Odoo12? invoice journal_entry odoo12	0 ม.ค. 22	4238
Odoo12: TypeError: post() got an unexpected keyword argument 'invoice' แก้ไขแล้ว invoice typeerror odoo12	3 ก.พ. 20	17367
[v12] propagate custom field from invoice to invoice report invoice invoicereport odoo12	3 ธ.ค. 19	5478

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!