Currently, we are experiencing an issue with the sales validation process On Odoo 14. Here's how the process works:
- Sales are generated from four different branches and synced to the main database.
- A scheduled action is set to validate the sales every evening. However, during the daytime, there is another sync scheduled action running.
- The validation scheduled action is responsible for validating the sales, confirming them, and delivering the products. We follow a policy where an invoice is created and validated after the delivery.
- To perform these actions, we utilize action buttons on the sales quotation, sales order, delivery, and invoice.
- We employ real-time inventory valuation, which means a valuation is created for each sale.
The problem we are currently facing is that the validation process is taking a significant amount of time. On average, we are able to validate fewer than 700 sales per night, while we have a backlog of approximately 130,951 sales that still need validation.
imit_memory_hard = 167772160066
limit_memory_soft = 62914560066
limit_request = 8192
limit_time_cpu = 600000
limit_time_real = 1200000
max_cron_threads = 2
workers=8 # Previously 13
CPU 6 core
RAM 16 GB