OCA Days 2020 - Joan Sisquella: Refactoring of OCA financial reports
Channel: Odoo Community Association
Date: 28/10/2020

Financial Reports are vital for management to make decisions about the company’s future giving information about the profitability and financial stability of the company. 
ForgeFlow works with clients with very large databases, this caused problems when using financial reports since they took many minutes to calculate or gave errors due to timeout. This created the need to refactor the financial reports to improve their performance. The purpose was not to use transient models due to the collapse that occurred when a huge number of records were run. Also, not using direct SQL means that the code is more readable, and can be more easily extended.
Joan Sisquella Andrés is a technical consultant at Forgeflow. He has been involved in several Odoo projects, one of them the OCA financial reports refactoring. He is also a demand-driven planner professional.