Help

2

Best way to include YTD totals on Payslip?

Avatar
Nicholas Linn

We are looking for in addition to the payslip totals for the given pay period, Year to date totals for the given deductions. What would be the best way of going about this on the reports? Could it be done by just modifing the report or would it require changes to the python module code as well?

3 Comments
Avatar
Discard
Avatar
Maxime Chambreuil
-

Hello Nicholas, if you are interested by the canadian payroll, you may want to join and contribute to the OpenERP Canada project. There are people already working on it : https://launchpad.net/openerp-canada

Avatar
Nicholas Linn
-

Sure, I am just cleaning up my some code and should have something shortly. I have requested to join.

Avatar
Maxime Chambreuil
-

You have been accepted. johnb has started a module for the ontario payroll (l10n_ca_on_hr_payroll). Please contact him.

1 Answer
3
Best Answer

Hi Nicholas,

Originally posted by Mustufa Rangwala on OpenERP community list

To calculate YTD Income you can use sum method on available objects in your expression.

sum() method available for three objects/variables i.e.payslip, worked_days, inputs.

They are : payslip.sum(code, from_date, to_date) worked_days.sum(code, from_date, to_date), inputs.sum(code, from_date, to_date)

Where Code is Salary rule code and Dates are begin and Ending Date (Start Period and Current Period dates.)

For example: If you want to sum all gross amount between Jan to Dec 2012. You can just create one salary rule with expression payslip.sum('GROSS', 01/01/2012, 31/12/2012).

4 Comments
Avatar
Discard
Avatar
Nicholas Linn
-

I know and use that within salary rules for calculating maximum contributions. However when I try to add that code directly into the report (in openoffice) it doesn't work. I assume that I have to modify the python code of the report?

If you are just need to see the print of that payslip rule/payslip lines on the report it will come automatically with Report, But if you want to use that code you need to change the python code. Can you tell me what report you want to modify ?

Avatar
Nicholas Linn
-

The goal is the modify "Employee Payslip" to show YTD totals of each line in a new column next to the payslip line total.

Ok, You need to modify the your report for that..