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:
- CRM
- e-Commerce
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
1
Beantwoorden
6985
Weergaven
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:
- state
- date_due
- account_move_line.date (many2many)
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?
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden| Gerelateerde posts | Antwoorden | Weergaven | Activiteit | |
|---|---|---|---|---|
|
1
dec. 17
|
14440 | ||
|
how to get url of current page
Opgelost
|
|
2
dec. 23
|
23605 | |
|
field.function in tree view
Opgelost
|
|
2
jan. 24
|
14502 | |
|
1
mrt. 15
|
4927 | ||
|
0
mrt. 15
|
4584 |
