Can I access contribution registers in payroll rules?

Question

Some deductions have a yearly limit per employee. Is there away to check these registers within a salary rule to determine if the maximum has been paid?

To elaborate:

In Canada we have two limited deductions, one of which is EI (employment Insurance) which deducts 1.88% of the total payslip up to a maximum of $891.12 within the year after which the deduction stops. In order to achieve this I am looking to add a Python Expression under condition that grabs the total contributions over the year

Nicholas Linn · Accepted Answer

Okay found this out for myself under the example above, the following conditional statement will work assuming the rule name is EI:

result = payslip.sum('EI','2013-01-01',' 2013-12-31') > -891.12

Still would be nice not to have to change the formula every year. Any ideas?

Bit of a hack but you can use the contract start and end date to define the fiscal year:

result = payslip.sum('EI',contract.date_start,contract.date_end) > -891.12

Mustufa Rangwala (mra) · Answer

You can do analysis on Payslip lines with by grouping on contribution register and employee..
Or you have to go to Payroll Register report.

Answer

This issue is solved with module hr_salary_rule_variable on https://github.com/OCA/hr/tree/7.0. Salary rules point on variables that change over the time. The whole salary structure for Canada is implemented and is currently in a PR to OCA: https://github.com/OCA/l10n-canada/pull/43. Reviews would be very appreciated.

İlgili Gönderiler	Cevaplar	Görünümler
Payroll Module in openerp hr v7 payroll	1 Eyl 17	6841
Ontario Payroll glitch v7 payroll ontario	3 Mar 15	4927
Batches of pay slips Çözüldü payroll	1 Eyl 25	894
How to add a "Delete" button on the popup form? Çözüldü v7	1 Eki 25	5519
payroll payroll	1 May 25	2280

Bu soru işaretlendi

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