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/

İlgili Gönderiler	Cevaplar	Görünümler
Odoo auto updates for on-premises Enterprise version (cloud/ in-house server) - v10 v11 v12 Çözüldü update	2 May 24	6693
Product process cost from planned operation duration Çözüldü cost	1 Nis 22	2431
odoo module update error Çözüldü update	1 Oca 20	6338
How to update a field in recordset v10? Çözüldü update	2 Tem 17	7682
How to update Odoo update	1 Oca 16	3799

Bu soru işaretlendi

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