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/

Powiązane posty	Odpowiedzi	Widoki
Odoo auto updates for on-premises Enterprise version (cloud/ in-house server) - v10 v11 v12 Rozwiązane update	2 maj 24	6629
Product process cost from planned operation duration Rozwiązane cost	1 kwi 22	2389
odoo module update error Rozwiązane update	1 sty 20	6290
How to update a field in recordset v10? Rozwiązane update	2 lip 17	7614
How to update Odoo update	1 sty 16	3749

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!