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?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
8
Replies
10633
Views
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).
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 ?
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..
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
Sure, I am just cleaning up my some code and should have something shortly. I have requested to join.
You have been accepted. johnb has started a module for the ontario payroll (l10n_ca_on_hr_payroll). Please contact him.