How can I retroactively update Timesheets when I know the true loaded hourly cost of Employees?

Question

Our employees have a fixed monthly salary, but at the end of the month, we need to retroactively adjust the hourly cost for each employee in order to reflect the real company cost.
This is because the number of hours worked by each employee varies from month to month, and the company benefit burden varies, so the real hourly cost is only known once payroll is known.
What is the easiest way to retroactively update all of the Timesheets so the real hourly cost can be applied?

Ray Carnes (ray) · Accepted Answer

You have two options:
1) Export all Timesheets, update them outside of Odoo, then re-import then.
2) Create a Server Action with a line of code to do it on demand:
image [1]
record.unit_amount * record.employee_id.hourly_cost or 0 Click Create Contextual Action to make it available from the Action Menu
Add the relevant Allowed Groups to secure this feature.

You would then select the Timesheets you need to update and the new cost would be applied based on the then current rate.

[1] /web/image/

Publicaciones relacionadas	Respuestas	Vistas
Odoo auto updates for on-premises Enterprise version (cloud/ in-house server) - v10 v11 v12 Resuelto update	2 may 24	6564
Product process cost from planned operation duration Resuelto cost	1 abr 22	2309
odoo module update error Resuelto update	1 ene 20	6235
How to update a field in recordset v10? Resuelto update	2 jul 17	7548
How to update Odoo update	1 ene 16	3700

Se marcó esta pregunta

¿Le interesa esta conversación? ¡Participe en ella!