addons/hr_payroll_account/hr_payroll_account.py

   1 #-*- coding:utf-8 -*-
   2 ##############################################################################
   3 #
   4 #    OpenERP, Open Source Management Solution
   5 #    Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>). All Rights Reserved
   6 #    d$
   7 #
   8 #    This program is free software: you can redistribute it and/or modify
   9 #    it under the terms of the GNU General Public License as published by
  10 #    the Free Software Foundation, either version 3 of the License, or
  11 #    (at your option) any later version.
  12 #
  13 #    This program is distributed in the hope that it will be useful,
  14 #    but WITHOUT ANY WARRANTY; without even the implied warranty of
  15 #    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  16 #    GNU General Public License for more details.
  17 #
  18 #    You should have received a copy of the GNU General Public License
  19 #    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  20 #
  21 ##############################################################################
  22 import time
  23 import netsvc
  24 from datetime import date, datetime, timedelta
  25
  26 from osv import fields, osv
  27 from tools import config
  28 from tools.translate import _
  29
  30 def prev_bounds(cdate=False):
  31     when = date.fromtimestamp(time.mktime(time.strptime(cdate,"%Y-%m-%d")))
  32     this_first = date(when.year, when.month, 1)
  33     month = when.month + 1
  34     year = when.year
  35     if month > 12:
  36         month = 1
  37         year += 1
  38     next_month = date(year, month, 1)
  39     prev_end = next_month - timedelta(days=1)
  40     return this_first, prev_end
  41
  42 class hr_payroll_structure(osv.osv):
  43     _inherit = 'hr.payroll.structure'
  44     _description = 'Salary Structure'
  45
  46     _columns = {
  47         'account_id':fields.many2one('account.analytic.account', 'Analytic Account'),
  48     }
  49 hr_payroll_structure()
  50
  51 class hr_employee(osv.osv):
  52     '''
  53     Employee
  54     '''
  55     _inherit = 'hr.employee'
  56     _description = 'Employee'
  57
  58     _columns = {
  59         'property_bank_account': fields.property(
  60             'account.account',
  61             type='many2one',
  62             relation='account.account',
  63             string="Bank Account",
  64             method=True,
  65             domain="[('type', '=', 'liquidity')]",
  66             view_load=True,
  67             help="Select Bank Account from where Salary Expanse will be Paid"),
  68         'salary_account':fields.property(
  69             'account.account',
  70             type='many2one',
  71             relation='account.account',
  72             string="Salary Account",
  73             method=True,
  74             domain="[('type', '=', 'other')]",
  75             view_load=True,
  76             help="Expanse account when Salary Expanse will be recorded"),
  77         'employee_account':fields.property(
  78             'account.account',
  79             type='many2one',
  80             relation='account.account',
  81             string="Employee Account",
  82             method=True,
  83             domain="[('type', '=', 'other')]",
  84             view_load=True,
  85             help="Employee Payable Account"),
  86         'analytic_account':fields.property(
  87             'account.analytic.account',
  88             type='many2one',
  89             relation='account.analytic.account',
  90             string="Analytic Account",
  91             method=True,
  92             view_load=True,
  93             help="Analytic Account for Salary Analysis"),
  94     }
  95 hr_employee()
  96
  97 class payroll_register(osv.osv):
  98     _inherit = 'hr.payroll.register'
  99     _description = 'Payroll Register'
 100
 101     _columns = {
 102         'journal_id': fields.many2one('account.journal', 'Expanse Journal'),
 103         'bank_journal_id': fields.many2one('account.journal', 'Bank Journal'),
 104         'period_id': fields.many2one('account.period', 'Force Period', domain=[('state','<>','done')], help="Keep empty to use the period of the validation(Payslip) date."),
 105     }
 106
 107     def compute_sheet(self, cr, uid, ids, context={}):
 108         emp_pool = self.pool.get('hr.employee')
 109         slip_pool = self.pool.get('hr.payslip')
 110         func_pool = self.pool.get('hr.payroll.structure')
 111         slip_line_pool = self.pool.get('hr.payslip.line')
 112         wf_service = netsvc.LocalService("workflow")
 113         vals = self.browse(cr, uid, ids)[0]
 114         emp_ids = emp_pool.search(cr, uid, [])
 115
 116         for emp in emp_pool.browse(cr, uid, emp_ids):
 117             old_slips = slip_pool.search(cr, uid, [('employee_id','=', emp.id), ('date','=',vals.date)])
 118             if old_slips:
 119                 slip_pool.write(cr, uid, old_slips, {'register_id':ids[0]})
 120                 for sid in old_slips:
 121                     wf_service.trg_validate(uid, 'hr.payslip', sid, 'compute_sheet', cr)
 122             else:
 123                 res = {
 124                     'employee_id':emp.id,
 125                     'basic':0.0,
 126                     'register_id':ids[0],
 127                     'name':vals.name,
 128                     'date':vals.date,
 129                     'journal_id':vals.journal_id.id,
 130                     'bank_journal_id':vals.bank_journal_id.id
 131                 }
 132                 slip_id = slip_pool.create(cr, uid, res)
 133                 wf_service.trg_validate(uid, 'hr.payslip', slip_id, 'compute_sheet', cr)
 134
 135         number = self.pool.get('ir.sequence').get(cr, uid, 'salary.register')
 136         self.write(cr, uid, ids, {'state':'draft', 'number':number})
 137         return True
 138
 139 payroll_register()
 140
 141 class payroll_advice(osv.osv):
 142     _inherit = 'hr.payroll.advice'
 143     _description = 'Bank Advice Note'
 144
 145     _columns = {
 146         'account_id': fields.many2one('account.account', 'Account'),
 147     }
 148 payroll_advice()
 149
 150 class contrib_register(osv.osv):
 151     _inherit = 'hr.contibution.register'
 152     _description = 'Contribution Register'
 153
 154     def _total_contrib(self, cr, uid, ids, field_names, arg, context={}):
 155         line_pool = self.pool.get('hr.contibution.register.line')
 156         period_id = self.pool.get('account.period').search(cr,uid,[('date_start','<=',time.strftime('%Y-%m-%d')),('date_stop','>=',time.strftime('%Y-%m-%d'))])[0]
 157         fiscalyear_id = self.pool.get('account.period').browse(cr, uid, period_id).fiscalyear_id
 158         res = {}
 159         for cur in self.browse(cr, uid, ids):
 160             current = line_pool.search(cr, uid, [('period_id','=',period_id),('register_id','=',cur.id)])
 161             years = line_pool.search(cr, uid, [('period_id.fiscalyear_id','=',fiscalyear_id.id), ('register_id','=',cur.id)])
 162
 163             e_month = 0.0
 164             c_month = 0.0
 165             for i in line_pool.browse(cr, uid, current):
 166                 e_month += i.emp_deduction
 167                 c_month += i.comp_deduction
 168
 169             e_year = 0.0
 170             c_year = 0.0
 171             for j in line_pool.browse(cr, uid, years):
 172                 e_year += i.emp_deduction
 173                 c_year += i.comp_deduction
 174
 175             res[cur.id]={
 176                 'monthly_total_by_emp':e_month,
 177                 'monthly_total_by_comp':c_month,
 178                 'yearly_total_by_emp':e_year,
 179                 'yearly_total_by_comp':c_year
 180             }
 181         return res
 182
 183     _columns = {
 184         'account_id': fields.many2one('account.account', 'Account'),
 185         'analytic_account_id':fields.many2one('account.analytic.account', 'Analytic Account'),
 186         'yearly_total_by_emp': fields.function(_total_contrib, method=True, multi='dc', store=True, string='Total By Employee', digits=(16, 4)),
 187         'yearly_total_by_comp': fields.function(_total_contrib, method=True, multi='dc', store=True,  string='Total By Company', digits=(16, 4)),
 188     }
 189 contrib_register()
 190
 191 class contrib_register_line(osv.osv):
 192     _inherit = 'hr.contibution.register.line'
 193     _description = 'Contribution Register Line'
 194
 195     _columns = {
 196         'period_id': fields.many2one('account.period', 'Period'),
 197     }
 198 contrib_register_line()
 199
 200 class hr_holidays_status(osv.osv):
 201     _inherit = 'hr.holidays.status'
 202     _columns = {
 203         'account_id': fields.many2one('account.account', 'Account'),
 204         'analytic_account_id':fields.many2one('account.analytic.account', 'Analytic Account'),
 205     }
 206 hr_holidays_status()
 207
 208 class hr_payslip(osv.osv):
 209     '''
 210     Pay Slip
 211     '''
 212     _inherit = 'hr.payslip'
 213     _description = 'Pay Slip'
 214
 215     _columns = {
 216         'journal_id': fields.many2one('account.journal', 'Expanse Journal'),
 217         'bank_journal_id': fields.many2one('account.journal', 'Bank Journal'),
 218         'move_ids':fields.one2many('hr.payslip.account.move', 'slip_id', 'Accounting vouchers'),
 219         'move_line_ids':fields.many2many('account.move.line', 'payslip_lines_rel', 'slip_id', 'line_id', 'Accounting Lines', readonly=True),
 220         'move_payment_ids':fields.many2many('account.move.line', 'payslip_payment_rel', 'slip_id', 'payment_id', 'Payment Lines', readonly=True),
 221         'period_id': fields.many2one('account.period', 'Force Period', domain=[('state','<>','done')], help="Keep empty to use the period of the validation(Payslip) date."),
 222     }
 223
 224     def create_voucher(self, cr, uid, ids, name, voucher, sequence=5):
 225         slip_move = self.pool.get('hr.payslip.account.move')
 226         for slip in ids:
 227             res = {
 228                 'slip_id':slip,
 229                 'move_id':voucher,
 230                 'sequence':sequence,
 231                 'name':name
 232             }
 233             slip_move.create(cr, uid, res)
 234
 235     def cancel_sheet(self, cr, uid, ids, context=None):
 236         move_pool = self.pool.get('account.move')
 237         slip_move = self.pool.get('hr.payslip.account.move')
 238         if context is None:
 239             context = {}
 240         move_ids = []
 241         for slip in self.browse(cr, uid, ids, context=context):
 242             for line in slip.move_ids:
 243                 move_ids.append(line.id)
 244                 if line.move_id:
 245                     if line.move_id.state == 'posted':
 246                         move_pool.button_cancel(cr, uid [line.move_id.id], context)
 247                     move_pool.unlink(cr, uid, [line.move_id.id], context=context)
 248
 249         slip_move.unlink(cr, uid, move_ids, context=context)
 250         self.write(cr, uid, ids, {'state':'cancel'}, context=context)
 251         return True
 252
 253     def process_sheet(self, cr, uid, ids, context=None):
 254         move_pool = self.pool.get('account.move')
 255         movel_pool = self.pool.get('account.move.line')
 256         invoice_pool = self.pool.get('account.invoice')
 257         fiscalyear_pool = self.pool.get('account.fiscalyear')
 258         period_pool = self.pool.get('account.period')
 259         if context is None:
 260             context = {}
 261
 262         for slip in self.browse(cr, uid, ids, context=context):
 263             line_ids = []
 264             partner = False
 265             partner_id = False
 266             exp_ids = []
 267
 268             partner = slip.employee_id.bank_account_id.partner_id
 269             partner_id = partner.id
 270
 271             fiscal_year_ids = fiscalyear_pool.search(cr, uid, [], context=context)
 272             if not fiscal_year_ids:
 273                 raise osv.except_osv(_('Warning !'), _('Please define fiscal year for perticular contract'))
 274             fiscal_year_objs = fiscalyear_pool.read(cr, uid, fiscal_year_ids, ['date_start','date_stop'], context=context)
 275             year_exist = False
 276             for fiscal_year in fiscal_year_objs:
 277                 if ((fiscal_year['date_start'] <= slip.date) and (fiscal_year['date_stop'] >= slip.date)):
 278                     year_exist = True
 279             if not year_exist:
 280                 raise osv.except_osv(_('Warning !'), _('Fiscal Year is not defined for slip date %s'%slip.date))
 281             search_periods = period_pool.search(cr, uid, [('date_start','<=',slip.date),('date_stop','>=',slip.date)], context=context)
 282             if not search_periods:
 283                 raise osv.except_osv(_('Warning !'), _('Period is not defined for slip date %s'%slip.date))
 284             period_id = search_periods[0]
 285             name = 'Payment of Salary to %s' % (slip.employee_id.name)
 286             move = {
 287                 'journal_id': slip.bank_journal_id.id,
 288                 'period_id': period_id,
 289                 'date': slip.date,
 290                 'type':'bank_pay_voucher',
 291                 'ref':slip.number,
 292                 'narration': name
 293             }
 294             move_id = move_pool.create(cr, uid, move, context=context)
 295             self.create_voucher(cr, uid, [slip.id], name, move_id)
 296
 297             name = "To %s account" % (slip.employee_id.name)
 298             ded_rec = {
 299                 'move_id': move_id,
 300                 'name': name,
 301                 'date': slip.date,
 302                 'account_id': slip.employee_id.property_bank_account.id,
 303                 'debit': 0.0,
 304                 'credit': slip.total_pay,
 305                 'journal_id': slip.journal_id.id,
 306                 'period_id': period_id,
 307                 'ref': slip.number
 308             }
 309             line_ids += [movel_pool.create(cr, uid, ded_rec, context=context)]
 310             name = "By %s account" % (slip.employee_id.property_bank_account.name)
 311             cre_rec = {
 312                 'move_id': move_id,
 313                 'name': name,
 314                 'partner_id': partner_id,
 315                 'date': slip.date,
 316                 'account_id': partner.property_account_payable.id,
 317                 'debit': slip.total_pay,
 318                 'credit': 0.0,
 319                 'journal_id': slip.journal_id.id,
 320                 'period_id': period_id,
 321                 'ref': slip.number
 322             }
 323             line_ids += [movel_pool.create(cr, uid, cre_rec, context=context)]
 324
 325             other_pay = slip.other_pay
 326             #Process all Reambuse Entries
 327             for line in slip.line_ids:
 328                 if line.type == 'otherpay' and line.expanse_id.invoice_id:
 329                     if not line.expanse_id.invoice_id.move_id:
 330                         raise osv.except_osv(_('Warning !'), _('Please Confirm all Expense Invoice appear for Reimbursement'))
 331                     invids = [line.expanse_id.invoice_id.id]
 332                     amount = line.total
 333                     acc_id = slip.bank_journal_id.default_credit_account_id and slip.bank_journal_id.default_credit_account_id.id
 334                     period_id = slip.period_id.id
 335                     journal_id = slip.bank_journal_id.id
 336                     name = '[%s]-%s' % (slip.number, line.name)
 337                     invoice_pool.pay_and_reconcile(cr, uid, invids, amount, acc_id, period_id, journal_id, False, period_id, False, context, name)
 338                     other_pay -= amount
 339                     #TODO: link this account entries to the Payment Lines also Expanse Entries to Account Lines
 340                     l_ids = movel_pool.search(cr, uid, [('name','=',name)], context=context)
 341                     line_ids += l_ids
 342
 343                     l_ids = movel_pool.search(cr, uid, [('invoice','=',line.expanse_id.invoice_id.id)], context=context)
 344                     exp_ids += l_ids
 345
 346             #Process for Other payment if any
 347             other_move_id = False
 348             if slip.other_pay > 0:
 349                 narration = 'Payment of Other Payeble amounts to %s' % (slip.employee_id.name)
 350                 move = {
 351                     'journal_id': slip.bank_journal_id.id,
 352                     'period_id': period_id,
 353                     'date': slip.date,
 354                     'type':'bank_pay_voucher',
 355                     'ref':slip.number,
 356                     'narration': narration
 357                 }
 358                 other_move_id = move_pool.create(cr, uid, move, context=context)
 359                 self.create_voucher(cr, uid, [slip.id], narration, move_id)
 360
 361                 name = "To %s account" % (slip.employee_id.name)
 362                 ded_rec = {
 363                     'move_id':other_move_id,
 364                     'name':name,
 365                     'date':slip.date,
 366                     'account_id':slip.employee_id.property_bank_account.id,
 367                     'debit': 0.0,
 368                     'credit': other_pay,
 369                     'journal_id':slip.journal_id.id,
 370                     'period_id':period_id,
 371                     'ref':slip.number
 372                 }
 373                 line_ids += [movel_pool.create(cr, uid, ded_rec, context=context)]
 374                 name = "By %s account" % (slip.employee_id.property_bank_account.name)
 375                 cre_rec = {
 376                     'move_id':other_move_id,
 377                     'name':name,
 378                     'partner_id':partner_id,
 379                     'date':slip.date,
 380                     'account_id':partner.property_account_payable.id,
 381                     'debit': other_pay,
 382                     'credit':0.0,
 383                     'journal_id':slip.journal_id.id,
 384                     'period_id':period_id,
 385                     'ref':slip.number
 386                 }
 387                 line_ids += [movel_pool.create(cr, uid, cre_rec, context=context)]
 388
 389             rec = {
 390                 'state':'done',
 391                 'move_payment_ids':[(6, 0, line_ids)],
 392                 'paid':True
 393             }
 394             self.write(cr, uid, [slip.id], rec, context=context)
 395             for exp_id in exp_ids:
 396                 self.write(cr, uid, [slip.id], {'move_line_ids':[(4, exp_id)]}, context=context)
 397
 398         return True
 399
 400     def account_check_sheet(self, cr, uid, ids, context=None):
 401         if context is None:
 402             context = {}
 403         self.write(cr, uid, ids, {'state':'accont_check'}, context=context)
 404         return True
 405
 406     def hr_check_sheet(self, cr, uid, ids, context=None):
 407         if context is None:
 408             context = {}
 409         self.write(cr, uid, ids, {'state':'hr_check'}, context=context)
 410         return True
 411
 412     def verify_sheet(self, cr, uid, ids, context=None):
 413         move_pool = self.pool.get('account.move')
 414         movel_pool = self.pool.get('account.move.line')
 415         exp_pool = self.pool.get('hr.expense.expense')
 416         fiscalyear_pool = self.pool.get('account.fiscalyear')
 417         period_pool = self.pool.get('account.period')
 418         property_pool = self.pool.get('ir.property')
 419         payslip_pool = self.pool.get('hr.payslip.line')
 420
 421         if context is None:
 422             context = {}
 423         for slip in self.browse(cr, uid, ids, context=context):
 424             total_deduct = 0.0
 425
 426             line_ids = []
 427             partner = False
 428             partner_id = False
 429
 430             if not slip.employee_id.bank_account_id:
 431                 raise osv.except_osv(_('Integrity Error !'), _('Please defined bank account for %s !' % (slip.employee_id.name)))
 432
 433             if not slip.employee_id.bank_account_id.partner_id:
 434                 raise osv.except_osv(_('Integrity Error !'), _('Please defined partner in bank account for %s !' % (slip.employee_id.name)))
 435
 436             partner = slip.employee_id.bank_account_id.partner_id
 437             partner_id = slip.employee_id.bank_account_id.partner_id.id
 438
 439             period_id = False
 440
 441             if slip.period_id:
 442                 period_id = slip.period_id.id
 443             else:
 444                 fiscal_year_ids = fiscalyear_pool.search(cr, uid, [], context=context)
 445                 if not fiscal_year_ids:
 446                     raise osv.except_osv(_('Warning !'), _('Please define fiscal year for perticular contract'))
 447                 fiscal_year_objs = fiscalyear_pool.read(cr, uid, fiscal_year_ids, ['date_start','date_stop'], context=context)
 448                 year_exist = False
 449                 for fiscal_year in fiscal_year_objs:
 450                     if ((fiscal_year['date_start'] <= slip.date) and (fiscal_year['date_stop'] >= slip.date)):
 451                         year_exist = True
 452                 if not year_exist:
 453                     raise osv.except_osv(_('Warning !'), _('Fiscal Year is not defined for slip date %s'%slip.date))
 454                 search_periods = period_pool.search(cr,uid,[('date_start','<=',slip.date),('date_stop','>=',slip.date)], context=context)
 455                 if not search_periods:
 456                     raise osv.except_osv(_('Warning !'), _('Period is not defined for slip date %s'%slip.date))
 457                 period_id = search_periods[0]
 458
 459             move = {
 460                 'journal_id': slip.journal_id.id,
 461                 'period_id': period_id,
 462                 'date': slip.date,
 463                 'ref':slip.number,
 464                 'narration': slip.name
 465             }
 466             move_id = move_pool.create(cr, uid, move, context=context)
 467             self.create_voucher(cr, uid, [slip.id], slip.name, move_id)
 468
 469             line = {
 470                 'move_id':move_id,
 471                 'name': "By Basic Salary / " + slip.employee_id.name,
 472                 'date': slip.date,
 473                 'account_id': slip.employee_id.salary_account.id,
 474                 'debit': slip.basic,
 475                 'credit': 0.0,
 476                 'quantity':slip.working_days,
 477                 'journal_id': slip.journal_id.id,
 478                 'period_id': period_id,
 479                 'analytic_account_id': False,
 480                 'ref':slip.number
 481             }
 482
 483             #Setting Analysis Account for Basic Salary
 484             if slip.employee_id.analytic_account:
 485                 line['analytic_account_id'] = slip.employee_id.analytic_account.id
 486
 487             move_line_id = movel_pool.create(cr, uid, line, context=context)
 488             line_ids += [move_line_id]
 489
 490             line = {
 491                 'move_id':move_id,
 492                 'name': "To Basic Paysble Salary / " + slip.employee_id.name,
 493                 'partner_id': partner_id,
 494                 'date': slip.date,
 495                 'account_id': slip.employee_id.employee_account.id,
 496                 'debit': 0.0,
 497                 'quantity':slip.working_days,
 498                 'credit': slip.basic,
 499                 'journal_id': slip.journal_id.id,
 500                 'period_id': period_id,
 501                 'ref':slip.number
 502             }
 503             line_ids += [movel_pool.create(cr, uid, line, context=context)]
 504
 505             for line in slip.line_ids:
 506                 name = "[%s] - %s / %s" % (line.code, line.name, slip.employee_id.name)
 507                 amount = line.total
 508
 509                 if line.type == 'leaves':
 510                     continue
 511
 512                 rec = {
 513                     'move_id': move_id,
 514                     'name': name,
 515                     'date': slip.date,
 516                     'account_id': line.account_id.id,
 517                     'debit': 0.0,
 518                     'credit': 0.0,
 519                     'journal_id': slip.journal_id.id,
 520                     'period_id': period_id,
 521                     'analytic_account_id': False,
 522                     'ref': slip.number,
 523                     'quantity': 1
 524                 }
 525
 526                 #Setting Analysis Account for Salary Slip Lines
 527                 if line.analytic_account_id:
 528                     rec['analytic_account_id'] = line.analytic_account_id.id
 529                 else:
 530                     rec['analytic_account_id'] = slip.deg_id.account_id.id
 531
 532                 if line.type == 'allowance' or line.type == 'otherpay':
 533                     rec['debit'] = amount
 534                     if not partner.property_account_payable:
 535                         raise osv.except_osv(_('Integrity Error !'), _('Please Configure Partners Payable Account!!'))
 536                     ded_rec = {
 537                         'move_id': move_id,
 538                         'name': name,
 539                         'partner_id': partner_id,
 540                         'date': slip.date,
 541                         'account_id': partner.property_account_payable.id,
 542                         'debit': 0.0,
 543                         'quantity': 1,
 544                         'credit': amount,
 545                         'journal_id': slip.journal_id.id,
 546                         'period_id': period_id,
 547                         'ref': slip.number
 548                     }
 549                     line_ids += [movel_pool.create(cr, uid, ded_rec, context=context)]
 550                 elif line.type == 'deduction' or line.type == 'otherdeduct':
 551                     if not partner.property_account_receivable:
 552                         raise osv.except_osv(_('Integrity Error !'), _('Please Configure Partners Receivable Account!!'))
 553                     rec['credit'] = amount
 554                     total_deduct += amount
 555                     ded_rec = {
 556                         'move_id': move_id,
 557                         'name': name,
 558                         'partner_id': partner_id,
 559                         'date': slip.date,
 560                         'quantity': 1,
 561                         'account_id': partner.property_account_receivable.id,
 562                         'debit': amount,
 563                         'credit': 0.0,
 564                         'journal_id': slip.journal_id.id,
 565                         'period_id': period_id,
 566                         'ref': slip.number
 567                     }
 568                     line_ids += [movel_pool.create(cr, uid, ded_rec, context=context)]
 569
 570                 line_ids += [movel_pool.create(cr, uid, rec, context=context)]
 571
 572                 # if self._debug:
 573                 #    for contrib in line.category_id.contribute_ids:
 574                 #       _log.debug("%s %s %s %s %s",  contrib.name, contrub.code, contrub.amount_type, contrib.contribute_per, line.total)
 575
 576             adj_move_id = False
 577             if total_deduct > 0:
 578                 move = {
 579                     'journal_id': slip.journal_id.id,
 580                     'period_id': period_id,
 581                     'date': slip.date,
 582                     'ref':slip.number,
 583                     'narration': 'Adjustment: %s' % (slip.name)
 584                 }
 585                 adj_move_id = move_pool.create(cr, uid, move, context=context)
 586                 name = "Adjustment Entry - %s" % (slip.employee_id.name)
 587                 self.create_voucher(cr, uid, [slip.id], name, adj_move_id)
 588
 589                 ded_rec = {
 590                     'move_id': adj_move_id,
 591                     'name': name,
 592                     'partner_id': partner_id,
 593                     'date': slip.date,
 594                     'account_id': partner.property_account_receivable.id,
 595                     'debit': 0.0,
 596                     'quantity': 1,
 597                     'credit': total_deduct,
 598                     'journal_id': slip.journal_id.id,
 599                     'period_id': period_id,
 600                     'ref': slip.number
 601                 }
 602                 line_ids += [movel_pool.create(cr, uid, ded_rec, context=context)]
 603                 cre_rec = {
 604                     'move_id': adj_move_id,
 605                     'name': name,
 606                     'partner_id': partner_id,
 607                     'date': slip.date,
 608                     'account_id': partner.property_account_payable.id,
 609                     'debit': total_deduct,
 610                     'quantity': 1,
 611                     'credit': 0.0,
 612                     'journal_id': slip.journal_id.id,
 613                     'period_id': period_id,
 614                     'ref': slip.number
 615                 }
 616                 line_ids += [movel_pool.create(cr, uid, cre_rec, context=context)]
 617
 618             rec = {
 619                 'state':'confirm',
 620                 'move_line_ids':[(6, 0,line_ids)],
 621             }
 622             if not slip.period_id:
 623                 rec['period_id'] = period_id
 624
 625             dates = prev_bounds(slip.date)
 626             exp_ids = exp_pool.search(cr, uid, [('date_valid','>=',dates[0]), ('date_valid','<=',dates[1]), ('state','=','invoiced')], context=context)
 627             if exp_ids:
 628                 acc = property_pool.get(cr, uid, 'property_account_expense_categ', 'product.category')
 629                 for exp in exp_pool.browse(cr, uid, exp_ids, context=context):
 630                     exp_res = {
 631                         'name':exp.name,
 632                         'amount_type':'fix',
 633                         'type':'otherpay',
 634                         'category_id':exp.category_id.id,
 635                         'amount':exp.amount,
 636                         'slip_id':slip.id,
 637                         'expanse_id':exp.id,
 638                         'account_id':acc
 639                     }
 640                     payslip_pool.create(cr, uid, exp_res, context=context)
 641
 642             self.write(cr, uid, [slip.id], rec, context=context)
 643
 644         return True
 645
 646 hr_payslip()
 647
 648 class hr_payslip_line(osv.osv):
 649     _inherit = 'hr.payslip.line'
 650     _columns = {
 651         'account_id': fields.many2one('account.account', 'General Account'),
 652         'analytic_account_id':fields.many2one('account.analytic.account', 'Analytic Account'),
 653     }
 654 hr_payslip_line()
 655
 656 class account_move_link_slip(osv.osv):
 657     '''
 658     Account Move Link to Pay Slip
 659     '''
 660     _name = 'hr.payslip.account.move'
 661     _description = 'Account Move Link to Pay Slip'
 662     _columns = {
 663         'name':fields.char('Name', size=256, required=True, readonly=False),
 664         'move_id':fields.many2one('account.move', 'Expense Entries', required=False, readonly=True),
 665         'slip_id':fields.many2one('hr.payslip', 'Pay Slip', required=False),
 666         'sequence': fields.integer('Sequence'),
 667     }
 668 account_move_link_slip()
 669
 670 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: