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

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

Contract - List-View Performance gets quite slow with many contracts / open tasks for invoicing

invoice contracts

1 Beantwoorden

4861 Weergaven

Stefan Wailand

I noticed quite long waiting times for the list view to contracts (account.analytic.account) having many tasks open for invoicing.

What is the best way to deal with this. I check PostgreSQL activity - but there are no bad queries. Everything is in Odoo in "function fields" or in the ORM-Layer.

For now I found a quick solution: I just gave my own user the right "Analytic Accounting" and then I found the menu: Accounting/Configuration/Analytic Accounting/Analytic Accounts

--> This list-view is perfectly fast since it doesn't sum up all open tasks.

Milos Miletic

Your problem might be that you are using too many function fields in list view, and your list might be too long.
Recommendation in technical memento is not to use function fields, but if you do i would recommend to use stored=True attribute in function field.

Best regards

Stefan Wailand

Auteur

actually this is not view we wrote - it is the standard of Odoo for contracts. Probably I should file a bug on Github since this view is using function fields. And I guess you are right - the function fields are causing the problems. But you couldn't use stored=True since each task in timesheet (with an analytic account that is a contract) will change the value and the value wouldn't be accurate as a stored one.

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
invoicing advance of expenses? invoice expenses contracts	1 mrt. 15	4002
Record time in hours and show days on invoice? invoice timesheet contracts	1 mrt. 15	6300
change between 2 Invoice formats Opgelost invoice	1 jul. 25	1768
Hello, how can I change the size of the logo and the invoice? Opgelost invoice	2 jul. 25	2150
Validation Error. You will need to clear the Journal Entry's Number to proceed invoice	1 jul. 25	3092

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!