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	Odpovědi	Zobrazení
Odoo auto updates for on-premises Enterprise version (cloud/ in-house server) - v10 v11 v12 Vyřešeno update	2 kvě 24	6641
Product process cost from planned operation duration Vyřešeno cost	1 dub 22	2398
odoo module update error Vyřešeno update	1 led 20	6313
How to update a field in recordset v10? Vyřešeno update	2 čvc 17	7648
How to update Odoo update	1 led 16	3772

This question has been flagged

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