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/

Related Posts	Replies	Views
Odoo auto updates for on-premises Enterprise version (cloud/ in-house server) - v10 v11 v12 Solved update	2 May 24	6572
Product process cost from planned operation duration Solved cost	1 Apr 22	2313
odoo module update error Solved update	1 Jan 20	6239
How to update a field in recordset v10? Solved update	2 Jul 17	7550
How to update Odoo update	1 Jan 16	3707

This question has been flagged

Enjoying the discussion? Don't just read, join in!