1
=== added directory 'l10n_ca_account_fiscal_position_rule/static'
2
=== added directory 'l10n_ca_account_fiscal_position_rule/static/src'
3
=== added directory 'l10n_ca_account_fiscal_position_rule/static/src/img'
4
=== added file 'l10n_ca_account_fiscal_position_rule/static/src/img/icon.png'
5
0
Binary files l10n_ca_account_fiscal_position_rule/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and l10n_ca_account_fiscal_position_rule/static/src/img/icon.png	2012-12-21 16:45:28 +0000 differ
0
Binary files l10n_ca_account_fiscal_position_rule/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and l10n_ca_account_fiscal_position_rule/static/src/img/icon.png	2012-12-21 16:45:28 +0000 differ
6
=== added directory 'l10n_ca_hr_payroll'
7
=== added file 'l10n_ca_hr_payroll/AUTHORS.txt'
8
--- l10n_ca_hr_payroll/AUTHORS.txt	1970-01-01 00:00:00 +0000
9
+++ l10n_ca_hr_payroll/AUTHORS.txt	2012-12-21 16:45:28 +0000
10
@@ -0,0 +1,4 @@
11
1
Amura Consulting
12
2
Pierre Lamarche <pierre.lamarche@savoirfairelinux.com>
13
3
Maxime Chambreuil <maxime.chambreuil@savoirfairelinux.com>
14
4
Savoir-faire Linux <contact@savoirfairelinux.com>
15
0
5
16
=== added file 'l10n_ca_hr_payroll/__init__.py'
17
--- l10n_ca_hr_payroll/__init__.py	1970-01-01 00:00:00 +0000
18
+++ l10n_ca_hr_payroll/__init__.py	2012-12-21 16:45:28 +0000
19
@@ -0,0 +1,24 @@
20
1
#-*- coding:utf-8 -*-
21
2
##############################################################################
22
3
#
23
4
#    Copyright (C) 2012 OpenERP Canada. All Rights Reserved.
24
5
#
25
6
#    This program is free software: you can redistribute it and/or modify
26
7
#    it under the terms of the GNU Affero General Public License as published
27
8
#    by
28
9
#    the Free Software Foundation, either version 3 of the License, or
29
10
#    (at your option) any later version.
30
11
#
31
12
#    This program is distributed in the hope that it will be useful,
32
13
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
33
14
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
34
15
#    GNU Affero General Public License for more details.
35
16
#
36
17
#    You should have received a copy of the GNU Affero General Public License
37
18
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
38
19
#
39
20
##############################################################################
40
21
41
22
import l10n_ca_hr_payroll
42
23
43
24
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
44
0
25
45
=== added file 'l10n_ca_hr_payroll/__openerp__.py'
46
--- l10n_ca_hr_payroll/__openerp__.py	1970-01-01 00:00:00 +0000
47
+++ l10n_ca_hr_payroll/__openerp__.py	2012-12-21 16:45:28 +0000
48
@@ -0,0 +1,50 @@
49
1
#-*- coding:utf-8 -*-
50
2
##############################################################################
51
3
#
52
4
#    Copyright (C) 2012 OpenERP Canada. All Rights Reserved.
53
5
#
54
6
#    This program is free software: you can redistribute it and/or modify
55
7
#    it under the terms of the GNU Affero General Public License as published by
56
8
#    the Free Software Foundation, either version 3 of the License, or
57
9
#    (at your option) any later version.
58
10
#
59
11
#    This program is distributed in the hope that it will be useful,
60
12
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
61
13
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
62
14
#    GNU Affero General Public License for more details.
63
15
#
64
16
#    You should have received a copy of the GNU Affero General Public License
65
17
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
66
18
#
67
19
##############################################################################
68
20
{
69
21
    'name': 'Canada - Payroll',
70
22
    'category': 'Localization',
71
23
    'version': '0.1',
72
24
    'license': 'AGPL-3',
73
25
    'category': 'Generic Modules/Human Resources',
74
26
    'description': """
75
27
Canada Payroll Rules
76
28
==============================
77
29
 * Adds Federal Salary Rules
78
30
 * Adds Federal Salary Structure
79
31
 * Adds Federal Claim Codes, Deductions and Exemptions on the Employee Form
80
32
 * Adds 'Pays Per Year' field on the Contract Form
81
33
    """,
82
34
    'author':'OpenERP Canada',
83
35
    'website':'http://launchpad.net/openerp-canada',
84
36
    'depends': [
85
37
        'hr_payroll',
86
38
        'l10n_ca_toponyms',
87
39
    ],
88
40
    'data': [
89
41
        'l10n_ca_hr_payroll_view.xml',
90
42
        'l10n_ca_hr_payroll_data.xml',
91
43
    ],
92
44
    'test': [],
93
45
    'demo': [],
94
46
    'installable': True,
95
47
    'active': False,
96
48
}
97
49
98
50
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
99
0
51
100
=== added file 'l10n_ca_hr_payroll/l10n_ca_hr_payroll.py'
101
--- l10n_ca_hr_payroll/l10n_ca_hr_payroll.py	1970-01-01 00:00:00 +0000
102
+++ l10n_ca_hr_payroll/l10n_ca_hr_payroll.py	2012-12-21 16:45:28 +0000
103
@@ -0,0 +1,260 @@
104
1
#-*- coding:utf-8 -*-
105
2
##############################################################################
106
3
#
107
4
#    Copyright (C) 2012 Amura Consulting. All Rights Reserved.
108
5
#
109
6
#    This program is free software: you can redistribute it and/or modify
110
7
#    it under the terms of the GNU Affero General Public License as published
111
8
#    by
112
9
#    the Free Software Foundation, either version 3 of the License, or
113
10
#    (at your option) any later version.
114
11
#
115
12
#    This program is distributed in the hope that it will be useful,
116
13
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
117
14
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
118
15
#    GNU Affero General Public License for more details.
119
16
#
120
17
#    You should have received a copy of the GNU Affero General Public License
121
18
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
122
19
#
123
20
##############################################################################
124
21
125
22
from osv import fields, osv
126
23
127
24
def get_jurisdiction(self, cursor, user_id, context=None):
128
25
    return (
129
26
        ('federal', 'Federal'),
130
27
        ('provincial', 'Provincial'))
131
28
132
29
def get_type(self, cursor, user_id, context=None):
133
30
    return (
134
31
        ('federal', 'Federal'),
135
32
        ('ei', 'Employment Insurance'),
136
33
        ('qc', 'Quebec'),
137
34
        ('rqap', 'RQAP / RRQ'),
138
35
        ('csst', 'CSST'))
139
36
140
37
class hr_payroll_tax_table(osv.osv):
141
38
    '''
142
39
    Canadian Tax Payroll Table
143
40
    '''
144
41
    _name = 'hr.payroll.tax.table'
145
42
    _description = 'Canadian Tax Payroll Table'
146
43
147
44
    def onchange_year(self, cr, uid, ids, year, prov=False):
148
45
        res = {}
149
46
        res['name'] = 'Tax Table: ' + str(year)
150
47
        if prov:
151
48
            prov_obj = self.pool.get('res.country.state').browse(cr, uid, prov)
152
49
            res['name'] += ' / Provincial - ' + prov_obj.code
153
50
        else:
154
51
            res['name'] += ' / Federal'
155
52
156
53
        return {'value': res}
157
54
        
158
55
    _columns = {
159
56
            'name': fields.char('Description', size=128),
160
57
            'year': fields.integer('Year', required=True),
161
58
            'date_from': fields.date('Date From'),
162
59
            'date_to': fields.date('Date To'),
163
60
            'jurisdiction': fields.selection(get_jurisdiction, 'Jurisdiction', required=True),
164
61
            'state_id': fields.many2one('res.country.state', 'Province'),
165
62
            'type': fields.selection(get_type, 'Type', required=True),
166
63
            'line_federal_ids': fields.one2many('hr.payroll.tax.table.federal.line', 'table_id', 'Lines'),
167
64
            'line_ei_ids': fields.one2many('hr.payroll.tax.table.ei.line', 'table_id', 'Lines'),
168
65
            'line_qc_ids': fields.one2many('hr.payroll.tax.table.qc.line', 'table_id', 'Lines'),
169
66
            'line_rqap_ids': fields.one2many('hr.payroll.tax.table.rqap.line', 'table_id', 'Lines'),
170
67
            'line_csst_ids': fields.one2many('hr.payroll.tax.table.csst.line', 'table_id', 'Lines'),
171
68
            }
172
69
173
70
    _defaults = {
174
71
            'jurisdiction': 'federal',
175
72
            'type': 'federal',
176
73
            }
177
74
178
75
hr_payroll_tax_table()
179
76
180
77
class hr_payroll_tax_table_federal_line(osv.osv):
181
78
    '''
182
79
    Federal Lines
183
80
    '''
184
81
    _name = 'hr.payroll.tax.table.federal.line'
185
82
    _description = 'Federal Lines'
186
83
    _columns = {
187
84
        'table_id': fields.many2one('hr.payroll.tax.table', 'Table'),
188
85
        'inc_from': fields.float('Income From', digits=(16, 2), required=True),
189
86
        'inc_to': fields.float('Income To', digits=(16, 2), required=True),
190
87
        'code0': fields.float('Code 0', digits=(16, 2)),
191
88
        'code1': fields.float('Code 1', digits=(16, 2)),
192
89
        'code2': fields.float('Code 2', digits=(16, 2)),
193
90
        'code3': fields.float('Code 3', digits=(16, 2)),
194
91
        'code4': fields.float('Code 4', digits=(16, 2)),
195
92
        'code5': fields.float('Code 5', digits=(16, 2)),
196
93
        'code6': fields.float('Code 6', digits=(16, 2)),
197
94
        'code7': fields.float('Code 7', digits=(16, 2)),
198
95
        'code8': fields.float('Code 8', digits=(16, 2)),
199
96
        'code9': fields.float('Code 9', digits=(16, 2)),
200
97
        'code10': fields.float('Code 10', digits=(16, 2)),
201
98
        }
202
99
203
100
    _rec_name = 'inc_from'
204
101
205
102
hr_payroll_tax_table_federal_line()
206
103
207
104
class hr_payroll_tax_table_ei_line(osv.osv):
208
105
    '''
209
106
    Employment Insurance Lines
210
107
    '''
211
108
    _name = 'hr.payroll.tax.table.ei.line'
212
109
    _description = 'Employment Insurance Lines'
213
110
    _columns = {
214
111
        'table_id': fields.many2one('hr.payroll.tax.table', 'Table'),
215
112
        'inc_from': fields.float('Income From', digits=(16, 2), required=True),
216
113
        'inc_to': fields.float('Income To', digits=(16, 2), required=True),
217
114
        'rate': fields.float('Rate', digits=(16, 2), required=True),
218
115
        'max_annual_insurable_earnings': fields.float('Maximum Annual Insurable Earnings', digits=(16, 2), required=True),
219
116
        }
220
117
221
118
    _rec_name = 'inc_from'
222
119
223
120
hr_payroll_tax_table_ei_line()
224
121
225
122
class hr_payroll_tax_table_qc_line(osv.osv):
226
123
    '''
227
124
    Quebec Lines
228
125
    '''
229
126
    _name = 'hr.payroll.tax.table.qc.line'
230
127
    _description = 'Quebec Lines'
231
128
    _columns = {
232
129
        'table_id': fields.many2one('hr.payroll.tax.table', 'Table'),
233
130
        'inc_from': fields.float('Income From', digits=(16, 2), required=True),
234
131
        'inc_to': fields.float('Income To', digits=(16, 2), required=True),
235
132
        'code0': fields.float('Code 0', digits=(16, 2)),
236
133
        'codeA': fields.float('Code A', digits=(16, 2)),
237
134
        'codeB': fields.float('Code B', digits=(16, 2)),
238
135
        'codeC': fields.float('Code C', digits=(16, 2)),
239
136
        'codeD': fields.float('Code D', digits=(16, 2)),
240
137
        'codeE': fields.float('Code E', digits=(16, 2)),
241
138
        'codeF': fields.float('Code F', digits=(16, 2)),
242
139
        'codeG': fields.float('Code G', digits=(16, 2)),
243
140
        'codeH': fields.float('Code H', digits=(16, 2)),
244
141
        'codeI': fields.float('Code I', digits=(16, 2)),
245
142
        'codeJ': fields.float('Code J', digits=(16, 2)),
246
143
        'codeK': fields.float('Code K', digits=(16, 2)),
247
144
        'codeL': fields.float('Code L', digits=(16, 2)),
248
145
        'codeM': fields.float('Code M', digits=(16, 2)),
249
146
        'codeN': fields.float('Code N', digits=(16, 2)),
250
147
        'codeY': fields.float('Code Y', digits=(16, 2)),
251
148
        'codeZ': fields.float('Code Z', digits=(16, 2)),
252
149
        }
253
150
254
151
    _rec_name = 'inc_from'
255
152
256
153
hr_payroll_tax_table_qc_line()
257
154
258
155
class hr_payroll_tax_table_rqap_line(osv.osv):
259
156
    '''
260
157
    RQAP Lines
261
158
    '''
262
159
    _name = 'hr.payroll.tax.table.rqap.line'
263
160
    _description = 'RQAP Lines'
264
161
    _columns = {
265
162
        'table_id': fields.many2one('hr.payroll.tax.table', 'Table'),
266
163
        'inc_from': fields.float('Income From', digits=(16, 2), required=True),
267
164
        'inc_to': fields.float('Income To', digits=(16, 2), required=True),
268
165
        'employee_contrib': fields.float('Employee contribution', digits=(16, 2)),
269
166
        'employer_contrib': fields.float('Employer contribution', digits=(16, 2)),
270
167
        'max_annual_insurable_earnings': fields.float('Maximum Annual Insurable Earnings', digits=(16, 2)),
271
168
        }
272
169
273
170
hr_payroll_tax_table_rqap_line()
274
171
275
172
class hr_payroll_tax_table_csst_line(osv.osv):
276
173
    '''
277
174
    CSST Lines
278
175
    '''
279
176
    _name = 'hr.payroll.tax.table.csst.line'
280
177
    _description = 'CSST Lines'
281
178
    _columns = {
282
179
        'name': fields.char('Name', size=256, required=True),
283
180
        'table_id': fields.many2one('hr.payroll.tax.table', 'Table'),
284
181
        }
285
182
286
183
hr_payroll_tax_table_csst_line()
287
184
288
185
class hr_employee(osv.osv):
289
186
    _name = 'hr.employee'
290
187
    _inherit = 'hr.employee'
291
188
292
189
    _columns = {
293
190
        'ei_exempt': fields.boolean('EI Exempt'),
294
191
        'td1f': fields.selection([('code1',1),('code2',2),('code3',3),('code4',4),('code5',5),('code6',6),('code7',7),('code8',8),('code9',9),('code10',10),('code0',0)], 'Federal Claim Code', required=True),
295
192
        'td1p': fields.selection([('codeA','A'),('codeB','B'),('codeC','C'),('codeD','D'),('codeE','E'),('codeF','F'),('codeG','G'),('codeH','H'),('codeI','I'),('codeJ','J'),('codeK','K'),('codeL','L'),('codeM','M'),('codeN','N'),('codeY','Y'),('codeZ','Z'),('code0',0)], 'Provincial Claim Code', required=True),
296
193
        'cpp_exempt': fields.boolean('CPP/QPP Exempt'),
297
194
        'qpip_exempt': fields.boolean('QPIP Exempt'),
298
195
        'cpp_ytd_adj': fields.float('CPP/QPP YTD Adjustment', help="Amount to adjust CPP/QPP for calculations. Used if employee has contributed elsewhere and will be factored in when calculating maximum CPP payment"),
299
196
        'ei_ytd_adj': fields.float('EI YTD Adjustment', help="Amount to adjust EI for calculations. Used if employee has contributed elsewhere and will be factored in when calculating maximum EI payment"),
300
197
        'vac_pay': fields.float('Vacation Pay %', digits=(16,2)),
301
198
        'f1': fields.float('Childcare/Alimony (F1)', digits=(16,2), help="Annual deductions such as child care expenses and support payments, etc., authorized by a tax services office or tax centre"),
302
199
        'f2': fields.float('Alimony/Maint Garnish (F2)', digits=(16,2), help="Alimony or maintenance payments required by a legal document to be payroll-deducted authorized by a tax services office or tax centre"),
303
200
        'hd': fields.float('Prescribed Zone (HD)', digits=(16,2), help="Annual deduction for living in a prescribed zone as indicated on Form TD1"),
304
201
        'lcf': fields.float('Fed Labour sponsored funds (LCF)', digits=(16,2), help="Federal labour-sponsored funds tax credit"),
305
202
        'lcp': fields.float('Prov Labour sponsored funds (LCP)', digits=(16,2), help="Provincial or territorial labour-sponsored funds tax credit"),
306
203
        'f': fields.float('RSP/RPP/RCA (F)', digits=(16,2), help="Payroll deductions for employee contributions to a registered pension plan (RPP), a registered retirement savings plan (RRSP), or a retirement compensation arrangement (RCA)"),
307
204
        'l': fields.float('Extra Tax Deductions (L)', digits=(16,2), help="Extra tax deductions requested for the pay period."),
308
205
        'k3': fields.float('Federal Medical (K3)', digits=(16,2), help="Other federal tax credits, such as medical expenses and charitable donations authorized by a tax services office or tax centre"),
309
206
        'u1': fields.float('Union Dues (U1)', digits=(16,2), help="Union dues"),
310
207
        'y': fields.float('MB/ON Extra Tax Reduction(Y)', digits=(16,2), help="Extra provincial or territorial tax reduction based on applicable amounts reported on the provincial or territorial Form TD1"),
311
208
        'td1': fields.float('Personal Tax Credits Return (TD1)', digits=(16,2), required=True, help="Personal Tax Credits Return"),
312
209
        'eeins': fields.float('Insurance - Employee Contribution (EeINS)', digits=(16,2), required=True),
313
210
        'erins': fields.float('Insurance - Employer Contribution (ErINS)', digits=(16,2), required=True),
314
211
            }
315
212
316
213
    _defaults = {
317
214
        'td1f': 'code1',
318
215
        'td1p': 'codeA',
319
216
        'td1': 10822.00,
320
217
        'eeins': 0.00,
321
218
        'erins': 0.00,
322
219
        }
323
220
324
221
hr_employee()
325
222
326
223
class hr_contract(osv.osv):
327
224
    _inherit = 'hr.contract'
328
225
329
226
    def _get_pays_per_year(self, cr, uid, ids, names, arg, context=None):
330
227
        """
331
228
        @param ids: ID of contract
332
229
        @return: The number of pays per year
333
230
        """
334
231
        res = {}
335
232
        #FIXME: Should likely pull these values from somewhere else, depending on whether a 52 or 53 year week is used
336
233
        schedule_pay = {
337
234
            'weekly': 52,
338
235
            'bi-weekly': 26,
339
236
            'monthly': 12,
340
237
            'bi-monthly': 6,
341
238
            'quarterly': 4,
342
239
            'semi-annually': 2,
343
240
            'annually': 1,
344
241
            }
345
242
        for contract in self.browse(cr, uid, ids, context):
346
243
            if contract.schedule_pay and schedule_pay.get(contract.schedule_pay, False):
347
244
                res[contract.id] = schedule_pay[contract.schedule_pay]
348
245
349
246
        return res
350
247
351
248
    _columns = {
352
249
        'pays_per_year': fields.function(_get_pays_per_year, method=True, string='Pays Per Year', type='float', readonly=True),
353
250
        'weeks_of_vacation': fields.integer('Number of weeks of vacation', required=True),
354
251
        }
355
252
356
253
    _defaults = {
357
254
        'weeks_of_vacation': 2,
358
255
        }
359
256
360
257
hr_contract()
361
258
362
259
            
363
260
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
364
0
261
365
=== added file 'l10n_ca_hr_payroll/l10n_ca_hr_payroll_data.xml'
366
--- l10n_ca_hr_payroll/l10n_ca_hr_payroll_data.xml	1970-01-01 00:00:00 +0000
367
+++ l10n_ca_hr_payroll/l10n_ca_hr_payroll_data.xml	2012-12-21 16:45:28 +0000
368
@@ -0,0 +1,282 @@
369
1
<?xml version="1.0" encoding="utf-8"?>
370
2
<openerp>
371
3
    <data noupdate="1">
372
4
373
5
	<!-- Salary Rules Category -->
374
6
375
7
        <record id="I" model="hr.salary.rule.category">
376
8
            <field name="name">Taxable Income</field>
377
9
            <field name="code">I</field>
378
10
        </record>
379
11
380
12
        <record id="CALC" model="hr.salary.rule.category">
381
13
            <field name="code">CALC</field>
382
14
            <field name="name">Standard Calculation</field>
383
15
        </record>
384
16
385
17
        <record id="FCALC" model="hr.salary.rule.category">
386
18
            <field name="code">FCALC</field>
387
19
            <field name="name">Federal Calculation</field>
388
20
        </record>
389
21
390
22
        <record id="PCALC" model="hr.salary.rule.category">
391
23
            <field name="code">PCALC</field>
392
24
            <field name="name">Provincial Calculation</field>
393
25
        </record>
394
26
395
27
        <record id="EMP" model="hr.salary.rule.category">
396
28
            <field name="code">EMP</field>
397
29
            <field name="name">Employer Contribution</field>
398
30
        </record>
399
31
400
32
        <record id="SDED" model="hr.salary.rule.category">
401
33
            <field name="code">SDED</field>
402
34
            <field name="name">Source Deduction</field>
403
35
            <field name="note">Used for after tax deductions at source</field>
404
36
        </record>
405
37
406
38
        <record id="VAC" model="hr.salary.rule.category">
407
39
            <field name="code">VAC</field>
408
40
            <field name="name">Vacation Calculation</field>
409
41
        </record>
410
42
411
43
	<!-- Update salary rules of hr_payroll -->
412
44
413
45
        <record id="hr_payroll.hr_rule_basic" model="hr.salary.rule">
414
46
            <field name="appears_on_payslip" eval="0"/>
415
47
        </record>
416
48
417
49
        <record id="hr_payroll.hr_rule_taxable" model="hr.salary.rule">
418
50
            <field name="appears_on_payslip" eval="0"/>
419
51
        </record>
420
52
421
53
        <record id="hr_payroll.hr_rule_net" model="hr.salary.rule">
422
54
            <field name="amount_python_compute">result = BASICP + categories.ALW - categories.DED - categories.SDED</field>
423
55
        </record>
424
56
425
57
	<!-- Common rules to all canadian salary structures -->
426
58
427
59
        <record id="rule_ca_p" model="hr.salary.rule">
428
60
            <field name="name">Pays Per Year</field>
429
61
            <field name="sequence" eval="1"/>
430
62
            <field name="code">P</field>
431
63
            <field name="appears_on_payslip" eval="0"/>
432
64
            <field name="active" eval="1"/>
433
65
            <field name="category_id" ref="CALC"/>
434
66
            <field name="condition_select">none</field>
435
67
            <field name="amount_select">code</field>
436
68
            <field name="amount_python_compute">result = contract.pays_per_year or 0</field>
437
69
            <field name="note">Pays per year from the contract form</field>
438
70
        </record>
439
71
440
72
        <record id="rule_ca_pocc" model="hr.salary.rule">
441
73
            <field name="name">Payslip Counter (POCC)</field>
442
74
            <field name="sequence" eval="1"/>
443
75
            <field name="code">POCC</field>
444
76
            <field name="appears_on_payslip" eval="0"/>
445
77
            <field name="active" eval="1"/>
446
78
            <field name="category_id" ref="CALC"/>
447
79
            <field name="condition_select">none</field>
448
80
            <field name="amount_select">fix</field>
449
81
            <field name="quantity">1.0</field>
450
82
            <field name="amount_fix">1.0</field>
451
83
            <field name="note">Sloppy way of counting payslips for use in PR calc</field>
452
84
        </record>
453
85
454
86
        <record id="rule_ca_basic" model="hr.salary.rule">
455
87
            <field name="name">Basic per pay (BASICP)</field>
456
88
            <field name="sequence" eval="10"/>
457
89
            <field name="code">BASICP</field>
458
90
            <field name="appears_on_payslip" eval="1"/>
459
91
            <field name="active" eval="1"/>
460
92
            <field name="category_id" ref="CALC"/>
461
93
            <field name="condition_select">none</field>
462
94
            <field name="amount_select">code</field>
463
95
            <field name="amount_python_compute">result = BASIC / P</field>
464
96
        </record>
465
97
466
98
        <record id="rule_ca_gross" model="hr.salary.rule">
467
99
            <field name="name">Gross per pay (GROSSP)</field>
468
100
            <field name="sequence" eval="101"/>
469
101
            <field name="code">GROSSP</field>
470
102
            <field name="appears_on_payslip" eval="1"/>
471
103
            <field name="active" eval="1"/>
472
104
            <field name="category_id" ref="CALC"/>
473
105
            <field name="condition_select">none</field>
474
106
            <field name="amount_select">code</field>
475
107
            <field name="amount_python_compute">result = GROSS / P</field>
476
108
        </record>
477
109
478
110
	<!-- Employment Insurance - 140 -->
479
111
480
112
        <record id="rule_ca_ei_maxie" model="hr.salary.rule">
481
113
            <field name="name">EI - Maximum Insurable Earnings (EIMAXIE)</field>
482
114
            <field name="sequence" eval="140"/>
483
115
            <field name="code">EIMAXIE</field>
484
116
            <field name="appears_on_payslip" eval="0"/>
485
117
            <field name="active" eval="1"/>
486
118
            <field name="category_id" ref="FCALC"/>
487
119
            <field name="condition_select">none</field>
488
120
            <field name="amount_select">code</field>
489
121
            <field name="amount_python_compute">result = min(GROSS,45900)</field>
490
122
        </record>
491
123
492
124
	<!-- Employment Insurance - Employer - 145 -->
493
125
494
126
        <record id="rule_ca_ei_er_c" model="hr.salary.rule">
495
127
            <field name="name">EI - Employer - Contribution (EIERC)</field>
496
128
            <field name="sequence" eval="145"/>
497
129
            <field name="code">EIERC</field>
498
130
            <field name="category_id" ref="EMP"/>
499
131
            <field name="appears_on_payslip" eval="0"/>
500
132
            <field name="active" eval="1"/>
501
133
            <field name="condition_select">python</field>
502
134
            <field name="condition_python">result = not employee.ei_exempt</field>
503
135
            <field name="amount_select">percentage</field>
504
136
            <field name="amount_percentage_base">EIEEC</field>
505
137
            <field name="quantity">1.0</field>
506
138
            <field name="amount_percentage">140.0</field>
507
139
        </record>
508
140
509
141
        <record id="rule_ca_ei_er_pytdc" model="hr.salary.rule">
510
142
            <field name="name">EI - Employer - Previous Year To Date Contribution (EIERPYTDC)</field>
511
143
            <field name="sequence" eval="145"/>
512
144
            <field name="code">EIERPYTDC</field>
513
145
            <field name="category_id" ref="l10n_ca_hr_payroll.FCALC"/>
514
146
            <field name="appears_on_payslip" eval="0"/>
515
147
            <field name="active" eval="1"/>
516
148
            <field name="condition_select">none</field>
517
149
            <field name="amount_select">code</field>
518
150
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
519
151
date_to = payslip.date_to
520
152
result = payslip.sum('EIERYTDC',date_from,date_to)
521
153
            </field>
522
154
        </record>
523
155
524
156
        <record id="rule_ca_ei_er_ytdc" model="hr.salary.rule">
525
157
            <field name="name">EI - Employer - Year To Date Contribution (EIERYTDC)</field>
526
158
            <field name="sequence" eval="146"/>
527
159
            <field name="code">EIERYTDC</field>
528
160
            <field name="category_id" ref="l10n_ca_hr_payroll.FCALC"/>
529
161
            <field name="appears_on_payslip" eval="0"/>
530
162
            <field name="active" eval="1"/>
531
163
            <field name="condition_select">none</field>
532
164
            <field name="amount_select">code</field>
533
165
            <field name="amount_python_compute">result = EIERPYTDC + EIERC</field>
534
166
        </record>
535
167
536
168
	<!-- Federal Income Tax - 170 -->
537
169
538
170
        <record id="rule_ca_fit_rate" model="hr.salary.rule">
539
171
            <field name="name">FIT - Rate 16.5% (FITRATE)</field>
540
172
            <field name="sequence" eval="170"/>
541
173
            <field name="code">FITRATE</field>
542
174
            <field name="appears_on_payslip" eval="0"/>
543
175
            <field name="active" eval="1"/>
544
176
            <field name="category_id" ref="FCALC"/>
545
177
            <field name="condition_select">none</field>
546
178
            <field name="amount_select">fix</field>
547
179
            <field name="quantity">1.0</field>
548
180
            <field name="amount_fix">16.5</field>
549
181
        </record>
550
182
551
183
        <record id="rule_ca_fit_ti" model="hr.salary.rule">
552
184
            <field name="name">FIT - Taxable Income (FITTI)</field>
553
185
            <field name="sequence" eval="171"/>
554
186
            <field name="code">FITTI</field>
555
187
            <field name="appears_on_payslip" eval="0"/>
556
188
            <field name="active" eval="1"/>
557
189
            <field name="category_id" ref="FCALC"/>
558
190
            <field name="condition_select">none</field>
559
191
            <field name="amount_select">code</field>
560
192
            <field name="amount_python_compute">result = GROSS - (employee.td1 + QPIPEEMAXC + QPPEEMAXC + EIEEMAXC) * (1 + FITRATE * 0.01)</field>
561
193
        </record>
562
194
563
195
        <record id="rule_ca_fit" model="hr.salary.rule">
564
196
            <field name="name">FIT - Federal Income Tax (FIT)</field>
565
197
            <field name="sequence" eval="172"/>
566
198
            <field name="code">FIT</field>
567
199
            <field name="appears_on_payslip" eval="1"/>
568
200
            <field name="active" eval="1"/>
569
201
            <field name="category_id" ref="hr_payroll.DED"/>
570
202
            <field name="condition_select">none</field>
571
203
            <field name="amount_select">code</field>
572
204
            <field name="amount_python_compute">if FITTI &gt;= 132407:
573
205
    res = (FITTI - 132407) * 0.29 + (132407-85415) * 0.26 + (85414-42708) * 0.22 + 42707 * 0.15
574
206
if FITTI &gt;= 85415 and FITTI &lt; 132407:
575
207
    res = (FITTI - 85415) * 0.26 + (85414-42708) * 0.22 + 42707 * 0.15
576
208
if FITTI &gt;= 42708 and FITTI &lt; 85414:
577
209
    res = (FITTI - 42708) * 0.22 + 42707 * 0.15
578
210
if FITTI &lt; 42707:
579
211
    res = FITTI * 0.15
580
212
result = res / P
581
213
	    </field>
582
214
        </record>
583
215
584
216
        <record id="rule_ca_fit_ytd" model="hr.salary.rule">
585
217
            <field name="name">FIT - Year To Date (FITYTD)</field>
586
218
            <field name="sequence" eval="173"/>
587
219
            <field name="code">FITYTD</field>
588
220
            <field name="category_id" ref="FCALC"/>
589
221
            <field name="appears_on_payslip" eval="1"/>
590
222
            <field name="active" eval="1"/>
591
223
            <field name="condition_select">none</field>
592
224
            <field name="amount_select">code</field>
593
225
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
594
226
date_to = payslip.date_to
595
227
result = payslip.sum('FITYTD',date_from,date_to) + FIT
596
228
            </field>
597
229
        </record>
598
230
599
231
        <!-- Vacation - 210 -->
600
232
601
233
        <record id="rule_ca_vac" model="hr.salary.rule">
602
234
            <field name="name">Vacation (VAC)</field>
603
235
            <field name="sequence" eval="210"/>
604
236
            <field name="code">VAC</field>
605
237
            <field name="category_id" ref="VAC"/>
606
238
            <field name="condition_select">none</field>
607
239
            <field name="amount_select">code</field>
608
240
            <field name="amount_python_compute">result = GROSSP * contract.weeks_of_vacation * 0.02</field>
609
241
        </record>
610
242
611
243
        <record id="rule_ca_vac_ytd" model="hr.salary.rule">
612
244
            <field name="name">Vacation - Year To Date (VACYTD)</field>
613
245
            <field name="sequence" eval="211"/>
614
246
            <field name="code">VACYTD</field>
615
247
            <field name="category_id" ref="VAC"/>
616
248
            <field name="appears_on_payslip" eval="1"/>
617
249
            <field name="active" eval="1"/>
618
250
            <field name="condition_select">none</field>
619
251
            <field name="amount_select">code</field>
620
252
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
621
253
date_to = payslip.date_to
622
254
result = payslip.sum('VACYTD',date_from,date_to) + VAC
623
255
            </field>
624
256
        </record>
625
257
626
258
	<!-- Base for Canadian Salary Structure -->
627
259
628
260
        <record id="hr_structure_ca_base" model="hr.payroll.structure">
629
261
            <field name="code">CA</field>
630
262
            <field name="name">Canadian Base</field>
631
263
            <field eval="[(6, 0, [
632
264
		ref('rule_ca_p'),
633
265
		ref('rule_ca_pocc'),
634
266
		ref('rule_ca_basic'),
635
267
		ref('rule_ca_gross'),
636
268
		ref('rule_ca_ei_maxie'),
637
269
		ref('rule_ca_ei_er_c'),
638
270
		ref('rule_ca_ei_er_pytdc'),
639
271
		ref('rule_ca_ei_er_ytdc'),
640
272
		ref('rule_ca_fit_rate'),
641
273
		ref('rule_ca_fit_ti'),
642
274
		ref('rule_ca_fit'),
643
275
		ref('rule_ca_fit_ytd'),
644
276
		ref('rule_ca_vac'),
645
277
		ref('rule_ca_vac_ytd')
646
278
		])]" name="rule_ids"/>
647
279
        </record>
648
280
649
281
    </data>
650
282
</openerp>
651
0
283
652
=== added file 'l10n_ca_hr_payroll/l10n_ca_hr_payroll_view.xml'
653
--- l10n_ca_hr_payroll/l10n_ca_hr_payroll_view.xml	1970-01-01 00:00:00 +0000
654
+++ l10n_ca_hr_payroll/l10n_ca_hr_payroll_view.xml	2012-12-21 16:45:28 +0000
655
@@ -0,0 +1,210 @@
656
1
<?xml version="1.0" encoding="utf-8"?>
657
2
<openerp>
658
3
  <data>
659
4
660
5
        <record id="hr_payroll_tax_table_form" model="ir.ui.view">
661
6
            <field name="name">hr.payroll.tax.table.form</field>
662
7
            <field name="model">hr.payroll.tax.table</field>
663
8
            <field name="type">form</field>
664
9
            <field name="arch" type="xml">
665
10
                <form string="Canadian Tax Table">
666
11
                   <field name="name" select="1"/>
667
12
                   <field name="year" select="1" on_change="onchange_year(year,state_id)"/>
668
13
                   <field name="date_from"/>
669
14
                   <field name="date_to"/>
670
15
                   <field name="jurisdiction"/>
671
16
                   <field name="state_id" 
672
17
                          attrs="{'invisible': [('jurisdiction','!=','provincial')], 'required': [('jurisdiction','=','provincial')]}" 
673
18
                          on_change="onchange_year(year,state_id)" 
674
19
                          domain="[('country_id.code', '=', 'CA')]"/> 
675
20
                   <field name="type"/>
676
21
                   <newline/>
677
22
                   <separator colspan="4"/>
678
23
                   <newline/>
679
24
                   <field name="line_federal_ids" nolabel="1" colspan="4" widget="one2many_list"
680
25
                          attrs="{'invisible': [('type','!=','federal')]}">
681
26
                       <tree string="Federal Lines" editable="top">
682
27
                           <field name="inc_from"/>
683
28
                           <field name="inc_to"/>
684
29
                           <field name="code0"/>
685
30
                           <field name="code1"/>
686
31
                           <field name="code2"/>
687
32
                           <field name="code3"/>
688
33
                           <field name="code4"/>
689
34
                           <field name="code5"/>
690
35
                           <field name="code6"/>
691
36
                           <field name="code7"/>
692
37
                           <field name="code8"/>
693
38
                           <field name="code9"/>
694
39
                           <field name="code10"/>
695
40
                       </tree>
696
41
                   </field>
697
42
                   <field name="line_ei_ids" nolabel="1" colspan="4" widget="one2many_list" 
698
43
                          attrs="{'invisible': [('type','!=','ei')]}">
699
44
                       <tree string="Employment Insurance Lines" editable="top">
700
45
                           <field name="inc_from"/>
701
46
                           <field name="inc_to"/>
702
47
                           <field name="rate"/>
703
48
                           <field name="max_annual_insurable_earnings"/>
704
49
                       </tree>
705
50
                   </field>
706
51
                   <field name="line_qc_ids" nolabel="1" colspan="4" widget="one2many_list" 
707
52
                          attrs="{'invisible': [('type','!=','qc')]}">
708
53
                       <tree string="Quebec Lines" editable="top">
709
54
                           <field name="inc_from"/>
710
55
                           <field name="inc_to"/>
711
56
                           <field name="code0"/>
712
57
                           <field name="codeA"/>
713
58
                           <field name="codeB"/>
714
59
                           <field name="codeC"/>
715
60
                           <field name="codeD"/>
716
61
                           <field name="codeE"/>
717
62
                           <field name="codeF"/>
718
63
                           <field name="codeG"/>
719
64
                           <field name="codeH"/>
720
65
                           <field name="codeI"/>
721
66
                           <field name="codeJ"/>
722
67
                           <field name="codeK"/>
723
68
                           <field name="codeL"/>
724
69
                           <field name="codeM"/>
725
70
                           <field name="codeN"/>
726
71
                           <field name="codeY"/>
727
72
                           <field name="codeZ"/>
728
73
                       </tree>
729
74
                   </field>
730
75
                   <field name="line_rqap_ids" nolabel="1" colspan="4" widget="one2many_list" 
731
76
                          attrs="{'invisible': [('type','!=','rqap')]}">
732
77
                       <tree string="RQAP / RRQ Lines" editable="top">
733
78
                           <field name="inc_from"/>
734
79
                           <field name="inc_to"/>
735
80
                           <field name="employee_contrib"/>
736
81
                           <field name="employer_contrib"/>
737
82
                           <field name="max_annual_insurable_earnings"/>
738
83
                       </tree>
739
84
                   </field>
740
85
                   <field name="line_csst_ids" nolabel="1" colspan="4" widget="one2many_list" 
741
86
                          attrs="{'invisible': [('type','!=','csst')]}">
742
87
                       <tree string="CSST Lines" editable="top">
743
88
                           <field name="name"/>
744
89
                       </tree>
745
90
                   </field>
746
91
                </form>
747
92
          </field>
748
93
        </record>
749
94
750
95
        <record id="hr_payroll_tax_table_search" model="ir.ui.view">
751
96
          <field name="name">hr.payroll.tax.table.search</field>
752
97
          <field name="model">hr.payroll.tax.table</field>
753
98
          <field name="type">search</field>
754
99
          <field name="arch" type="xml">
755
100
              <search string="Canadian Tax Table">
756
101
                   <field name="name"/>
757
102
                   <field name="year"/>
758
103
                   <field name="jurisdiction"/>
759
104
                   <field name="state_id"/>
760
105
                   <field name="type"/>
761
106
              </search>
762
107
          </field>
763
108
        </record>
764
109
765
110
        <record id="hr_payroll_tax_table_tree" model="ir.ui.view">
766
111
          <field name="name">hr.payroll.tax.table.tree</field>
767
112
          <field name="model">hr.payroll.tax.table</field>
768
113
          <field name="type">tree</field>
769
114
          <field name="arch" type="xml">
770
115
              <tree string="Canadian Tax Table">
771
116
                   <field name="name"/>
772
117
                   <field name="year"/>
773
118
                   <field name="jurisdiction"/>
774
119
                   <field name="state_id"/>
775
120
                   <field name="type"/>
776
121
                </tree>
777
122
            </field>
778
123
        </record>
779
124
                
780
125
      <record id="action_hr_payroll_tax_table_tree" model="ir.actions.act_window">
781
126
          <field name="name">Canadian Tax Table</field>
782
127
          <field name="res_model">hr.payroll.tax.table</field>
783
128
          <field name="view_type">form</field>
784
129
          <field name="view_mode">tree,form</field>
785
130
          <field name="view_id" ref="hr_payroll_tax_table_tree"/>
786
131
          <field name="search_view_id" ref="hr_payroll_tax_table_search"/>
787
132
      </record>
788
133
  
789
134
      <menuitem id="menu_hr_payroll_tax_table_tree" action="action_hr_payroll_tax_table_tree" parent="hr_payroll.payroll_configure"/>
790
135
  
791
136
      <record id="hr_employee_view_form_inherit" model="ir.ui.view">
792
137
          <field name="name">hr.employee.view.form.inherit</field>
793
138
          <field name="model">hr.employee</field>
794
139
          <field name="type">form</field>
795
140
          <field name="inherit_id" ref="hr.view_employee_form"/>
796
141
          <field name="arch" type="xml">
797
142
              <notebook position="inside">
798
143
                  <page string="Canadian Payroll">
799
144
                      <group colspan="1" col="2">
800
145
                          <separator string="Claim Codes" colspan="2"/>
801
146
                          <field name="td1f" colspan="1"/>
802
147
                          <field name="td1p" colspan="1"/>
803
148
                      </group>
804
149
                      <group colspan="3" col="2">
805
150
                          <separator string="Exemptions" colspan="2"/>
806
151
                          <group colspan="1" col="2">
807
152
                              <field name="ei_ytd_adj"/>
808
153
                              <field name="cpp_ytd_adj"/>
809
154
                          </group>
810
155
                          <group colspan="1" col="2">
811
156
                              <field name="ei_exempt"/>
812
157
                              <field name="cpp_exempt"/>
813
158
                              <field name="qpip_exempt"/>
814
159
                          </group>
815
160
                      </group>
816
161
                      <separator string="Deductions" colspan="4"/>
817
162
                      <field name="f1"/>
818
163
                      <field name="f2"/>
819
164
                      <field name="hd"/>
820
165
                      <field name="lcf"/>
821
166
                      <field name="lcp"/>
822
167
                      <field name="f"/>
823
168
                      <field name="k3"/>
824
169
                      <field name="u1"/>
825
170
                      <field name="y"/>
826
171
                      <field name="l"/>
827
172
                      <field name="td1"/>
828
173
                      <field name="eeins"/>
829
174
                      <field name="erins"/>
830
175
                  </page>
831
176
              </notebook>
832
177
          </field>
833
178
      </record>
834
179
  
835
180
      <!-- Contract View -->
836
181
      <record id="hr_contract_form_inherit" model="ir.ui.view">
837
182
          <field name="name">hr.contract.view.form.inherit</field>
838
183
          <field name="model">hr.contract</field>
839
184
          <field name="type">form</field>
840
185
          <field name="inherit_id" ref="hr_contract.hr_contract_view_form"/>
841
186
          <field name="arch" type="xml">
842
187
               <xpath expr="/form/notebook/page/group/field[@name='working_hours']" position="after">
843
188
                  <field name="pays_per_year"/>
844
189
                  <field name="weeks_of_vacation"/>
845
190
              </xpath>
846
191
          </field>
847
192
      </record>
848
193
  
849
194
      <!-- End Contract View-->
850
195
  
851
196
      <!-- Salary Rules - unhide the sequence, not sure why it's invisible -->
852
197
      <record id="hr_salary_rule_list_inherit" model="ir.ui.view">
853
198
          <field name="name">hr.salary.rule.list.inherit</field>
854
199
          <field name="model">hr.salary.rule</field>
855
200
          <field name="type">tree</field>
856
201
          <field name="inherit_id" ref="hr_payroll.hr_salary_rule_list"/>
857
202
          <field name="arch" type="xml">
858
203
              <xpath expr="//field[@name='sequence']" position="replace">
859
204
                  <field name="sequence" groups="base.group_extended"/>
860
205
              </xpath>
861
206
          </field>
862
207
      </record>
863
208
  
864
209
  </data>
865
210
</openerp>
866
0
211
867
=== added directory 'l10n_ca_hr_payroll/static'
868
=== added directory 'l10n_ca_hr_payroll/static/src'
869
=== added directory 'l10n_ca_hr_payroll/static/src/img'
870
=== added file 'l10n_ca_hr_payroll/static/src/img/icon.png'
871
1
Binary files l10n_ca_hr_payroll/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and l10n_ca_hr_payroll/static/src/img/icon.png	2012-12-21 16:45:28 +0000 differ
212
Binary files l10n_ca_hr_payroll/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and l10n_ca_hr_payroll/static/src/img/icon.png	2012-12-21 16:45:28 +0000 differ
872
=== added directory 'l10n_ca_hr_payroll_account'
873
=== added file 'l10n_ca_hr_payroll_account/AUTHORS.txt'
874
--- l10n_ca_hr_payroll_account/AUTHORS.txt	1970-01-01 00:00:00 +0000
875
+++ l10n_ca_hr_payroll_account/AUTHORS.txt	2012-12-21 16:45:28 +0000
876
@@ -0,0 +1,3 @@
877
1
Pierre Lamarche <pierre.lamarche@savoirfairelinux.com>
878
2
Maxime Chambreuil <maxime.chambreuil@savoirfairelinux.com>
879
3
Savoir-faire Linux <contact@savoirfairelinux.com>
880
0
4
881
=== added file 'l10n_ca_hr_payroll_account/__init__.py'
882
--- l10n_ca_hr_payroll_account/__init__.py	1970-01-01 00:00:00 +0000
883
+++ l10n_ca_hr_payroll_account/__init__.py	2012-12-21 16:45:28 +0000
884
@@ -0,0 +1,22 @@
885
1
#-*- coding:utf-8 -*-
886
2
##############################################################################
887
3
#
888
4
#    Copyright (C) 2012 OpenERP Canada. All Rights Reserved.
889
5
#
890
6
#    This program is free software: you can redistribute it and/or modify
891
7
#    it under the terms of the GNU Affero General Public License as published
892
8
#    by
893
9
#    the Free Software Foundation, either version 3 of the License, or
894
10
#    (at your option) any later version.
895
11
#
896
12
#    This program is distributed in the hope that it will be useful,
897
13
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
898
14
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
899
15
#    GNU Affero General Public License for more details.
900
16
#
901
17
#    You should have received a copy of the GNU Affero General Public License
902
18
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
903
19
#
904
20
##############################################################################
905
21
906
22
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
907
0
23
908
=== added file 'l10n_ca_hr_payroll_account/__openerp__.py'
909
--- l10n_ca_hr_payroll_account/__openerp__.py	1970-01-01 00:00:00 +0000
910
+++ l10n_ca_hr_payroll_account/__openerp__.py	2012-12-21 16:45:28 +0000
911
@@ -0,0 +1,51 @@
912
1
#-*- coding:utf-8 -*-
913
2
##############################################################################
914
3
#
915
4
#    Copyright (C) 2012 OpenERP Canada. All Rights Reserved.
916
5
#
917
6
#    This program is free software: you can redistribute it and/or modify
918
7
#    it under the terms of the GNU Affero General Public License as published by
919
8
#    the Free Software Foundation, either version 3 of the License, or
920
9
#    (at your option) any later version.
921
10
#
922
11
#    This program is distributed in the hope that it will be useful,
923
12
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
924
13
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
925
14
#    GNU Affero General Public License for more details.
926
15
#
927
16
#    You should have received a copy of the GNU Affero General Public License
928
17
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
929
18
#
930
19
##############################################################################
931
20
{
932
21
    'name': 'Canada - Payroll Accounting',
933
22
    'category': 'Localization',
934
23
    'version': '0.1',
935
24
    'license': 'AGPL-3',
936
25
    'category': 'Generic Modules/Human Resources',
937
26
    'description': """
938
27
Canada Payroll Accounting 
939
28
=========================
940
29
941
30
This module:
942
31
 * creates salary journal
943
32
 * creates financial accounts for payroll
944
33
 * updates salary rules with accounting information
945
34
    """,
946
35
    'author':'OpenERP Canada',
947
36
    'website':'http://launchpad.net/openerp-canada',
948
37
    'depends': [
949
38
        'l10n_ca',
950
39
        'l10n_ca_hr_payroll',
951
40
        'hr_payroll_account',
952
41
    ],
953
42
    'data': [
954
43
        'l10n_ca_hr_payroll_account_data.xml',
955
44
    ],
956
45
    'test': [],
957
46
    'demo': [],
958
47
    'installable': True,
959
48
    'active': False,
960
49
}
961
50
962
51
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
963
0
52
964
=== added file 'l10n_ca_hr_payroll_account/l10n_ca_hr_payroll_account_data.xml'
965
--- l10n_ca_hr_payroll_account/l10n_ca_hr_payroll_account_data.xml	1970-01-01 00:00:00 +0000
966
+++ l10n_ca_hr_payroll_account/l10n_ca_hr_payroll_account_data.xml	2012-12-21 16:45:28 +0000
967
@@ -0,0 +1,31 @@
968
1
<?xml version="1.0" encoding="utf-8"?>
969
2
<openerp>
970
3
    <data noupdate="1">
971
4
972
5
	<!-- Payroll Journal -->
973
6
974
7
	<record id="payroll_journal" model="account.journal">
975
8
	    <field name="name">Payroll Journal</field>
976
9
	    <field name="code">PAYJ</field>
977
10
	    <field name="type">general</field>
978
11
	    <field name="view_id" ref="account.account_journal_view"/>
979
12
	</record>
980
13
981
14
	<!-- Salary rules -->
982
15
983
16
	<!-- Employment Insurance -->
984
17
985
18
        <record id="l10n_ca_hr_payroll.rule_ca_ei_er_c" model="hr.salary.rule">
986
19
            <field name="account_debit" model='account.account' search="[('code','like','51203')]"/>
987
20
            <field name="account_credit" model='account.account' search="[('code','like','214112')]"/>
988
21
        </record>
989
22
990
23
        <!-- Federal Tax Income -->
991
24
992
25
        <record id="l10n_ca_hr_payroll.rule_ca_fit" model="hr.salary.rule">
993
26
            <field name="account_debit" model='account.account' search="[('code','like','51209')]"/>
994
27
            <field name="account_credit" model='account.account' search="[('code','like','21412')]"/>
995
28
        </record>
996
29
997
30
    </data>
998
31
</openerp>
999
0
32
1000
=== added directory 'l10n_ca_hr_payroll_account/static'
1001
=== added directory 'l10n_ca_hr_payroll_account/static/src'
1002
=== added directory 'l10n_ca_hr_payroll_account/static/src/img'
1003
=== added file 'l10n_ca_hr_payroll_account/static/src/img/icon.png'
1004
1
Binary files l10n_ca_hr_payroll_account/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and l10n_ca_hr_payroll_account/static/src/img/icon.png	2012-12-21 16:45:28 +0000 differ
33
Binary files l10n_ca_hr_payroll_account/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and l10n_ca_hr_payroll_account/static/src/img/icon.png	2012-12-21 16:45:28 +0000 differ
1005
=== added directory 'l10n_ca_on_hr_payroll'
1006
=== added file 'l10n_ca_on_hr_payroll/__init__.py'
1007
--- l10n_ca_on_hr_payroll/__init__.py	1970-01-01 00:00:00 +0000
1008
+++ l10n_ca_on_hr_payroll/__init__.py	2012-12-21 16:45:28 +0000
1009
@@ -0,0 +1,24 @@
1010
1
#-*- coding:utf-8 -*-
1011
2
##############################################################################
1012
3
#
1013
4
#    Copyright (C) 2012 Amura Consulting. All Rights Reserved.
1014
5
#
1015
6
#    This program is free software: you can redistribute it and/or modify
1016
7
#    it under the terms of the GNU Affero General Public License as published
1017
8
#    by
1018
9
#    the Free Software Foundation, either version 3 of the License, or
1019
10
#    (at your option) any later version.
1020
11
#
1021
12
#    This program is distributed in the hope that it will be useful,
1022
13
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
1023
14
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
1024
15
#    GNU Affero General Public License for more details.
1025
16
#
1026
17
#    You should have received a copy of the GNU Affero General Public License
1027
18
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
1028
19
#
1029
20
##############################################################################
1030
21
1031
22
import l10n_ca_on_hr_payroll
1032
23
1033
24
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
1034
0
25
1035
=== added file 'l10n_ca_on_hr_payroll/__openerp__.py'
1036
--- l10n_ca_on_hr_payroll/__openerp__.py	1970-01-01 00:00:00 +0000
1037
+++ l10n_ca_on_hr_payroll/__openerp__.py	2012-12-21 16:45:28 +0000
1038
@@ -0,0 +1,52 @@
1039
1
#-*- coding:utf-8 -*-
1040
2
##############################################################################
1041
3
#
1042
4
#    Copyright (C) 2012 Amura Consulting. All Rights Reserved.
1043
5
#
1044
6
#    This program is free software: you can redistribute it and/or modify
1045
7
#    it under the terms of the GNU Affero General Public License as published by
1046
8
#    the Free Software Foundation, either version 3 of the License, or
1047
9
#    (at your option) any later version.
1048
10
#
1049
11
#    This program is distributed in the hope that it will be useful,
1050
12
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
1051
13
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
1052
14
#    GNU Affero General Public License for more details.
1053
15
#
1054
16
#    You should have received a copy of the GNU Affero General Public License
1055
17
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
1056
18
#
1057
19
##############################################################################
1058
20
{
1059
21
    'name': 'Canada - Ontario - Payroll',
1060
22
    'category': 'Localization',
1061
23
    'version': '0.9',
1062
24
    'category': 'Generic Modules/Human Resources',
1063
25
    'description': """
1064
26
Ontario Canadian Payroll Rules
1065
27
==============================
1066
28
 * Adds all Federal and Provincial Salary Rules for Ontario
1067
29
 * Adds Ontario Salary Structure
1068
30
 * Adds Claim Codes, Deductions and Exemptions on the Employee Form
1069
31
 * Adds 'Pays Per Year' field on the Contract Form
1070
32
    """,
1071
33
    'author':'Amura Consulting',
1072
34
    'website':'http://www.openerp.com',
1073
35
    'depends': [
1074
36
        'hr_payroll',
1075
37
    ],
1076
38
    'init_xml': [
1077
39
    ],
1078
40
    'update_xml': [
1079
41
        'l10n_ca_on_hr_payroll_view.xml',
1080
42
        'l10n_ca_on_hr_payroll_data.xml',
1081
43
    ],
1082
44
    'test': [
1083
45
    ],
1084
46
    'demo_xml': [
1085
47
    ],
1086
48
    'installable': True,
1087
49
    'active': False,
1088
50
}
1089
51
1090
52
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
1091
0
53
1092
=== added file 'l10n_ca_on_hr_payroll/l10n_ca_on_hr_payroll.py'
1093
--- l10n_ca_on_hr_payroll/l10n_ca_on_hr_payroll.py	1970-01-01 00:00:00 +0000
1094
+++ l10n_ca_on_hr_payroll/l10n_ca_on_hr_payroll.py	2012-12-21 16:45:28 +0000
1095
@@ -0,0 +1,141 @@
1096
1
#-*- coding:utf-8 -*-
1097
2
##############################################################################
1098
3
#
1099
4
#    Copyright (C) 2012 Amura Consulting. All Rights Reserved.
1100
5
#
1101
6
#    This program is free software: you can redistribute it and/or modify
1102
7
#    it under the terms of the GNU Affero General Public License as published
1103
8
#    by
1104
9
#    the Free Software Foundation, either version 3 of the License, or
1105
10
#    (at your option) any later version.
1106
11
#
1107
12
#    This program is distributed in the hope that it will be useful,
1108
13
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
1109
14
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
1110
15
#    GNU Affero General Public License for more details.
1111
16
#
1112
17
#    You should have received a copy of the GNU Affero General Public License
1113
18
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
1114
19
#
1115
20
##############################################################################
1116
21
1117
22
from osv import fields, osv
1118
23
1119
24
"""
1120
25
class hr_payroll_tax_table(osv.osv):
1121
26
    '''
1122
27
    Canadian Tax Payroll Table
1123
28
    '''
1124
29
    _name = 'hr.payroll.tax.table'
1125
30
    _description = 'Canadian Tax Payroll Table'
1126
31
1127
32
    def onchange_year(self, cr, uid, ids, year, prov=False):
1128
33
        res = {}
1129
34
        res['name'] = 'Tax Table: ' + str(year)
1130
35
        if prov:
1131
36
            prov_obj = self.pool.get('res.country.state').browse(cr, uid, prov)
1132
37
            res['name'] += ' / Provincial - ' + prov_obj.code
1133
38
        else:
1134
39
            res['name'] += ' / Federal'
1135
40
1136
41
        return {'value': res}
1137
42
        
1138
43
    _columns = {
1139
44
            'name': fields.char('Description', size=128),
1140
45
            'year': fields.integer('Year', required=True),
1141
46
            'date_from': fields.date('Date From'),
1142
47
            'date_to': fields.date('Date To'),
1143
48
            'fed_prov': fields.selection([
1144
49
                ('federal','Federal'),
1145
50
                ('provincial','Provincial')], 'Federal/Provincial', required=True),
1146
51
            'province': fields.many2one('res.country.state', 'Province'),
1147
52
            'line_ids': fields.one2many('hr.payroll.tax.table.line', 'table_id', 'Lines'),
1148
53
            }
1149
54
1150
55
    _defaults = {
1151
56
            'fed_prov': 'federal',
1152
57
            }
1153
58
hr_payroll_tax_table()
1154
59
1155
60
class hr_payroll_tax_table_line(osv.osv):
1156
61
    '''
1157
62
    Canadian Tax Payroll Table Lines
1158
63
    '''
1159
64
    _name = 'hr.payroll.tax.table.line'
1160
65
    _description = 'Canadian Tax Payroll Table Lines'
1161
66
    _columns = {
1162
67
        'name': fields.char('Name', size=64),
1163
68
        'code': fields.char('Code', size=16),
1164
69
        'inc_from': fields.float('Income From', digits=(16, 2)),
1165
70
        'inc_to': fields.float('Income To', digits=(16, 2)),
1166
71
        'rate': fields.float('Rate', digits=(16, 2)),
1167
72
        'table_id': fields.many2one('hr.payroll.tax.table', 'Table'),
1168
73
        }
1169
74
hr_payroll_tax_table_line()
1170
75
"""
1171
76
1172
77
class hr_employee(osv.osv):
1173
78
    _name = 'hr.employee'
1174
79
    _inherit = 'hr.employee'
1175
80
1176
81
    _columns = {
1177
82
        'ei_exempt': fields.boolean('EI Exempt'),
1178
83
        'td1f': fields.selection([(1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10),(0,0)], 'Federal Claim Code', required=True),
1179
84
        'td1p': fields.selection([(1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10),(0,0)], 'Provincial Claim Code', required=True),
1180
85
        'cpp_exempt': fields.boolean('CPP/QPP Exempt'),
1181
86
        'qpip_exempt': fields.boolean('QPIP Exempt'),
1182
87
        'cpp_ytd_adj': fields.float('CPP/QPP YTD Adjustment', help="Amount to adjust CPP/QPP for calculations. Used if employee has contributed elsewhere and will be factored in when calculating maximum CPP payment"),
1183
88
        'ei_ytd_adj': fields.float('EI YTD Adjustment', help="Amount to adjust EI for calculations. Used if employee has contributed elsewhere and will be factored in when calculating maximum EI payment"),
1184
89
        'vac_pay': fields.float('Vacation Pay %', digits=(16,2)),
1185
90
        'f1': fields.float('Childcare/Alimony (F1)', digits=(16,2), help="Annual deductions such as child care expenses and support payments, etc., authorized by a tax services office or tax centre"),
1186
91
        'f2': fields.float('Alimony/Maint Garnish (F2)', digits=(16,2), help="Alimony or maintenance payments required by a legal document to be payroll-deducted authorized by a tax services office or tax centre"),
1187
92
        'hd': fields.float('Prescribed Zone (HD)', digits=(16,2), help="Annual deduction for living in a prescribed zone as indicated on Form TD1"),
1188
93
        'lcf': fields.float('Fed Labour sponsored funds (LCF)', digits=(16,2), help="Federal labour-sponsored funds tax credit"),
1189
94
        'lcp': fields.float('Prov Labour sponsored funds (LCP)', digits=(16,2), help="Provincial or territorial labour-sponsored funds tax credit"),
1190
95
        'f': fields.float('RSP/RPP/RCA (F)', digits=(16,2), help="Payroll deductions for employee contributions to a registered pension plan (RPP), a registered retirement savings plan (RRSP), or a retirement compensation arrangement (RCA)"),
1191
96
        'l': fields.float('Extra Tax Deductions (L)', digits=(16,2), help="Extra tax deductions requested for the pay period."),
1192
97
        'k3': fields.float('Federal Medical (K3)', digits=(16,2), help="Other federal tax credits, such as medical expenses and charitable donations authorized by a tax services office or tax centre"),
1193
98
        'u1': fields.float('Union Dues (U1)', digits=(16,2), help="Union dues"),
1194
99
        'y': fields.float('MB/ON Extra Tax Reduction(Y)', digits=(16,2), help="Extra provincial or territorial tax reduction based on applicable amounts reported on the provincial or territorial Form TD1"),
1195
100
            }
1196
101
1197
102
    _defaults = {
1198
103
        'td1f': 1,
1199
104
        'td1p': 1,
1200
105
        }
1201
106
1202
107
hr_employee()
1203
108
1204
109
class hr_contract(osv.osv):
1205
110
    _inherit = 'hr.contract'
1206
111
1207
112
    def _get_pays_per_year(self, cr, uid, ids, names, arg, context=None):
1208
113
        """
1209
114
        @param ids: ID of contract
1210
115
        @return: The number of pays per year
1211
116
        """
1212
117
        res = {}
1213
118
        #FIXME: Should likely pull these values from somewhere else, depending on whether a 52 or 53 year week is used
1214
119
        schedule_pay = {
1215
120
            'monthly': 12,
1216
121
            'quarterly': 4,
1217
122
            'semi-annually': 2,
1218
123
            'annually': 1,
1219
124
            'weekly': 52,
1220
125
            'bi-weekly': 26,
1221
126
            'bi-monthly': 6,
1222
127
            }
1223
128
        for contract in self.browse(cr, uid, ids, context):
1224
129
            if contract.schedule_pay and schedule_pay.get(contract.schedule_pay, False):
1225
130
                res[contract.id] = schedule_pay[contract.schedule_pay]
1226
131
1227
132
        return res
1228
133
1229
134
    _columns = {
1230
135
        'pays_per_year': fields.function(_get_pays_per_year, method=True, string='Pays Per Year', type='float', readonly=True),
1231
136
        }
1232
137
1233
138
hr_contract()
1234
139
1235
140
            
1236
141
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
1237
0
142
1238
=== added file 'l10n_ca_on_hr_payroll/l10n_ca_on_hr_payroll_data.xml'
1239
--- l10n_ca_on_hr_payroll/l10n_ca_on_hr_payroll_data.xml	1970-01-01 00:00:00 +0000
1240
+++ l10n_ca_on_hr_payroll/l10n_ca_on_hr_payroll_data.xml	2012-12-21 16:45:28 +0000
1241
@@ -0,0 +1,597 @@
1242
1
<?xml version="1.0" encoding="utf-8"?>
1243
2
<openerp>
1244
3
    <data noupdate="1">
1245
4
1246
5
        <record id="I" model="hr.salary.rule.category">
1247
6
            <field name="name">Taxable Income</field>
1248
7
            <field name="code">I</field>
1249
8
        </record>
1250
9
1251
10
        <record id="CALC" model="hr.salary.rule.category">
1252
11
            <field name="code">CALC</field>
1253
12
            <field name="name">Standard Calculation</field>
1254
13
        </record>
1255
14
1256
15
        <record id="FCALC" model="hr.salary.rule.category">
1257
16
            <field name="code">FCALC</field>
1258
17
            <field name="name">Federal Calculation</field>
1259
18
        </record>
1260
19
1261
20
        <record id="PCALC" model="hr.salary.rule.category">
1262
21
            <field name="code">PCALC</field>
1263
22
            <field name="name">Provincial Calculation</field>
1264
23
        </record>
1265
24
1266
25
        <record id="EMP" model="hr.salary.rule.category">
1267
26
            <field name="code">EMP</field>
1268
27
            <field name="name">Employer Contribution</field>
1269
28
        </record>
1270
29
1271
30
        <record id="SDED" model="hr.salary.rule.category">
1272
31
            <field name="code">SDED</field>
1273
32
            <field name="name">Source Deduction</field>
1274
33
            <field name="notes">Used for after tax deductions at source</field>
1275
34
        </record>
1276
35
1277
36
        <record id="hr_salary_rule_p" model="hr.salary.rule">
1278
37
            <field name="name">Pays Per Year</field>
1279
38
            <field name="sequence" eval="1"/>
1280
39
            <field name="code">P</field>
1281
40
            <field eval="0" name="appears_on_payslip"/>
1282
41
            <field eval="1" name="active"/>
1283
42
            <field name="category_id" ref="CALC"/>
1284
43
            <field name="condition_select">none</field>
1285
44
            <field name="amount_select">code</field>
1286
45
            <field name="amount_python_compute">result = contract.pays_per_year or 0</field>
1287
46
            <field name="notes">Pays per year from the contract form</field>
1288
47
        </record>
1289
48
1290
49
        <record id="hr_salary_rule_pocc" model="hr.salary.rule">
1291
50
            <field name="name">Payslip Counter(POCC)</field>
1292
51
            <field name="sequence" eval="1"/>
1293
52
            <field name="code">POCC</field>
1294
53
            <field eval="0" name="appears_on_payslip"/>
1295
54
            <field eval="1" name="active"/>
1296
55
            <field name="category_id" ref="CALC"/>
1297
56
            <field name="condition_select">none</field>
1298
57
            <field name="amount_select">fix</field>
1299
58
            <field name="quantity">1.0</field>
1300
59
            <field name="amount_fix">1.0</field>
1301
60
            <field name="notes">Sloppy way of counting payslips for use in PR calc</field>
1302
61
        </record>
1303
62
1304
63
        <record id="hr_salary_rule_cppmax" model="hr.salary.rule">
1305
64
            <field name="name">CPP Maximum(CPPMAX)</field>
1306
65
            <field name="sequence" eval="1"/>
1307
66
            <field name="code">CPPMAX</field>
1308
67
            <field eval="0" name="appears_on_payslip"/>
1309
68
            <field eval="1" name="active"/>
1310
69
            <field name="category_id" ref="CALC"/>
1311
70
            <field name="condition_select">none</field>
1312
71
            <field name="amount_select">fix</field>
1313
72
            <field name="quantity">1.0</field>
1314
73
            <field name="amount_fix">2306.70</field>
1315
74
            <field name="notes">Annual maximum employee CPP contribution</field>
1316
75
        </record>
1317
76
1318
77
        <record id="hr_salary_rule_eimax" model="hr.salary.rule">
1319
78
            <field name="name">EI Maximum(EIMAX)</field>
1320
79
            <field name="sequence" eval="1"/>
1321
80
            <field name="code">EIMAX</field>
1322
81
            <field eval="0" name="appears_on_payslip"/>
1323
82
            <field eval="1" name="active"/>
1324
83
            <field name="category_id" ref="CALC"/>
1325
84
            <field name="condition_select">none</field>
1326
85
            <field name="amount_select">fix</field>
1327
86
            <field name="quantity">1.0</field>
1328
87
            <field name="amount_fix">839.97</field>
1329
88
            <field name="notes">Annual maximum employee EI contribution</field>
1330
89
        </record>
1331
90
1332
91
        <record id="hr_salary_rule_pr" model="hr.salary.rule">
1333
92
            <field name="name">Pays Remaining(PR)</field>
1334
93
            <field name="sequence" eval="2"/>
1335
94
            <field name="code">PR</field>
1336
95
            <field eval="0" name="appears_on_payslip"/>
1337
96
            <field eval="1" name="active"/>
1338
97
            <field name="category_id" ref="CALC"/>
1339
98
            <field name="condition_select">none</field>
1340
99
            <field name="amount_select">code</field>
1341
100
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
1342
101
date_to = payslip.date_to
1343
102
result = P - payslip.sum('POCC',date_from,date_to)</field>
1344
103
        </record>
1345
104
1346
105
        <record id="hr_salary_rule_ca_wage" model="hr.salary.rule">
1347
106
            <field name="name">Base Pay</field>
1348
107
            <field name="sequence" eval="2"/>
1349
108
            <field name="code">CAWAGE</field>
1350
109
            <field name="category_id" ref="I"/>
1351
110
            <field name="condition_select">none</field>
1352
111
            <field name="amount_select">code</field>
1353
112
            <field name="amount_python_compute">result = contract.wage</field>
1354
113
        </record>
1355
114
1356
115
        <record id="hr_salary_rule_vpay" model="hr.salary.rule">
1357
116
            <field name="name">Vacation Pay</field>
1358
117
            <field name="sequence" eval="2"/>
1359
118
            <field name="code">VPAY</field>
1360
119
            <field name="category_id" ref="I"/>
1361
120
            <field name="condition_select">none</field>
1362
121
            <field name="amount_select">code</field>
1363
122
            <field name="amount_python_compute">result = categories.I * 0.04</field>
1364
123
        </record>
1365
124
1366
125
        <record id="hr_salary_rule_i" model="hr.salary.rule">
1367
126
            <field name="name">Gross Pay</field>
1368
127
            <field name="sequence" eval="40"/>
1369
128
            <field name="code">I</field>
1370
129
            <field name="category_id" ref="hr_payroll.GROSS"/>
1371
130
            <field name="condition_select">none</field>
1372
131
            <field name="amount_select">code</field>
1373
132
            <field name="amount_python_compute">result = categories.I + categories.ALW</field>
1374
133
        </record>
1375
134
1376
135
        <record id="hr_salary_rule_pi_ytd" model="hr.salary.rule">
1377
136
            <field name="name">Pensionable Income YTD(PIYTD)</field>
1378
137
            <field eval="45" name="sequence"/>
1379
138
            <field name="code">PIYTD</field>
1380
139
            <field name="category_id" ref="CALC"/>
1381
140
            <field eval="1" name="appears_on_payslip"/>
1382
141
            <field eval="1" name="active"/>
1383
142
            <field name="condition_select">none</field>
1384
143
            <field name="amount_select">code</field>
1385
144
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
1386
145
date_to = payslip.date_to
1387
146
result = min(payslip.sum('I',date_from,date_to) + I, 50100)</field>
1388
147
        </record>
1389
148
1390
149
        <record id="hr_salary_rule_ie_ytd" model="hr.salary.rule">
1391
150
            <field name="name">Insurable Income YTD(IEYTD)</field>
1392
151
            <field eval="45" name="sequence"/>
1393
152
            <field name="code">IEYTD</field>
1394
153
            <field name="category_id" ref="CALC"/>
1395
154
            <field eval="1" name="appears_on_payslip"/>
1396
155
            <field eval="1" name="active"/>
1397
156
            <field name="condition_select">none</field>
1398
157
            <field name="amount_select">code</field>
1399
158
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
1400
159
date_to = payslip.date_to
1401
160
result = min(payslip.sum('I',date_from,date_to) + I, 45900)</field>
1402
161
        </record>
1403
162
1404
163
        <record id="hr_salary_rule_u1" model="hr.salary.rule">
1405
164
            <field name="name">Union Dues(U1)</field>
1406
165
            <field name="sequence" eval="50"/>
1407
166
            <field name="code">U1</field>
1408
167
            <field name="category_id" ref="hr_payroll.DED"/>
1409
168
            <field name="condition_select">none</field>
1410
169
            <field name="amount_select">code</field>
1411
170
            <field name="amount_python_compute">result = employee.u1</field>
1412
171
        </record>
1413
172
1414
173
        <record id="hr_salary_rule_l" model="hr.salary.rule">
1415
174
            <field name="name">Extra Tax Deductions Requested(L)</field>
1416
175
            <field name="sequence" eval="50"/>
1417
176
            <field name="code">L</field>
1418
177
            <field name="category_id" ref="CALC"/>
1419
178
            <field name="condition_select">none</field>
1420
179
            <field name="amount_select">code</field>
1421
180
            <field name="amount_python_compute">result = (employee.l + inputs.L.amount) if I else 0.0</field>
1422
181
        </record>
1423
182
1424
183
        <record id="hr_salary_rule_f" model="hr.salary.rule">
1425
184
            <field name="name">RSP/RPP/RCA(F)</field>
1426
185
            <field eval="60" name="sequence"/>
1427
186
            <field name="code">F</field>
1428
187
            <field name="category_id" ref="hr_payroll.DED"/>
1429
188
            <field eval="1" name="appears_on_payslip"/>
1430
189
            <field eval="1" name="active"/>
1431
190
            <field name="condition_select">none</field>
1432
191
            <field name="amount_select">code</field>
1433
192
            <field name="amount_python_compute">result = employee.f or 0.0</field>
1434
193
        </record>
1435
194
1436
195
        <record id="hr_salary_rule_f1" model="hr.salary.rule">
1437
196
            <field name="name">Childcare/Alimony(F1)</field>
1438
197
            <field eval="60" name="sequence"/>
1439
198
            <field name="code">F1</field>
1440
199
            <field name="category_id" ref="hr_payroll.DED"/>
1441
200
            <field eval="1" name="appears_on_payslip"/>
1442
201
            <field eval="1" name="active"/>
1443
202
            <field name="condition_select">none</field>
1444
203
            <field name="amount_select">code</field>
1445
204
            <field name="amount_python_compute">result = employee.f1 or 0.0</field>
1446
205
        </record>
1447
206
1448
207
        <record id="hr_salary_rule_f2" model="hr.salary.rule">
1449
208
            <field name="name">Alimony/Maintenance(F2)</field>
1450
209
            <field eval="60" name="sequence"/>
1451
210
            <field name="code">F2</field>
1452
211
            <field name="category_id" ref="hr_payroll.DED"/>
1453
212
            <field eval="1" name="appears_on_payslip"/>
1454
213
            <field eval="1" name="active"/>
1455
214
            <field name="condition_select">none</field>
1456
215
            <field name="amount_select">code</field>
1457
216
            <field name="amount_python_compute">result = employee.f2 or 0.0</field>
1458
217
        </record>
1459
218
1460
219
        <record id="hr_salary_rule_hd" model="hr.salary.rule">
1461
220
            <field name="name">Prescribed Zone(HD)</field>
1462
221
            <field eval="60" name="sequence"/>
1463
222
            <field name="code">HD</field>
1464
223
            <field name="category_id" ref="hr_payroll.DED"/>
1465
224
            <field eval="1" name="appears_on_payslip"/>
1466
225
            <field eval="1" name="active"/>
1467
226
            <field name="condition_select">none</field>
1468
227
            <field name="amount_select">code</field>
1469
228
            <field name="amount_python_compute">result = employee.hd or 0.0</field>
1470
229
        </record>
1471
230
1472
231
        <record id="hr_salary_rule_a" model="hr.salary.rule">
1473
232
            <field name="name">Annual Taxable Income(A)</field>
1474
233
            <field eval="101" name="sequence"/>
1475
234
            <field name="code">A</field>
1476
235
            <field name="category_id" ref="CALC"/>
1477
236
            <field eval="0" name="appears_on_payslip"/>
1478
237
            <field eval="1" name="active"/>
1479
238
            <field name="condition_select">none</field>
1480
239
            <field name="amount_select">code</field>
1481
240
            <field name="amount_python_compute">result = max((P * (I - F - F2 - U1)) - HD - F1, 0.0)</field>
1482
241
        </record>
1483
242
1484
243
        <record id="hr_salary_rule_r" model="hr.salary.rule">
1485
244
            <field name="name">Annual Federal Tax Rate(R)</field>
1486
245
            <field eval="110" name="sequence"/>
1487
246
            <field name="code">R</field>
1488
247
            <field name="category_id" ref="FCALC"/>
1489
248
            <field eval="0" name="appears_on_payslip"/>
1490
249
            <field eval="1" name="active"/>
1491
250
            <field name="condition_select">none</field>
1492
251
            <field name="amount_select">code</field>
1493
252
            <field name="amount_python_compute">result = (A &gt; 132406 and 0.29) or (A &gt; 85424 and 0.26) or (A &gt; 42707 and 0.22) or 0.15</field>
1494
253
        </record>
1495
254
1496
255
        <record id="hr_salary_rule_c" model="hr.salary.rule">
1497
256
            <field name="name">Canada Pension Plan(C)</field>
1498
257
            <field eval="140" name="sequence"/>
1499
258
            <field name="code">C</field>
1500
259
            <field name="category_id" ref="hr_payroll.DED"/>
1501
260
            <field eval="1" name="appears_on_payslip"/>
1502
261
            <field eval="1" name="active"/>
1503
262
            <field name="condition_select">python</field>
1504
263
            <field name="condition_python">result = not employee.cpp_exempt</field>
1505
264
            <field name="amount_select">code</field>
1506
265
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
1507
266
date_to = payslip.date_to
1508
267
Ccalc = 0.0495 * (I - (3500.0 / P))
1509
268
result = max(Ccalc if (Ccalc &lt; (CPPMAX - (payslip.sum('C',date_from,date_to) + employee.cpp_ytd_adj))) else (CPPMAX - (payslip.sum('C',date_from,date_to) + employee.cpp_ytd_adj)), 0)</field>
1510
269
        </record>
1511
270
1512
271
        <record id="hr_salary_rule_ei" model="hr.salary.rule">
1513
272
            <field name="name">Employment Insurance(EI)</field>
1514
273
            <field eval="140" name="sequence"/>
1515
274
            <field name="code">EI</field>
1516
275
            <field name="category_id" ref="hr_payroll.DED"/>
1517
276
            <field eval="1" name="appears_on_payslip"/>
1518
277
            <field eval="1" name="active"/>
1519
278
            <field name="condition_select">python</field>
1520
279
            <field name="condition_python">result = not employee.cpp_exempt</field>
1521
280
            <field name="amount_select">code</field>
1522
281
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
1523
282
date_to = payslip.date_to
1524
283
EIcalc = 0.0183 * I
1525
284
result = max(min(EIcalc, (EIMAX - payslip.sum('EI',date_from,date_to) - employee.ei_ytd_adj)), 0.0)</field>
1526
285
        </record>
1527
286
1528
287
        <record id="hr_salary_rule_c_ytd" model="hr.salary.rule">
1529
288
            <field name="name">Canada Pension Plan YTD</field>
1530
289
            <field eval="145" name="sequence"/>
1531
290
            <field name="code">CPPYTD</field>
1532
291
            <field name="category_id" ref="FCALC"/>
1533
292
            <field eval="1" name="appears_on_payslip"/>
1534
293
            <field eval="1" name="active"/>
1535
294
            <field name="condition_select">none</field>
1536
295
            <field name="amount_select">code</field>
1537
296
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
1538
297
date_to = payslip.date_to
1539
298
result = payslip.sum('C',date_from,date_to) + C</field>
1540
299
        </record>
1541
300
1542
301
        <record id="hr_salary_rule_ei_ytd" model="hr.salary.rule">
1543
302
            <field name="name">Employment Insurance YTD</field>
1544
303
            <field eval="145" name="sequence"/>
1545
304
            <field name="code">EIYTD</field>
1546
305
            <field name="category_id" ref="FCALC"/>
1547
306
            <field eval="1" name="appears_on_payslip"/>
1548
307
            <field eval="1" name="active"/>
1549
308
            <field name="condition_select">none</field>
1550
309
            <field name="amount_select">code</field>
1551
310
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
1552
311
date_to = payslip.date_to
1553
312
result = payslip.sum('EI',date_from,date_to) + EI</field>
1554
313
        </record>
1555
314
1556
315
        <record id="hr_salary_rule_empc" model="hr.salary.rule">
1557
316
            <field name="name">Employer CPP Contribution(EMPC)</field>
1558
317
            <field eval="146" name="sequence"/>
1559
318
            <field name="code">EMPC</field>
1560
319
            <field name="category_id" ref="EMP"/>
1561
320
            <field eval="0" name="appears_on_payslip"/>
1562
321
            <field eval="1" name="active"/>
1563
322
            <field name="condition_select">python</field>
1564
323
            <field name="condition_python">result = not employee.cpp_exempt</field>
1565
324
            <field name="amount_select">percentage</field>
1566
325
            <field name="amount_percentage_base">I</field>
1567
326
            <field name="quantity">1.0</field>
1568
327
            <field name="amount_percentage">100.0</field>
1569
328
        </record>
1570
329
1571
330
        <record id="hr_salary_rule_empei" model="hr.salary.rule">
1572
331
            <field name="name">Employer EI Contribution(EMPEI)</field>
1573
332
            <field eval="146" name="sequence"/>
1574
333
            <field name="code">EMPEI</field>
1575
334
            <field name="category_id" ref="EMP"/>
1576
335
            <field eval="0" name="appears_on_payslip"/>
1577
336
            <field eval="1" name="active"/>
1578
337
            <field name="condition_select">python</field>
1579
338
            <field name="condition_python">result = not employee.ei_exempt</field>
1580
339
            <field name="amount_select">percentage</field>
1581
340
            <field name="amount_percentage_base">EI</field>
1582
341
            <field name="quantity">1.0</field>
1583
342
            <field name="amount_percentage">140.0</field>
1584
343
        </record>
1585
344
1586
345
        <record id="hr_salary_rule_k" model="hr.salary.rule">
1587
346
            <field name="name">Annual Federal Constant(K)</field>
1588
347
            <field eval="150" name="sequence"/>
1589
348
            <field name="code">K</field>
1590
349
            <field name="category_id" ref="FCALC"/>
1591
350
            <field eval="0" name="appears_on_payslip"/>
1592
351
            <field eval="1" name="active"/>
1593
352
            <field name="condition_select">none</field>
1594
353
            <field name="amount_select">code</field>
1595
354
            <field name="amount_python_compute">result = (A &gt; 132406 and 10378) or (A &gt; 85424 and 6406) or (A &gt; 42707 and 2989) or 0.0</field>
1596
355
        </record>
1597
356
1598
357
        <record id="hr_salary_rule_k1" model="hr.salary.rule">
1599
358
            <field name="name">Federal Personal Credit(K1)</field>
1600
359
            <field eval="150" name="sequence"/>
1601
360
            <field name="code">K1</field>
1602
361
            <field name="category_id" ref="FCALC"/>
1603
362
            <field eval="0" name="appears_on_payslip"/>
1604
363
            <field eval="1" name="active"/>
1605
364
            <field name="condition_select">none</field>
1606
365
            <field name="amount_select">code</field>
1607
366
            <field name="amount_python_compute">result = employee.td1f == 1 and 1623.30 or employee.td1f == 2 and 1778.40 or employee.td1f == 3 and 2088.60 or employee.td1f == 4 and 2398.80 or employee.td1f == 5 and 2709.00 or employee.td1f == 6 and 3019.20 or employee.td1f == 7 and 3329.40 or employee.td1f == 8 and 3639.60 or employee.td1f == 9 and 3949.80 or employee.td1f == 10 and 4260.00 or employee.td1f == 0 and 0.0</field>
1608
367
            <field name="notes">Federal non-refundable personal tax credit.
1609
368
Appears on the Employee Form in Canadian Payroll.</field>
1610
369
        </record>
1611
370
1612
371
        <record id="hr_salary_rule_k2" model="hr.salary.rule">
1613
372
            <field name="name">Annual Federal CPP/QPP(K2)</field>
1614
373
            <field eval="150" name="sequence"/>
1615
374
            <field name="code">K2</field>
1616
375
            <field name="category_id" ref="FCALC"/>
1617
376
            <field eval="0" name="appears_on_payslip"/>
1618
377
            <field eval="1" name="active"/>
1619
378
            <field name="condition_select">none</field>
1620
379
            <field name="amount_select">code</field>
1621
380
            <field name="amount_python_compute">result = (0.15 * min(CPPYTD + (PR * C), CPPMAX)) + (0.15 * min(EIYTD + (PR * EI), EIMAX))</field>
1622
381
            <field name="notes">Federal Canada (or Quebec) Pension Plan contributions and employment insurance premiums tax credits for the year.
1623
382
Used for calculations only</field>
1624
383
        </record>
1625
384
1626
385
        <record id="hr_salary_rule_k3" model="hr.salary.rule">
1627
386
            <field name="name">Other Federal Tax Credits(K3)</field>
1628
387
            <field eval="150" name="sequence"/>
1629
388
            <field name="code">K3</field>
1630
389
            <field name="category_id" ref="FCALC"/>
1631
390
            <field eval="0" name="appears_on_payslip"/>
1632
391
            <field eval="1" name="active"/>
1633
392
            <field name="condition_select">none</field>
1634
393
            <field name="amount_select">code</field>
1635
394
            <field name="amount_python_compute">result = employee.k3 or 0.0</field>
1636
395
            <field name="notes">Other federal tax credits (such as medical expenses and charitable donations authorized by a tax services office or tax centre) 
1637
396
Appears on the Employee Form in Canadian Payroll.</field>
1638
397
        </record>
1639
398
1640
399
        <record id="hr_salary_rule_k4" model="hr.salary.rule">
1641
400
            <field name="name">Canada Employment Credit(K4)</field>
1642
401
            <field eval="150" name="sequence"/>
1643
402
            <field name="code">K4</field>
1644
403
            <field name="category_id" ref="FCALC"/>
1645
404
            <field eval="0" name="appears_on_payslip"/>
1646
405
            <field eval="1" name="active"/>
1647
406
            <field name="condition_select">none</field>
1648
407
            <field name="amount_select">code</field>
1649
408
            <field name="amount_python_compute">result = min(0.15 * A, 0.15 * 1095)</field>
1650
409
            <field name="notes">Canada employment credit.
1651
410
Used for calculations only</field>
1652
411
        </record>
1653
412
1654
413
        <record id="hr_salary_rule_tcp" model="hr.salary.rule">
1655
414
            <field name="name">Provincial Claim Amount(TCP)</field>
1656
415
            <field eval="150" name="sequence"/>
1657
416
            <field name="code">TCP</field>
1658
417
            <field name="category_id" ref="PCALC"/>
1659
418
            <field eval="0" name="appears_on_payslip"/>
1660
419
            <field eval="1" name="active"/>
1661
420
            <field name="condition_select">none</field>
1662
421
            <field name="amount_select">code</field>
1663
422
            <field name="amount_python_compute">result = employee.td1p == 1 and 9405.00 or employee.td1p == 2 and 10418.00 or employee.td1p == 3 and 12444.00 or employee.td1p == 4 and 14470.00 or employee.td1p == 5 and 16496.00 or employee.td1p == 6 and 18522.00 or employee.td1p == 7 and 20548.00 or employee.td1p == 8 and 22574.00 or employee.td1p == 9 and 24600.00 or employee.td1p == 10 and 26626.00 or employee.td1p == 0 and 0.0</field>
1664
423
        </record>
1665
424
1666
425
        <record id="hr_salary_rule_v" model="hr.salary.rule">
1667
426
            <field name="name">Annual Provincial Tax Rate(V)</field>
1668
427
            <field eval="150" name="sequence"/>
1669
428
            <field name="code">V</field>
1670
429
            <field name="category_id" ref="PCALC"/>
1671
430
            <field eval="0" name="appears_on_payslip"/>
1672
431
            <field eval="1" name="active"/>
1673
432
            <field name="condition_select">none</field>
1674
433
            <field name="amount_select">code</field>
1675
434
            <field name="amount_python_compute">result = (A &gt; 78043 and 0.1116) or (A &gt; 39020 and A &lt;= 78043 and 0.0915) or 0.0505</field>
1676
435
        </record>
1677
436
1678
437
        <record id="hr_salary_rule_kp" model="hr.salary.rule">
1679
438
            <field name="name">Provincial Constant(KP)</field>
1680
439
            <field eval="150" name="sequence"/>
1681
440
            <field name="code">KP</field>
1682
441
            <field name="category_id" ref="PCALC"/>
1683
442
            <field eval="0" name="appears_on_payslip"/>
1684
443
            <field eval="1" name="active"/>
1685
444
            <field name="condition_select">none</field>
1686
445
            <field name="amount_select">code</field>
1687
446
            <field name="amount_python_compute">result = (A &gt; 78043 and 3168) or (A &gt; 39020 and A &lt;= 78043 and 1600) or 0</field>
1688
447
        </record>
1689
448
1690
449
        <record id="hr_salary_rule_k1p" model="hr.salary.rule">
1691
450
            <field name="name">Provincial Personal Tax Credit(K1P)</field>
1692
451
            <field eval="151" name="sequence"/>
1693
452
            <field name="code">K1P</field>
1694
453
            <field name="category_id" ref="PCALC"/>
1695
454
            <field eval="0" name="appears_on_payslip"/>
1696
455
            <field eval="1" name="active"/>
1697
456
            <field name="condition_select">none</field>
1698
457
            <field name="amount_select">code</field>
1699
458
            <field name="amount_python_compute">result = 0.0505 * TCP</field>
1700
459
        </record>
1701
460
1702
461
        <record id="hr_salary_rule_k2p" model="hr.salary.rule">
1703
462
            <field name="name">Provincial CPP and EI Tax Credits(K2P)</field>
1704
463
            <field eval="151" name="sequence"/>
1705
464
            <field name="code">K2P</field>
1706
465
            <field name="category_id" ref="PCALC"/>
1707
466
            <field eval="0" name="appears_on_payslip"/>
1708
467
            <field eval="1" name="active"/>
1709
468
            <field name="condition_select">none</field>
1710
469
            <field name="amount_select">code</field>
1711
470
            <field name="amount_python_compute">result = (0.0505 * min(CPPYTD + (PR * C), CPPMAX)) + (0.0505 * min(EIYTD + (PR * EI), EIMAX))</field>
1712
471
        </record>
1713
472
1714
473
        <record id="hr_salary_rule_t4" model="hr.salary.rule">
1715
474
            <field name="name">Annual Basic Provincial Tax(T4)</field>
1716
475
            <field eval="154" name="sequence"/>
1717
476
            <field name="code">T4</field>
1718
477
            <field name="category_id" ref="PCALC"/>
1719
478
            <field eval="0" name="appears_on_payslip"/>
1720
479
            <field eval="1" name="active"/>
1721
480
            <field name="condition_select">none</field>
1722
481
            <field name="amount_select">code</field>
1723
482
            <field name="amount_python_compute">result = max((V * A) - KP - K1P - K2P, 0.0)</field>
1724
483
        </record>
1725
484
1726
485
        <record id="hr_salary_rule_v1" model="hr.salary.rule">
1727
486
            <field name="name">Surtax on Basic Provincial Tax(V1)</field>
1728
487
            <field eval="155" name="sequence"/>
1729
488
            <field name="code">V1</field>
1730
489
            <field name="category_id" ref="PCALC"/>
1731
490
            <field eval="0" name="appears_on_payslip"/>
1732
491
            <field eval="1" name="active"/>
1733
492
            <field name="condition_select">none</field>
1734
493
            <field name="amount_select">code</field>
1735
494
            <field name="amount_python_compute">result = (T4 &gt; 5392 and (0.20 * (T4 - 4213)) + (0.36 * (T4 - 5392))) or (T4 &gt; 4213 and T4 &lt;= 5392 and (0.20 * (T4 - 4213))) or 0</field>
1736
495
        </record>
1737
496
1738
497
        <record id="hr_salary_rule_v2" model="hr.salary.rule">
1739
498
            <field name="name">Extra Tax for Ontario Health Premium(V2)</field>
1740
499
            <field eval="155" name="sequence"/>
1741
500
            <field name="code">V2</field>
1742
501
            <field name="category_id" ref="PCALC"/>
1743
502
            <field eval="0" name="appears_on_payslip"/>
1744
503
            <field eval="1" name="active"/>
1745
504
            <field name="condition_select">none</field>
1746
505
            <field name="amount_select">code</field>
1747
506
            <field name="amount_python_compute">result = (A &gt; 200000 and min(900, (750 + (0.25 * (A - 200000))))) or (A &gt; 72000 and A &lt;= 200000 and min(750, (600 + (0.25 * (A - 72000))))) or (A &gt; 48000 and A &lt;= 72000 and min(600, (450 + (0.25 * (A - 48000))))) or (A &gt; 36000 and A &lt;= 48000 and min(450, (300 + (0.06 * (A - 36000))))) or (A &gt; 20000 and A &lt;= 36000 and min(300, (0.06 * (A - 20000)))) or 0</field>
1748
507
        </record>
1749
508
1750
509
        <record id="hr_salary_rule_s" model="hr.salary.rule">
1751
510
            <field name="name">Ontario or British Columbia Tax Reduction(S)</field>
1752
511
            <field eval="156" name="sequence"/>
1753
512
            <field name="code">S</field>
1754
513
            <field name="category_id" ref="PCALC"/>
1755
514
            <field eval="0" name="appears_on_payslip"/>
1756
515
            <field eval="1" name="active"/>
1757
516
            <field name="condition_select">none</field>
1758
517
            <field name="amount_select">code</field>
1759
518
            <field name="amount_python_compute">result = max(min((2 * (217 + employee.y) - (T4 + V1)), T4 + V1 ), 0.0)</field>
1760
519
        </record>
1761
520
1762
521
        <record id="hr_salary_rule_t3" model="hr.salary.rule">
1763
522
            <field name="name">Annual Basic Federal Tax(T3)</field>
1764
523
            <field eval="170" name="sequence"/>
1765
524
            <field name="code">T3</field>
1766
525
            <field name="category_id" ref="FCALC"/>
1767
526
            <field eval="0" name="appears_on_payslip"/>
1768
527
            <field eval="1" name="active"/>
1769
528
            <field name="condition_select">none</field>
1770
529
            <field name="amount_select">code</field>
1771
530
            <field name="amount_python_compute">result = max((R * A) - K - K1 - K2 - K3 - K4, 0.0)</field>
1772
531
        </record>
1773
532
1774
533
        <record id="hr_salary_rule_t1" model="hr.salary.rule">
1775
534
            <field name="name">Annual Federal Tax(T1)</field>
1776
535
            <field eval="170" name="sequence"/>
1777
536
            <field name="code">T1</field>
1778
537
            <field name="category_id" ref="FCALC"/>
1779
538
            <field eval="0" name="appears_on_payslip"/>
1780
539
            <field eval="1" name="active"/>
1781
540
            <field name="condition_select">none</field>
1782
541
            <field name="amount_select">code</field>
1783
542
            <field name="amount_python_compute">result = max(T3 - employee.lcf, 0.0)</field>
1784
543
        </record>
1785
544
1786
545
        <record id="hr_salary_rule_t2" model="hr.salary.rule">
1787
546
            <field name="name">Annual Provincial Tax Deduction - Ontario(T2)</field>
1788
547
            <field eval="160" name="sequence"/>
1789
548
            <field name="code">T2</field>
1790
549
            <field name="category_id" ref="PCALC"/>
1791
550
            <field eval="0" name="appears_on_payslip"/>
1792
551
            <field eval="1" name="active"/>
1793
552
            <field name="condition_select">none</field>
1794
553
            <field name="amount_select">code</field>
1795
554
            <field name="amount_python_compute">result = max(T4 + V1 + V2 - S - employee.lcp, 0.0)</field>
1796
555
        </record>
1797
556
1798
557
        <record id="hr_salary_rule_t" model="hr.salary.rule">
1799
558
            <field name="name">Tax Deductions(T)</field>
1800
559
            <field eval="190" name="sequence"/>
1801
560
            <field name="code">T</field>
1802
561
            <field name="category_id" ref="hr_payroll.DED"/>
1803
562
            <field eval="1" name="appears_on_payslip"/>
1804
563
            <field eval="1" name="active"/>
1805
564
            <field name="condition_select">none</field>
1806
565
            <field name="amount_select">code</field>
1807
566
            <field name="amount_python_compute">result = ((T1 + T2) / P) + L</field>
1808
567
        </record>
1809
568
1810
569
        <record id="hr_salary_rule_net" model="hr.salary.rule">
1811
570
            <field name="name">Net Pay(N)</field>
1812
571
            <field eval="200" name="sequence"/>
1813
572
            <field name="code">N</field>
1814
573
            <field name="category_id" ref="hr_payroll.NET"/>
1815
574
            <field eval="1" name="appears_on_payslip"/>
1816
575
            <field eval="1" name="active"/>
1817
576
            <field name="condition_select">none</field>
1818
577
            <field name="amount_select">code</field>
1819
578
            <field name="amount_python_compute">result = categories.I + categories.ALW - categories.DED - categories.SDED</field>
1820
579
        </record>
1821
580
1822
581
        <!-- Inputs -->
1823
582
        
1824
583
        <record id="hr_input_l" model="hr.rule.input">
1825
584
            <field name="name">Extra Tax Deductions(L)</field>
1826
585
            <field name="code">L</field>
1827
586
            <field name="input_id" ref="hr_salary_rule_l"/>
1828
587
        </record>
1829
588
1830
589
        <!-- Salary Structure -->
1831
590
         <record id="hr_structure_cabase" model="hr.payroll.structure">
1832
591
            <field name="code">CABASE</field>
1833
592
            <field name="name">Ontario Base - Non-Commisioned</field>
1834
593
            <field eval="[(6, 0, [ref('hr_salary_rule_p'), ref('hr_salary_rule_pocc'), ref('hr_salary_rule_pr'), ref('hr_salary_rule_cppmax'), ref('hr_salary_rule_eimax'), ref('hr_salary_rule_ca_wage'), ref('hr_salary_rule_vpay'), ref('hr_salary_rule_u1'), ref('hr_salary_rule_l'), ref('hr_salary_rule_hd'), ref('hr_salary_rule_f'), ref('hr_salary_rule_f1'),  ref('hr_salary_rule_f2'), ref('hr_salary_rule_i'), ref('hr_salary_rule_pi_ytd'), ref('hr_salary_rule_ie_ytd'), ref('hr_salary_rule_a'), ref('hr_salary_rule_r'), ref('hr_salary_rule_c'), ref('hr_salary_rule_ei'), ref('hr_salary_rule_c_ytd'), ref('hr_salary_rule_ei_ytd'), ref('hr_salary_rule_empc'), ref('hr_salary_rule_empei'), ref('hr_salary_rule_k'), ref('hr_salary_rule_k1'), ref('hr_salary_rule_k2'), ref('hr_salary_rule_k3'), ref('hr_salary_rule_k4'), ref('hr_salary_rule_tcp'), ref('hr_salary_rule_v'),ref('hr_salary_rule_kp'), ref('hr_salary_rule_k1p'), ref('hr_salary_rule_k2p'), ref('hr_salary_rule_t4'), ref('hr_salary_rule_v1'), ref('hr_salary_rule_v2'), ref('hr_salary_rule_s'), ref('hr_salary_rule_t2'), ref('hr_salary_rule_t1'), ref('hr_salary_rule_t3'), ref('hr_salary_rule_t'), ref('hr_salary_rule_net')])]" name="rule_ids"/>
1835
594
        </record>
1836
595
1837
596
    </data>
1838
597
</openerp>
1839
0
598
1840
=== added file 'l10n_ca_on_hr_payroll/l10n_ca_on_hr_payroll_view.xml'
1841
--- l10n_ca_on_hr_payroll/l10n_ca_on_hr_payroll_view.xml	1970-01-01 00:00:00 +0000
1842
+++ l10n_ca_on_hr_payroll/l10n_ca_on_hr_payroll_view.xml	2012-12-21 16:45:28 +0000
1843
@@ -0,0 +1,149 @@
1844
1
<?xml version="1.0" encoding="utf-8"?>
1845
2
<openerp>
1846
3
  <data>
1847
4
      <!--
1848
5
      <record id="hr_payroll_tax_table_form" model="ir.ui.view">
1849
6
          <field name="name">hr.payroll.tax.table.form</field>
1850
7
          <field name="model">hr.payroll.tax.table</field>
1851
8
          <field name="type">form</field>
1852
9
          <field name="arch" type="xml">
1853
10
              <form string="Canadian Tax Table">
1854
11
                   <field name="name" select="1" readonly="1"/>
1855
12
                   <field name="year" select="1" on_change="onchange_year(year,province)"/>
1856
13
                   <field name="date_from"/>
1857
14
                   <field name="date_to"/>
1858
15
                   <field name="fed_prov"/>
1859
16
                   <field name="province" attrs="{'readonly': [('fed_prov','!=','provincial')], 'required': [('fed_prov','=','provincial')]}" on_change="onchange_year(year,province)"/>
1860
17
                   <field name="line_ids" nolabel="1" colspan="4" widget="one2many_list"/>
1861
18
                </form>
1862
19
            </field>
1863
20
        </record>
1864
21
1865
22
        <record id="hr_payroll_tax_table_tree" model="ir.ui.view">
1866
23
          <field name="name">hr.payroll.tax.table.tree</field>
1867
24
          <field name="model">hr.payroll.tax.table</field>
1868
25
          <field name="type">tree</field>
1869
26
          <field name="arch" type="xml">
1870
27
              <tree string="Canadian Tax Table">
1871
28
                   <field name="name" />
1872
29
                   <field name="year" />
1873
30
                   <field name="fed_prov"/>
1874
31
                   <field name="province" />
1875
32
                </tree>
1876
33
            </field>
1877
34
        </record>
1878
35
                
1879
36
      <record id="hr_payroll_tax_table_line_form" model="ir.ui.view">
1880
37
          <field name="name">hr.payroll.tax.table.line.form</field>
1881
38
          <field name="model">hr.payroll.tax.table.line</field>
1882
39
          <field name="type">form</field>
1883
40
          <field name="arch" type="xml">
1884
41
              <form string="Canadian Tax Table">
1885
42
                   <group col="6" colspan="4">
1886
43
                       <field name="name" readonly="1"/>
1887
44
                       <field name="code" select="1" colspan="1"/>
1888
45
                       <field name="inc_from"/>
1889
46
                       <field name="inc_to" />
1890
47
                       <field name="rate" />
1891
48
                   </group>
1892
49
                </form>
1893
50
            </field>
1894
51
        </record>
1895
52
1896
53
      <record id="hr_payroll_tax_table_line_tree" model="ir.ui.view">
1897
54
          <field name="name">hr.payroll.tax.table.line.tree</field>
1898
55
          <field name="model">hr.payroll.tax.table.line</field>
1899
56
          <field name="type">tree</field>
1900
57
          <field name="arch" type="xml">
1901
58
              <tree string="Canadian Tax Table">
1902
59
                   <field name="name" readonly="1"/>
1903
60
                   <field name="code" select="1" colspan="1"/>
1904
61
                   <field name="inc_from"/>
1905
62
                   <field name="inc_to" />
1906
63
                   <field name="rate" />
1907
64
                </tree>
1908
65
            </field>
1909
66
        </record>
1910
67
1911
68
    <record id="action_hr_payroll_tax_table_tree" model="ir.actions.act_window">
1912
69
      <field name="name">Canadian Tax Table</field>
1913
70
      <field name="res_model">hr.payroll.tax.table</field>
1914
71
      <field name="view_type">form</field>
1915
72
      <field name="view_mode">tree,form</field>
1916
73
      <field name="view_id" ref="hr_payroll_tax_table_tree"/>
1917
74
    </record>
1918
75
1919
76
    <menuitem id="menu_hr_payroll_tax_table_tree" action="action_hr_payroll_tax_table_tree" parent="hr_payroll.payroll_configure"/>
1920
77
    -->
1921
78
1922
79
    <record id="hr_employee_view_form_inherit" model="ir.ui.view">
1923
80
        <field name="name">hr.employee.view.form.inherit</field>
1924
81
        <field name="model">hr.employee</field>
1925
82
        <field name="type">form</field>
1926
83
        <field name="inherit_id" ref="hr.view_employee_form"/>
1927
84
        <field name="arch" type="xml">
1928
85
            <notebook position="inside">
1929
86
                <page string="Canadian Payroll">
1930
87
                    <group colspan="1" col="2">
1931
88
                        <separator string="Claim Codes" colspan="2"/>
1932
89
                        <field name="td1f" colspan="1"/>
1933
90
                        <field name="td1p" colspan="1"/>
1934
91
                    </group>
1935
92
                    <group colspan="3" col="2">
1936
93
                        <separator string="Exemptions" colspan="2"/>
1937
94
                        <group colspan="1" col="2">
1938
95
                            <field name="ei_ytd_adj"/>
1939
96
                            <field name="cpp_ytd_adj"/>
1940
97
                        </group>
1941
98
                        <group colspan="1" col="2">
1942
99
                            <field name="ei_exempt"/>
1943
100
                            <field name="cpp_exempt"/>
1944
101
                            <field name="qpip_exempt"/>
1945
102
                        </group>
1946
103
                    </group>
1947
104
                    <separator string="Deductions" colspan="4"/>
1948
105
                    <field name="f1"/>
1949
106
                    <field name="f2"/>
1950
107
                    <field name="hd"/>
1951
108
                    <field name="lcf"/>
1952
109
                    <field name="lcp"/>
1953
110
                    <field name="f"/>
1954
111
                    <field name="k3"/>
1955
112
                    <field name="u1"/>
1956
113
                    <field name="y"/>
1957
114
                    <field name="l"/>
1958
115
                </page>
1959
116
            </notebook>
1960
117
        </field>
1961
118
    </record>
1962
119
1963
120
    <!-- Contract View -->
1964
121
    <record id="hr_contract_form_inherit" model="ir.ui.view">
1965
122
        <field name="name">hr.contract.view.form.inherit</field>
1966
123
        <field name="model">hr.contract</field>
1967
124
        <field name="type">form</field>
1968
125
        <field name="inherit_id" ref="hr_contract.hr_contract_view_form"/>
1969
126
        <field name="arch" type="xml">
1970
127
             <xpath expr="/form/notebook/page/group/field[@name='working_hours']" position="after">
1971
128
                <field name="pays_per_year"/>
1972
129
            </xpath>
1973
130
        </field>
1974
131
    </record>
1975
132
1976
133
    <!-- End Contract View-->
1977
134
1978
135
    <!-- Salary Rules - unhide the sequence, not sure why it's invisible -->
1979
136
    <record id="hr_salary_rule_list_inherit" model="ir.ui.view">
1980
137
        <field name="name">hr.salary.rule.list.inherit</field>
1981
138
        <field name="model">hr.salary.rule</field>
1982
139
        <field name="type">tree</field>
1983
140
        <field name="inherit_id" ref="hr_payroll.hr_salary_rule_list"/>
1984
141
        <field name="arch" type="xml">
1985
142
            <xpath expr="//field[@name='sequence']" position="replace">
1986
143
                <field name="sequence" groups="base.group_extended"/>
1987
144
            </xpath>
1988
145
        </field>
1989
146
    </record>
1990
147
1991
148
  </data>
1992
149
</openerp>
1993
0
150
1994
=== added directory 'l10n_ca_on_hr_payroll/static'
1995
=== added directory 'l10n_ca_on_hr_payroll/static/src'
1996
=== added directory 'l10n_ca_on_hr_payroll/static/src/img'
1997
=== added file 'l10n_ca_on_hr_payroll/static/src/img/icon.png'
1998
1
Binary files l10n_ca_on_hr_payroll/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and l10n_ca_on_hr_payroll/static/src/img/icon.png	2012-12-21 16:45:28 +0000 differ
151
Binary files l10n_ca_on_hr_payroll/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and l10n_ca_on_hr_payroll/static/src/img/icon.png	2012-12-21 16:45:28 +0000 differ
1999
=== added directory 'l10n_ca_qc_hr_payroll'
2000
=== added file 'l10n_ca_qc_hr_payroll/__init__.py'
2001
--- l10n_ca_qc_hr_payroll/__init__.py	1970-01-01 00:00:00 +0000
2002
+++ l10n_ca_qc_hr_payroll/__init__.py	2012-12-21 16:45:28 +0000
2003
@@ -0,0 +1,24 @@
2004
1
#-*- coding:utf-8 -*-
2005
2
##############################################################################
2006
3
#
2007
4
#    Copyright (C) 2012 OpenERP Canada. All Rights Reserved.
2008
5
#
2009
6
#    This program is free software: you can redistribute it and/or modify
2010
7
#    it under the terms of the GNU Affero General Public License as published
2011
8
#    by
2012
9
#    the Free Software Foundation, either version 3 of the License, or
2013
10
#    (at your option) any later version.
2014
11
#
2015
12
#    This program is distributed in the hope that it will be useful,
2016
13
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
2017
14
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
2018
15
#    GNU Affero General Public License for more details.
2019
16
#
2020
17
#    You should have received a copy of the GNU Affero General Public License
2021
18
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
2022
19
#
2023
20
##############################################################################
2024
21
2025
22
import l10n_ca_qc_hr_payroll
2026
23
2027
24
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
2028
0
25
2029
=== added file 'l10n_ca_qc_hr_payroll/__openerp__.py'
2030
--- l10n_ca_qc_hr_payroll/__openerp__.py	1970-01-01 00:00:00 +0000
2031
+++ l10n_ca_qc_hr_payroll/__openerp__.py	2012-12-21 16:45:28 +0000
2032
@@ -0,0 +1,46 @@
2033
1
#-*- coding:utf-8 -*-
2034
2
##############################################################################
2035
3
#
2036
4
#    Copyright (C) 2012 Savoir-faire Linux. All Rights Reserved.
2037
5
#
2038
6
#    This program is free software: you can redistribute it and/or modify
2039
7
#    it under the terms of the GNU Affero General Public License as published by
2040
8
#    the Free Software Foundation, either version 3 of the License, or
2041
9
#    (at your option) any later version.
2042
10
#
2043
11
#    This program is distributed in the hope that it will be useful,
2044
12
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
2045
13
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
2046
14
#    GNU Affero General Public License for more details.
2047
15
#
2048
16
#    You should have received a copy of the GNU Affero General Public License
2049
17
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
2050
18
#
2051
19
##############################################################################
2052
20
{
2053
21
    'name': 'Canada - Quebec - Payroll',
2054
22
    'category': 'Localization',
2055
23
    'version': '0.1',
2056
24
    'license': 'AGPL-3',
2057
25
    'category': 'Generic Modules/Human Resources',
2058
26
    'description': """
2059
27
Quebec Payroll Rules
2060
28
==============================
2061
29
 * Adds all Quebec Salary Rules
2062
30
    """,
2063
31
    'author':'Savoir-faire Linux',
2064
32
    'website':'http://www.savoirfairelinux.com',
2065
33
    'depends': [
2066
34
        'l10n_ca_hr_payroll',
2067
35
    ],
2068
36
    'data': [
2069
37
        'l10n_ca_qc_hr_payroll_view.xml',
2070
38
        'l10n_ca_qc_hr_payroll_data.xml',
2071
39
    ],
2072
40
    'test': [],
2073
41
    'demo': [],
2074
42
    'installable': True,
2075
43
    'active': False,
2076
44
}
2077
45
2078
46
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
2079
0
47
2080
=== added file 'l10n_ca_qc_hr_payroll/l10n_ca_qc_hr_payroll.py'
2081
--- l10n_ca_qc_hr_payroll/l10n_ca_qc_hr_payroll.py	1970-01-01 00:00:00 +0000
2082
+++ l10n_ca_qc_hr_payroll/l10n_ca_qc_hr_payroll.py	2012-12-21 16:45:28 +0000
2083
@@ -0,0 +1,38 @@
2084
1
#-*- coding:utf-8 -*-
2085
2
##############################################################################
2086
3
#
2087
4
#    Copyright (C) 2012 Savoir-faire Linux. All Rights Reserved.
2088
5
#
2089
6
#    This program is free software: you can redistribute it and/or modify
2090
7
#    it under the terms of the GNU Affero General Public License as published
2091
8
#    by
2092
9
#    the Free Software Foundation, either version 3 of the License, or
2093
10
#    (at your option) any later version.
2094
11
#
2095
12
#    This program is distributed in the hope that it will be useful,
2096
13
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
2097
14
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
2098
15
#    GNU Affero General Public License for more details.
2099
16
#
2100
17
#    You should have received a copy of the GNU Affero General Public License
2101
18
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
2102
19
#
2103
20
##############################################################################
2104
21
2105
22
from osv import fields, osv
2106
23
2107
24
class hr_employee(osv.osv):
2108
25
    _name = 'hr.employee'
2109
26
    _inherit = 'hr.employee'
2110
27
2111
28
    _columns = {
2112
29
        'tp10153': fields.float('Source Deductions Return (TP-1015.3)', digits=(16,2), required=True, help="Source Deductions Return"),
2113
30
            }
2114
31
2115
32
    _defaults = {
2116
33
        'tp10153': 10925.00,
2117
34
        }
2118
35
2119
36
hr_employee()
2120
37
2121
38
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
2122
0
39
2123
=== added file 'l10n_ca_qc_hr_payroll/l10n_ca_qc_hr_payroll_data.xml'
2124
--- l10n_ca_qc_hr_payroll/l10n_ca_qc_hr_payroll_data.xml	1970-01-01 00:00:00 +0000
2125
+++ l10n_ca_qc_hr_payroll/l10n_ca_qc_hr_payroll_data.xml	2012-12-21 16:45:28 +0000
2126
@@ -0,0 +1,534 @@
2127
1
<?xml version="1.0" encoding="utf-8"?>
2128
2
<openerp>
2129
3
    <data noupdate="1">
2130
4
2131
5
	<!-- Quebec Parental Insurance Plan - 120 -->
2132
6
2133
7
        <record id="rule_qc_qpip_maxie" model="hr.salary.rule">
2134
8
            <field name="name">QPIP - Employee and Employer Maximum Insurable Earnings (QPIPMAXIE)</field>
2135
9
            <field name="sequence" eval="120"/>
2136
10
            <field name="code">QPIPMAXIE</field>
2137
11
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2138
12
            <field name="appears_on_payslip" eval="0"/>
2139
13
            <field name="active" eval="1"/>
2140
14
            <field name="condition_select">none</field>
2141
15
            <field name="amount_select">code</field>
2142
16
            <field name="amount_python_compute">result = min(GROSS,66000)</field>
2143
17
        </record>
2144
18
2145
19
	<!-- Quebec Parental Insurance Plan - Employee - 121 -->
2146
20
2147
21
        <record id="rule_qc_qpip_ee_rate" model="hr.salary.rule">
2148
22
            <field name="name">QPIP - Employee Rate - 0.559 % (QPIPRATE)</field>
2149
23
            <field name="sequence" eval="121"/>
2150
24
            <field name="code">QPIPEERATE</field>
2151
25
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2152
26
            <field name="appears_on_payslip" eval="0"/>
2153
27
            <field name="active" eval="1"/>
2154
28
            <field name="condition_select">none</field>
2155
29
            <field name="amount_select">fix</field>
2156
30
            <field name="quantity">1.0</field>
2157
31
            <field name="amount_fix">0.559</field>
2158
32
        </record>
2159
33
2160
34
        <record id="rule_qc_qpip_ee_maxc" model="hr.salary.rule">
2161
35
            <field name="name">QPIP - Employee Maximum Contribution (QPIPEEMAXC)</field>
2162
36
            <field name="sequence" eval="122"/>
2163
37
            <field name="code">QPIPEEMAXC</field>
2164
38
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2165
39
            <field name="appears_on_payslip" eval="0"/>
2166
40
            <field name="active" eval="1"/>
2167
41
            <field name="condition_select">none</field>
2168
42
            <field name="amount_select">code</field>
2169
43
            <field name="amount_python_compute">result = QPIPMAXIE * QPIPEERATE * 0.01</field>
2170
44
        </record>
2171
45
2172
46
        <record id="rule_qc_qpip_ee_pytdc" model="hr.salary.rule">
2173
47
            <field name="name">QPIP - Employee - Previous Year To Date Contribution (QPIPEEPYTDC)</field>
2174
48
            <field name="sequence" eval="122"/>
2175
49
            <field name="code">QPIPEEPYTDC</field>
2176
50
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2177
51
            <field name="appears_on_payslip" eval="0"/>
2178
52
            <field name="active" eval="1"/>
2179
53
            <field name="condition_select">none</field>
2180
54
            <field name="amount_select">code</field>
2181
55
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
2182
56
date_to = payslip.date_to
2183
57
result = payslip.sum('QPIPEEYTDC',date_from,date_to)
2184
58
	    </field>
2185
59
        </record>
2186
60
2187
61
        <record id="rule_qc_qpip_ee_c" model="hr.salary.rule">
2188
62
            <field name="name">QPIP - Employee Contribution (QPIPEEC)</field>
2189
63
            <field name="sequence" eval="123"/>
2190
64
            <field name="code">QPIPEEC</field>
2191
65
            <field name="category_id" ref="hr_payroll.DED"/>
2192
66
            <field name="appears_on_payslip" eval="1"/>
2193
67
            <field name="active" eval="1"/>
2194
68
            <field name="condition_select">none</field>
2195
69
            <field name="amount_select">code</field>
2196
70
            <field name="amount_python_compute">if (QPIPEEPYTDC > QPIPEEMAXC): 
2197
71
    result = 0
2198
72
else:
2199
73
    if (QPIPEEMAXC - QPIPEEPYTDC - (GROSS * QPIPEERATE * 0.01 / P) &gt;= 0):
2200
74
        result = GROSS * QPIPEERATE * 0.01 / P
2201
75
    else:
2202
76
        result = QPIPEEMAXC - QPIPEEPYTDC
2203
77
	    </field>
2204
78
        </record>
2205
79
2206
80
        <record id="rule_qc_qpip_ee_ytdc" model="hr.salary.rule">
2207
81
            <field name="name">QPIP - Employee - Year To Date Contribution (QPIPEEYTDC)</field>
2208
82
            <field name="sequence" eval="124"/>
2209
83
            <field name="code">QPIPEEYTDC</field>
2210
84
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2211
85
            <field name="appears_on_payslip" eval="1"/>
2212
86
            <field name="active" eval="1"/>
2213
87
            <field name="condition_select">none</field>
2214
88
            <field name="amount_select">code</field>
2215
89
            <field name="amount_python_compute">result = QPIPEEPYTDC + QPIPEEC</field>
2216
90
        </record>
2217
91
2218
92
	<!-- Quebec Parental Insurance Plan - Employer - 125 -->
2219
93
2220
94
        <record id="rule_qc_qpip_er_rate" model="hr.salary.rule">
2221
95
            <field name="name">QPIP - Employer Rate - 0.782 % (QPIPERRATE)</field>
2222
96
            <field name="sequence" eval="125"/>
2223
97
            <field name="code">QPIPERRATE</field>
2224
98
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2225
99
            <field name="appears_on_payslip" eval="0"/>
2226
100
            <field name="active" eval="1"/>
2227
101
            <field name="condition_select">none</field>
2228
102
            <field name="amount_select">fix</field>
2229
103
            <field name="quantity">1.0</field>
2230
104
            <field name="amount_fix">0.782</field>
2231
105
        </record>
2232
106
2233
107
        <record id="rule_qc_qpip_er_maxc" model="hr.salary.rule">
2234
108
            <field name="name">QPIP - Employer Maximum Contribution (QPIPERMAXC)</field>
2235
109
            <field name="sequence" eval="126"/>
2236
110
            <field name="code">QPIPERMAXC</field>
2237
111
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2238
112
            <field name="appears_on_payslip" eval="0"/>
2239
113
            <field name="active" eval="1"/>
2240
114
            <field name="condition_select">none</field>
2241
115
            <field name="amount_select">code</field>
2242
116
            <field name="amount_python_compute">result = QPIPMAXIE * QPIPERRATE * 0.01</field>
2243
117
        </record>
2244
118
2245
119
        <record id="rule_qc_qpip_er_pytdc" model="hr.salary.rule">
2246
120
            <field name="name">QPIP - Employer - Previous Year To Date Contribution (QPIPERPYTDC)</field>
2247
121
            <field name="sequence" eval="126"/>
2248
122
            <field name="code">QPIPERPYTDC</field>
2249
123
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2250
124
            <field name="appears_on_payslip" eval="0"/>
2251
125
            <field name="active" eval="1"/>
2252
126
            <field name="condition_select">none</field>
2253
127
            <field name="amount_select">code</field>
2254
128
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
2255
129
date_to = payslip.date_to
2256
130
result = payslip.sum('QPIPERYTDC',date_from,date_to)
2257
131
	    </field>
2258
132
        </record>
2259
133
2260
134
        <record id="rule_qc_qpip_er_c" model="hr.salary.rule">
2261
135
            <field name="name">QPIP - Employer Contribution (QPIPERC)</field>
2262
136
            <field name="sequence" eval="127"/>
2263
137
            <field name="code">QPIPERC</field>
2264
138
            <field name="category_id" ref="l10n_ca_hr_payroll.EMP"/>
2265
139
            <field name="appears_on_payslip" eval="0"/>
2266
140
            <field name="active" eval="1"/>
2267
141
            <field name="condition_select">none</field>
2268
142
            <field name="amount_select">code</field>
2269
143
            <field name="amount_python_compute">if (QPIPERPYTDC > QPIPERMAXC): 
2270
144
    result = 0
2271
145
else:
2272
146
    if (QPIPERMAXC - QPIPERPYTDC - (GROSS * QPIPERRATE * 0.01 / P) &gt;= 0):
2273
147
        result = GROSS * QPIPERRATE * 0.01 / P
2274
148
    else:
2275
149
        result = QPIPERMAXC - QPIPERPYTDC
2276
150
	    </field>
2277
151
        </record>
2278
152
2279
153
        <record id="rule_qc_qpip_er_ytdc" model="hr.salary.rule">
2280
154
            <field name="name">QPIP - Employer - Year To Date Contribution (QPIPERYTDC)</field>
2281
155
            <field name="sequence" eval="128"/>
2282
156
            <field name="code">QPIPERYTDC</field>
2283
157
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2284
158
            <field name="appears_on_payslip" eval="0"/>
2285
159
            <field name="active" eval="1"/>
2286
160
            <field name="condition_select">none</field>
2287
161
            <field name="amount_select">code</field>
2288
162
            <field name="amount_python_compute">result = QPIPERPYTDC + QPIPERC</field>
2289
163
        </record>
2290
164
2291
165
	<!-- Quebec Pension Plan - 130 -->
2292
166
2293
167
        <record id="rule_qc_qpp_maxie" model="hr.salary.rule">
2294
168
            <field name="name">QPP - Employee and Employer Maximum Insurable Earnings (QPPMAXIE)</field>
2295
169
            <field name="sequence" eval="130"/>
2296
170
            <field name="code">QPPMAXIE</field>
2297
171
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2298
172
            <field name="appears_on_payslip" eval="0"/>
2299
173
            <field name="active" eval="1"/>
2300
174
            <field name="condition_select">none</field>
2301
175
            <field name="amount_select">code</field>
2302
176
            <field name="amount_python_compute">result = min(GROSS,55100)</field>
2303
177
        </record>
2304
178
2305
179
	<!-- Quebec Pension Plan - Employee - 130 -->
2306
180
2307
181
        <record id="rule_qc_qpp_ee_rate" model="hr.salary.rule">
2308
182
            <field name="name">QPP - Employee - Rate 5.025% (QPPEERATE)</field>
2309
183
            <field name="sequence" eval="130"/>
2310
184
            <field name="code">QPPEERATE</field>
2311
185
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2312
186
            <field name="appears_on_payslip" eval="0"/>
2313
187
            <field name="active" eval="1"/>
2314
188
            <field name="condition_select">none</field>
2315
189
            <field name="amount_select">fix</field>
2316
190
            <field name="quantity">1.0</field>
2317
191
            <field name="amount_fix">5.025</field>
2318
192
        </record>
2319
193
2320
194
        <record id="rule_qc_qpp_ee_maxc" model="hr.salary.rule">
2321
195
            <field name="name">QPP - Employee - Maximum Contribution (QPPEEMAXC)</field>
2322
196
            <field name="sequence" eval="131"/>
2323
197
            <field name="code">QPPEEMAXC</field>
2324
198
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2325
199
            <field name="appears_on_payslip" eval="0"/>
2326
200
            <field name="active" eval="1"/>
2327
201
            <field name="condition_select">none</field>
2328
202
            <field name="amount_select">code</field>
2329
203
            <field name="amount_python_compute">result = QPPMAXIE * QPPEERATE * 0.01</field>
2330
204
        </record>
2331
205
2332
206
        <record id="rule_qc_qpp_ee_pytdc" model="hr.salary.rule">
2333
207
            <field name="name">QPP - Employee - Previous Year To Date Contribution (QPPEEPYTDC)</field>
2334
208
            <field name="sequence" eval="132"/>
2335
209
            <field name="code">QPPEEPYTDC</field>
2336
210
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2337
211
            <field name="appears_on_payslip" eval="0"/>
2338
212
            <field name="active" eval="1"/>
2339
213
            <field name="condition_select">none</field>
2340
214
            <field name="amount_select">code</field>
2341
215
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
2342
216
date_to = payslip.date_to
2343
217
result = payslip.sum('QPPEEYTDC',date_from,date_to)
2344
218
            </field>
2345
219
        </record>
2346
220
2347
221
        <record id="rule_qc_qpp_ee_c" model="hr.salary.rule">
2348
222
            <field name="name">QPP - Employee Contribution (QPPEEC)</field>
2349
223
            <field name="sequence" eval="133"/>
2350
224
            <field name="code">QPPEEC</field>
2351
225
            <field name="category_id" ref="hr_payroll.DED"/>
2352
226
            <field name="appears_on_payslip" eval="1"/>
2353
227
            <field name="active" eval="1"/>
2354
228
            <field name="condition_select">none</field>
2355
229
            <field name="amount_select">code</field>
2356
230
            <field name="amount_python_compute">if (QPPEEPYTDC > QPPEEMAXC):
2357
231
    result = 0
2358
232
else:
2359
233
    if (QPPEEMAXC - QPPEEPYTDC - (GROSS * QPPEERATE * 0.01 / P) &gt;= 0):
2360
234
        result = GROSS * QPPEERATE * 0.01 / P
2361
235
    else:
2362
236
        result = QPPEEMAXC - QPPEEPYTDC
2363
237
            </field>
2364
238
        </record>
2365
239
2366
240
        <record id="rule_qc_qpp_ee_ytdc" model="hr.salary.rule">
2367
241
            <field name="name">QPP - Employee - Year To Date Contribution (QPPEEYTDC)</field>
2368
242
            <field name="sequence" eval="134"/>
2369
243
            <field name="code">QPPEEYTDC</field>
2370
244
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2371
245
            <field name="appears_on_payslip" eval="1"/>
2372
246
            <field name="active" eval="1"/>
2373
247
            <field name="condition_select">none</field>
2374
248
            <field name="amount_select">code</field>
2375
249
            <field name="amount_python_compute">result = QPPEEPYTDC + QPPEEC</field>
2376
250
        </record>
2377
251
2378
252
	<!-- Quebec Pension Plan - Employer - 135 -->
2379
253
2380
254
        <record id="rule_qc_qpp_er_rate" model="hr.salary.rule">
2381
255
            <field name="name">QPP - Employer - Rate 5.025% (QPPERRATE)</field>
2382
256
            <field name="sequence" eval="135"/>
2383
257
            <field name="code">QPPERRATE</field>
2384
258
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2385
259
            <field name="appears_on_payslip" eval="0"/>
2386
260
            <field name="active" eval="1"/>
2387
261
            <field name="condition_select">none</field>
2388
262
            <field name="amount_select">fix</field>
2389
263
            <field name="quantity">1.0</field>
2390
264
            <field name="amount_fix">5.025</field>
2391
265
        </record>
2392
266
2393
267
        <record id="rule_qc_qpp_er_maxc" model="hr.salary.rule">
2394
268
            <field name="name">QPP - Employer - Maximum Contribution (QPPERMAXC)</field>
2395
269
            <field name="sequence" eval="136"/>
2396
270
            <field name="code">QPPERMAXC</field>
2397
271
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2398
272
            <field name="appears_on_payslip" eval="0"/>
2399
273
            <field name="active" eval="1"/>
2400
274
            <field name="condition_select">none</field>
2401
275
            <field name="amount_select">code</field>
2402
276
            <field name="amount_python_compute">result = QPPMAXIE * QPPERRATE * 0.01</field>
2403
277
        </record>
2404
278
2405
279
        <record id="rule_qc_qpp_er_pytdc" model="hr.salary.rule">
2406
280
            <field name="name">QPP - Employer - Previous Year To Date Contribution (QPPERPYTDC)</field>
2407
281
            <field name="sequence" eval="137"/>
2408
282
            <field name="code">QPPERPYTDC</field>
2409
283
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2410
284
            <field name="appears_on_payslip" eval="0"/>
2411
285
            <field name="active" eval="1"/>
2412
286
            <field name="condition_select">none</field>
2413
287
            <field name="amount_select">code</field>
2414
288
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
2415
289
date_to = payslip.date_to
2416
290
result = payslip.sum('QPPERYTDC',date_from,date_to)
2417
291
            </field>
2418
292
        </record>
2419
293
2420
294
        <record id="rule_qc_qpp_er_c" model="hr.salary.rule">
2421
295
            <field name="name">QPP - Employer Contribution (QPPERC)</field>
2422
296
            <field name="sequence" eval="138"/>
2423
297
            <field name="code">QPPERC</field>
2424
298
            <field name="category_id" ref="hr_payroll.DED"/>
2425
299
            <field name="appears_on_payslip" eval="0"/>
2426
300
            <field name="active" eval="1"/>
2427
301
            <field name="condition_select">none</field>
2428
302
            <field name="amount_select">code</field>
2429
303
            <field name="amount_python_compute">if (QPPERPYTDC > QPPERMAXC):
2430
304
    result = 0
2431
305
else:
2432
306
    if (QPPERMAXC - QPPERPYTDC - (GROSS * QPPERRATE * 0.01 / P) &gt;= 0):
2433
307
        result = GROSS * QPPERRATE * 0.01 / P
2434
308
    else:
2435
309
        result = QPPERMAXC - QPPERPYTDC
2436
310
            </field>
2437
311
        </record>
2438
312
2439
313
        <record id="rule_qc_qpp_er_ytdc" model="hr.salary.rule">
2440
314
            <field name="name">QPP - Employer - Year To Date Contribution (QPPERYTDC)</field>
2441
315
            <field name="sequence" eval="139"/>
2442
316
            <field name="code">QPPERYTDC</field>
2443
317
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2444
318
            <field name="appears_on_payslip" eval="0"/>
2445
319
            <field name="active" eval="1"/>
2446
320
            <field name="condition_select">none</field>
2447
321
            <field name="amount_select">code</field>
2448
322
            <field name="amount_python_compute">result = QPPERPYTDC + QPPERC</field>
2449
323
        </record>
2450
324
2451
325
	<!-- Employment insurance - Employee - 140 -->
2452
326
2453
327
        <record id="rule_qc_ei_ee_rate" model="hr.salary.rule">
2454
328
            <field name="name">EI - Employee - Rate 1.47% (EIEERATE)</field>
2455
329
            <field name="sequence" eval="140"/>
2456
330
            <field name="code">EIEERATE</field>
2457
331
            <field name="category_id" ref="l10n_ca_hr_payroll.FCALC"/>
2458
332
            <field name="appears_on_payslip" eval="0"/>
2459
333
            <field name="active" eval="1"/>
2460
334
            <field name="condition_select">none</field>
2461
335
            <field name="amount_select">fix</field>
2462
336
            <field name="quantity">1.0</field>
2463
337
            <field name="amount_fix">1.47</field>
2464
338
        </record>
2465
339
2466
340
        <record id="rule_qc_ei_ee_maxc" model="hr.salary.rule">
2467
341
            <field name="name">EI - Employee - Maximum Contribution (EIEEMAXC)</field>
2468
342
            <field name="sequence" eval="141"/>
2469
343
            <field name="code">EIEEMAXC</field>
2470
344
            <field name="category_id" ref="l10n_ca_hr_payroll.FCALC"/>
2471
345
            <field name="appears_on_payslip" eval="0"/>
2472
346
            <field name="active" eval="1"/>
2473
347
            <field name="condition_select">none</field>
2474
348
            <field name="amount_select">code</field>
2475
349
            <field name="amount_python_compute">result = EIMAXIE * EIEERATE * 0.01</field>
2476
350
        </record>
2477
351
2478
352
        <record id="rule_qc_ei_ee_pytdc" model="hr.salary.rule">
2479
353
            <field name="name">EI - Employee - Previous Year To Date Contribution (EIEEPYTDC)</field>
2480
354
            <field name="sequence" eval="141"/>
2481
355
            <field name="code">EIEEPYTDC</field>
2482
356
            <field name="category_id" ref="l10n_ca_hr_payroll.FCALC"/>
2483
357
            <field name="appears_on_payslip" eval="0"/>
2484
358
            <field name="active" eval="1"/>
2485
359
            <field name="condition_select">none</field>
2486
360
            <field name="amount_select">code</field>
2487
361
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
2488
362
date_to = payslip.date_to
2489
363
result = payslip.sum('EIEEYTDC',date_from,date_to)
2490
364
            </field>
2491
365
        </record>
2492
366
2493
367
        <record id="rule_qc_ei_ee_c" model="hr.salary.rule">
2494
368
            <field name="name">EI - Employee Contribution (EIEEC)</field>
2495
369
            <field name="sequence" eval="142"/>
2496
370
            <field name="code">EIEEC</field>
2497
371
            <field name="category_id" ref="hr_payroll.DED"/>
2498
372
            <field name="appears_on_payslip" eval="1"/>
2499
373
            <field name="active" eval="1"/>
2500
374
            <field name="condition_select">none</field>
2501
375
            <field name="amount_select">code</field>
2502
376
            <field name="amount_python_compute">if (EIEEPYTDC > EIEEMAXC):
2503
377
    result = 0
2504
378
else:
2505
379
    if (EIEEMAXC - EIEEPYTDC - (GROSS * EIEERATE * 0.01 / P) &gt;= 0):
2506
380
        result = GROSS * EIEERATE * 0.01 / P
2507
381
    else:
2508
382
        result = EIEEMAXC - EIEEPYTDC
2509
383
</field>
2510
384
        </record>
2511
385
2512
386
        <record id="rule_qc_ei_ee_ytdc" model="hr.salary.rule">
2513
387
            <field name="name">EI - Employee - Year To Date Contribution (EIEEYTDC)</field>
2514
388
            <field name="sequence" eval="143"/>
2515
389
            <field name="code">EIEEYTDC</field>
2516
390
            <field name="category_id" ref="l10n_ca_hr_payroll.FCALC"/>
2517
391
            <field name="appears_on_payslip" eval="1"/>
2518
392
            <field name="active" eval="1"/>
2519
393
            <field name="condition_select">none</field>
2520
394
            <field name="amount_select">code</field>
2521
395
            <field name="amount_python_compute">result = EIEEPYTDC + EIEEC</field>
2522
396
        </record>
2523
397
2524
398
	<!-- Insurance -  Employee - 150 -->
2525
399
2526
400
        <record id="rule_qc_ins_eec" model="hr.salary.rule">
2527
401
            <field name="name">Insurance - Employee Contribution (INSEEC)</field>
2528
402
            <field name="sequence" eval="150"/>
2529
403
            <field name="code">INSEEC</field>
2530
404
            <field name="category_id" ref="l10n_ca_hr_payroll.SDED"/>
2531
405
            <field name="appears_on_payslip" eval="1"/>
2532
406
            <field name="active" eval="1"/>
2533
407
            <field name="condition_select">none</field>
2534
408
            <field name="amount_select">code</field>
2535
409
            <field name="amount_python_compute">result = employee.eeins</field>
2536
410
        </record>
2537
411
2538
412
        <record id="rule_qc_ins_ee_ytdc" model="hr.salary.rule">
2539
413
            <field name="name">Insurance - Employee - Year To Date Contribution (INSEEYTDC)</field>
2540
414
            <field name="sequence" eval="151"/>
2541
415
            <field name="code">INSEEYTDC</field>
2542
416
            <field name="category_id" ref="l10n_ca_hr_payroll.CALC"/>
2543
417
            <field name="appears_on_payslip" eval="1"/>
2544
418
            <field name="active" eval="1"/>
2545
419
            <field name="condition_select">none</field>
2546
420
            <field name="amount_select">code</field>
2547
421
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
2548
422
date_to = payslip.date_to
2549
423
result = payslip.sum('INSEEYTDC',date_from,date_to) + INSEEC
2550
424
	    </field>
2551
425
        </record>
2552
426
2553
427
	<!-- Insurance - Employer - 155 -->
2554
428
2555
429
        <record id="rule_qc_ins_erc" model="hr.salary.rule">
2556
430
            <field name="name">Insurance - Employer Contribution (INSERC)</field>
2557
431
            <field name="sequence" eval="150"/>
2558
432
            <field name="code">INSERC</field>
2559
433
            <field name="category_id" ref="l10n_ca_hr_payroll.EMP"/>
2560
434
            <field name="appears_on_payslip" eval="0"/>
2561
435
            <field name="active" eval="1"/>
2562
436
            <field name="condition_select">none</field>
2563
437
            <field name="amount_select">code</field>
2564
438
            <field name="amount_python_compute">result = employee.erins</field>
2565
439
        </record>
2566
440
2567
441
	<!-- Quebec Income Tax - 180 -->
2568
442
2569
443
        <record id="rule_qc_qit_ti" model="hr.salary.rule">
2570
444
            <field name="name">QIT - Taxable Income (QITTI)</field>
2571
445
            <field name="sequence" eval="181"/>
2572
446
            <field name="code">QITTI</field>
2573
447
            <field name="appears_on_payslip" eval="0"/>
2574
448
            <field name="active" eval="1"/>
2575
449
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2576
450
            <field name="condition_select">none</field>
2577
451
            <field name="amount_select">code</field>
2578
452
            <field name="amount_python_compute">result = GROSS - employee.tp10153</field>
2579
453
        </record>
2580
454
2581
455
        <record id="rule_qc_qit" model="hr.salary.rule">
2582
456
            <field name="name">QIT - Quebec Income Tax (QIT)</field>
2583
457
            <field name="sequence" eval="182"/>
2584
458
            <field name="code">QIT</field>
2585
459
            <field name="appears_on_payslip" eval="1"/>
2586
460
            <field name="active" eval="1"/>
2587
461
            <field name="category_id" ref="hr_payroll.DED"/>
2588
462
            <field name="condition_select">none</field>
2589
463
            <field name="amount_select">code</field>
2590
464
            <field name="amount_python_compute">
2591
465
if QITTI &gt;= 80200:
2592
466
    res = (QITTI - 80200) * 0.24 + 40100 * 0.24 + 40100 * 0.16
2593
467
if QITTI &gt;= 40100 and QITTI &lt; 80200:
2594
468
    res = (QITTI - 40100) * 0.2 + 40100 * 0.16
2595
469
if QITTI &lt; 40100:
2596
470
    res = QITTI * 0.16
2597
471
result = res / P
2598
472
            </field>
2599
473
        </record>
2600
474
2601
475
        <record id="rule_qc_qit_ytd" model="hr.salary.rule">
2602
476
            <field name="name">QIT - Year To Date (QITYTD)</field>
2603
477
            <field name="sequence" eval="183"/>
2604
478
            <field name="code">QITYTD</field>
2605
479
            <field name="category_id" ref="l10n_ca_hr_payroll.PCALC"/>
2606
480
            <field name="appears_on_payslip" eval="1"/>
2607
481
            <field name="active" eval="1"/>
2608
482
            <field name="condition_select">none</field>
2609
483
            <field name="amount_select">code</field>
2610
484
            <field name="amount_python_compute">date_from = payslip.date_to.split('-')[0] + '-01-01'
2611
485
date_to = payslip.date_to
2612
486
result = payslip.sum('QITYTD',date_from,date_to) + QIT
2613
487
	    </field>
2614
488
        </record>
2615
489
2616
490
        <!-- Salary Structure -->
2617
491
2618
492
         <record id="hr_structure_qc" model="hr.payroll.structure">
2619
493
            <field name="code">QC</field>
2620
494
            <field name="name">Quebec Base</field>
2621
495
            <field name="rule_ids"
2622
496
		eval="[(6, 0, [
2623
497
		ref('rule_qc_qpip_maxie'),
2624
498
		ref('rule_qc_qpip_ee_rate'),
2625
499
		ref('rule_qc_qpip_ee_maxc'),
2626
500
		ref('rule_qc_qpip_ee_pytdc'),
2627
501
		ref('rule_qc_qpip_ee_c'),
2628
502
		ref('rule_qc_qpip_ee_ytdc'),
2629
503
		ref('rule_qc_qpip_er_rate'),
2630
504
		ref('rule_qc_qpip_er_maxc'),
2631
505
		ref('rule_qc_qpip_er_pytdc'),
2632
506
		ref('rule_qc_qpip_er_c'),
2633
507
		ref('rule_qc_qpip_er_ytdc'),
2634
508
		ref('rule_qc_qpp_maxie'),
2635
509
		ref('rule_qc_qpp_ee_rate'),
2636
510
		ref('rule_qc_qpp_ee_maxc'),
2637
511
		ref('rule_qc_qpp_ee_pytdc'),
2638
512
		ref('rule_qc_qpp_ee_c'),
2639
513
		ref('rule_qc_qpp_ee_ytdc'),
2640
514
		ref('rule_qc_qpp_er_rate'),
2641
515
		ref('rule_qc_qpp_er_maxc'),
2642
516
		ref('rule_qc_qpp_er_pytdc'),
2643
517
		ref('rule_qc_qpp_er_c'),
2644
518
		ref('rule_qc_qpp_er_ytdc'),
2645
519
		ref('rule_qc_ins_eec'),
2646
520
		ref('rule_qc_ins_erc'),
2647
521
		ref('rule_qc_ei_ee_rate'),
2648
522
		ref('rule_qc_ei_ee_maxc'),
2649
523
		ref('rule_qc_ei_ee_pytdc'),
2650
524
		ref('rule_qc_ei_ee_c'),
2651
525
		ref('rule_qc_ei_ee_ytdc'),
2652
526
		ref('rule_qc_qit_ti'),
2653
527
		ref('rule_qc_qit'),
2654
528
		ref('rule_qc_qit_ytd')
2655
529
		])]"/>
2656
530
            <field name="parent_id" ref="l10n_ca_hr_payroll.hr_structure_ca_base"/>
2657
531
        </record>
2658
532
2659
533
    </data>
2660
534
</openerp>
2661
0
535
2662
=== added file 'l10n_ca_qc_hr_payroll/l10n_ca_qc_hr_payroll_view.xml'
2663
--- l10n_ca_qc_hr_payroll/l10n_ca_qc_hr_payroll_view.xml	1970-01-01 00:00:00 +0000
2664
+++ l10n_ca_qc_hr_payroll/l10n_ca_qc_hr_payroll_view.xml	2012-12-21 16:45:28 +0000
2665
@@ -0,0 +1,18 @@
2666
1
<?xml version="1.0" encoding="utf-8"?>
2667
2
<openerp>
2668
3
  <data>
2669
4
2670
5
      <record id="hr_employee_view_form_inherit" model="ir.ui.view">
2671
6
          <field name="name">hr.employee.view.form.inherit</field>
2672
7
          <field name="model">hr.employee</field>
2673
8
          <field name="type">form</field>
2674
9
          <field name="inherit_id" ref="l10n_ca_hr_payroll.hr_employee_view_form_inherit"/>
2675
10
          <field name="arch" type="xml">
2676
11
              <field name="td1" position="after">
2677
12
                  <field name="tp10153"/>
2678
13
              </field>
2679
14
          </field>
2680
15
      </record>
2681
16
  
2682
17
  </data>
2683
18
</openerp>
2684
0
19
2685
=== added directory 'l10n_ca_qc_hr_payroll/static'
2686
=== added directory 'l10n_ca_qc_hr_payroll/static/src'
2687
=== added directory 'l10n_ca_qc_hr_payroll/static/src/img'
2688
=== added file 'l10n_ca_qc_hr_payroll/static/src/img/icon.png'
2689
1
Binary files l10n_ca_qc_hr_payroll/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and l10n_ca_qc_hr_payroll/static/src/img/icon.png	2012-12-21 16:45:28 +0000 differ
20
Binary files l10n_ca_qc_hr_payroll/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and l10n_ca_qc_hr_payroll/static/src/img/icon.png	2012-12-21 16:45:28 +0000 differ
2690
=== added directory 'l10n_ca_qc_hr_payroll_account'
2691
=== added file 'l10n_ca_qc_hr_payroll_account/__init__.py'
2692
--- l10n_ca_qc_hr_payroll_account/__init__.py	1970-01-01 00:00:00 +0000
2693
+++ l10n_ca_qc_hr_payroll_account/__init__.py	2012-12-21 16:45:28 +0000
2694
@@ -0,0 +1,22 @@
2695
1
#-*- coding:utf-8 -*-
2696
2
##############################################################################
2697
3
#
2698
4
#    Copyright (C) 2012 OpenERP Canada. All Rights Reserved.
2699
5
#
2700
6
#    This program is free software: you can redistribute it and/or modify
2701
7
#    it under the terms of the GNU Affero General Public License as published
2702
8
#    by
2703
9
#    the Free Software Foundation, either version 3 of the License, or
2704
10
#    (at your option) any later version.
2705
11
#
2706
12
#    This program is distributed in the hope that it will be useful,
2707
13
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
2708
14
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
2709
15
#    GNU Affero General Public License for more details.
2710
16
#
2711
17
#    You should have received a copy of the GNU Affero General Public License
2712
18
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
2713
19
#
2714
20
##############################################################################
2715
21
2716
22
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
2717
0
23
2718
=== added file 'l10n_ca_qc_hr_payroll_account/__openerp__.py'
2719
--- l10n_ca_qc_hr_payroll_account/__openerp__.py	1970-01-01 00:00:00 +0000
2720
+++ l10n_ca_qc_hr_payroll_account/__openerp__.py	2012-12-21 16:45:28 +0000
2721
@@ -0,0 +1,56 @@
2722
1
#-*- coding:utf-8 -*-
2723
2
##############################################################################
2724
3
#
2725
4
#    Copyright (C) 2012 Savoir-faire Linux. All Rights Reserved.
2726
5
#
2727
6
#    This program is free software: you can redistribute it and/or modify
2728
7
#    it under the terms of the GNU Affero General Public License as published by
2729
8
#    the Free Software Foundation, either version 3 of the License, or
2730
9
#    (at your option) any later version.
2731
10
#
2732
11
#    This program is distributed in the hope that it will be useful,
2733
12
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
2734
13
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
2735
14
#    GNU Affero General Public License for more details.
2736
15
#
2737
16
#    You should have received a copy of the GNU Affero General Public License
2738
17
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
2739
18
#
2740
19
##############################################################################
2741
20
{
2742
21
    'name': 'Canada - Quebec - Payroll Accounting',
2743
22
    'category': 'Localization',
2744
23
    'version': '0.1',
2745
24
    'license': 'AGPL-3',
2746
25
    'category': 'Generic Modules/Human Resources',
2747
26
    'description': """
2748
27
Quebec Payroll Accounting 
2749
28
=========================
2750
29
2751
30
This module:
2752
31
 * creates financial accounts for payroll
2753
32
 * updates salary rules with accounting information
2754
33
2755
34
    !!! Warning !!!
2756
35
2757
36
Make sure to install AND CONFIGURE the canadian chart of accounts module (l10n_ca)
2758
37
before installing this module. Chart template needs to be selected to populate
2759
38
the account.account table and allow you to link salary rules with the financial 
2760
39
account.
2761
40
    """,
2762
41
    'author':'Savoir-faire Linux',
2763
42
    'website':'http:/www.savoirfairelinux.com',
2764
43
    'depends': [
2765
44
        'l10n_ca_qc_hr_payroll',
2766
45
        'l10n_ca_hr_payroll_account',
2767
46
    ],
2768
47
    'data': [
2769
48
        'l10n_ca_qc_hr_payroll_account_data.xml',
2770
49
    ],
2771
50
    'test': [],
2772
51
    'demo': [],
2773
52
    'installable': True,
2774
53
    'active': False,
2775
54
}
2776
55
2777
56
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
2778
0
57
2779
=== added file 'l10n_ca_qc_hr_payroll_account/l10n_ca_qc_hr_payroll_account_data.xml'
2780
--- l10n_ca_qc_hr_payroll_account/l10n_ca_qc_hr_payroll_account_data.xml	1970-01-01 00:00:00 +0000
2781
+++ l10n_ca_qc_hr_payroll_account/l10n_ca_qc_hr_payroll_account_data.xml	2012-12-21 16:45:28 +0000
2782
@@ -0,0 +1,44 @@
2783
1
<?xml version="1.0" encoding="utf-8"?>
2784
2
<openerp>
2785
3
    <data noupdate="1">
2786
4
2787
5
	<!-- Quebec Parental Insurance Plan -->
2788
6
2789
7
	<record id="l10n_ca_qc_hr_payroll.rule_qc_qpip_ee_c" model="hr.salary.rule">
2790
8
	    <field name="account_debit" model='account.account' search="[('code','like','51206')]"/>
2791
9
	    <field name="account_credit" model='account.account' search="[('code','like','214231')]"/>
2792
10
	</record>
2793
11
2794
12
	<record id="l10n_ca_qc_hr_payroll.rule_qc_qpip_er_c" model="hr.salary.rule">
2795
13
	    <field name="account_debit" model='account.account' search="[('code','like','51206')]"/>
2796
14
	    <field name="account_credit" model='account.account' search="[('code','like','214232')]"/>
2797
15
	</record>
2798
16
2799
17
	<!-- Quebec Pension Plan -->
2800
18
2801
19
	<record id="l10n_ca_qc_hr_payroll.rule_qc_qpp_ee_c" model="hr.salary.rule">
2802
20
	    <field name="account_debit" model='account.account' search="[('code','like','51205')]"/>
2803
21
	    <field name="account_credit" model='account.account' search="[('code','like','214221')]"/>
2804
22
	</record>
2805
23
2806
24
	<record id="l10n_ca_qc_hr_payroll.rule_qc_qpp_er_c" model="hr.salary.rule">
2807
25
	    <field name="account_debit" model='account.account' search="[('code','like','51205')]"/>
2808
26
	    <field name="account_credit" model='account.account' search="[('code','like','214222')]"/>
2809
27
	</record>
2810
28
2811
29
	<!-- Employment Insurance -->
2812
30
2813
31
	<record id="l10n_ca_qc_hr_payroll.rule_qc_ei_ee_c" model="hr.salary.rule">
2814
32
	    <field name="account_debit" model='account.account' search="[('code','like','51203')]"/>
2815
33
	    <field name="account_credit" model='account.account' search="[('code','like','214111')]"/>
2816
34
	</record>
2817
35
2818
36
	<!-- Quebec Tax Income -->
2819
37
2820
38
	<record id="l10n_ca_qc_hr_payroll.rule_qc_qit" model="hr.salary.rule">
2821
39
	    <field name="account_debit" model='account.account' search="[('code','like','51210')]"/>
2822
40
	    <field name="account_credit" model='account.account' search="[('code','like','21426')]"/>
2823
41
	</record>
2824
42
2825
43
    </data>
2826
44
</openerp>
2827
0
45
2828
=== added directory 'l10n_ca_qc_hr_payroll_account/static'
2829
=== added directory 'l10n_ca_qc_hr_payroll_account/static/src'
2830
=== added directory 'l10n_ca_qc_hr_payroll_account/static/src/img'
2831
=== added file 'l10n_ca_qc_hr_payroll_account/static/src/img/icon.png'
2832
1
Binary files l10n_ca_qc_hr_payroll_account/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and l10n_ca_qc_hr_payroll_account/static/src/img/icon.png	2012-12-21 16:45:28 +0000 differ
46
Binary files l10n_ca_qc_hr_payroll_account/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and l10n_ca_qc_hr_payroll_account/static/src/img/icon.png	2012-12-21 16:45:28 +0000 differ
2833
=== added directory 'l10n_ca_toponyms/static'
2834
=== added directory 'l10n_ca_toponyms/static/src'
2835
=== added directory 'l10n_ca_toponyms/static/src/img'
2836
=== added file 'l10n_ca_toponyms/static/src/img/icon.png'
2837
2
Binary files l10n_ca_toponyms/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and l10n_ca_toponyms/static/src/img/icon.png	2012-12-21 16:45:28 +0000 differ
47
Binary files l10n_ca_toponyms/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and l10n_ca_toponyms/static/src/img/icon.png	2012-12-21 16:45:28 +0000 differ
Status:	Merged
Merged at revision:	5
Proposed branch:	lp:~openerp-canada/openerp-canada/6.1-l10n_ca_hr_payroll
Merge into:	lp:openerp-canada/6.1
Diff against target:	2837 lines (+2682/-0) 23 files modified l10n_ca_hr_payroll/AUTHORS.txt (+4/-0) l10n_ca_hr_payroll/__init__.py (+24/-0) l10n_ca_hr_payroll/__openerp__.py (+50/-0) l10n_ca_hr_payroll/l10n_ca_hr_payroll.py (+260/-0) l10n_ca_hr_payroll/l10n_ca_hr_payroll_data.xml (+282/-0) l10n_ca_hr_payroll/l10n_ca_hr_payroll_view.xml (+210/-0) l10n_ca_hr_payroll_account/AUTHORS.txt (+3/-0) l10n_ca_hr_payroll_account/__init__.py (+22/-0) l10n_ca_hr_payroll_account/__openerp__.py (+51/-0) l10n_ca_hr_payroll_account/l10n_ca_hr_payroll_account_data.xml (+31/-0) l10n_ca_on_hr_payroll/__init__.py (+24/-0) l10n_ca_on_hr_payroll/__openerp__.py (+52/-0) l10n_ca_on_hr_payroll/l10n_ca_on_hr_payroll.py (+141/-0) l10n_ca_on_hr_payroll/l10n_ca_on_hr_payroll_data.xml (+597/-0) l10n_ca_on_hr_payroll/l10n_ca_on_hr_payroll_view.xml (+149/-0) l10n_ca_qc_hr_payroll/__init__.py (+24/-0) l10n_ca_qc_hr_payroll/__openerp__.py (+46/-0) l10n_ca_qc_hr_payroll/l10n_ca_qc_hr_payroll.py (+38/-0) l10n_ca_qc_hr_payroll/l10n_ca_qc_hr_payroll_data.xml (+534/-0) l10n_ca_qc_hr_payroll/l10n_ca_qc_hr_payroll_view.xml (+18/-0) l10n_ca_qc_hr_payroll_account/__init__.py (+22/-0) l10n_ca_qc_hr_payroll_account/__openerp__.py (+56/-0) l10n_ca_qc_hr_payroll_account/l10n_ca_qc_hr_payroll_account_data.xml (+44/-0)
To merge this branch:	bzr merge lp:~openerp-canada/openerp-canada/6.1-l10n_ca_hr_payroll
Related bugs:	Link a bug report
Related blueprints:	Payroll rules for Quebec (Low)
Reviewer	Review Type	Date Requested	Status
Maxime Chambreuil (http://www.savoirfairelinux.com)			Approve on 2013-01-28
Review via email: mp+141101@code.launchpad.net