I'm trying to find all paid customer invoices that were paid after the due date.
Is there a way to create a filter to find these invoices?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I'm trying to find all paid customer invoices that were paid after the due date.
Is there a way to create a filter to find these invoices?
Not a direct solution, and maybe not the best approach, but here's an idea to achieve similar result (I once had similar requirement).
Create a field of function type (fields.function) which check several values in the account.invoice object (and another related objects such as payment -> account.move.line) and compare these values:
Beware that this would probably slows down tree view a bit.
Another idea and probably a better approach is to write the paid_date to account.invoice when the state changes from 'open' to 'paid'. I don't know but it may also be possible to check the wkf_item object checking it's workflow transformation date, could someone confirm this?
أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!
تسجيلالمنشورات ذات الصلة | الردود | أدوات العرض | النشاط | |
---|---|---|---|---|
|
1
ديسمبر 17
|
13684 | ||
how to get url of current page
تم الحل
|
|
2
ديسمبر 23
|
22679 | |
field.function in tree view
تم الحل
|
|
2
يناير 24
|
13700 | |
|
1
مارس 15
|
4232 | ||
|
0
مارس 15
|
3882 |