Dear members,



I want to link an analytic account to an employee, so when i made a payslip for him and confirm it, it shows in the entry generated by it.

I installed the module "hr_payroll_analytic_account", and i linked an analytic account and a salary journal to the employee contract, i configured also an analytic journal to that journal. But still when i confirm the payslip and view the generated entry, it didn't show the analytic account i previously configured.

Could you please guide me?

Thanks

I have installed HR module and Apply record rules on hr.employee model is [('user_id', '=', user.id)] and assign Manager for that employee after this module install Leave Management Module.

When employee apply leave from leave management module display Error

[quote]AccessError

The requested operation cannot be completed due to security restrictions. Please contact your system administrator.

(Document type: hr.employee, Operation: read)[/quote]

Dear all,

I reversed a transfer -scrapped product- from a sales order, but it didn't make any entries, and the product original quantity was increased by this quantity, which is scrap.

I need to know how to make them scrap and to add them to a scrap inventory where i can manage, and also i don'e want the product quantity to increase by this return, because its scrap not salable.

Can any one help, thanks

1.Work Absence
-If there are employee who doesn’t scan finger print at all on that date it will count as 1 day absence,
1 day absence mean employee doesn’t get paid on that specific day so the calculation will be like this
result = (contract.wage / 30) * days employee missed

start_dt = datetime.datetime.combine(fields.Date.from_string(payslip.date_from), datetime.datetime.min.time())
end_dt = datetime.datetime.combine(fields.Date.from_string(payslip.date_to), datetime.datetime.max.time())

start_dt_str = fields.Datetime.to_string(start_dt)
end_dt_str = fields.Datetime.to_string(end_dt)

resource_calendar_id = employee._get_resource_calendar()
attendance_ids = employee.attendance_ids.filtered(lambda att: att.check_in >= start_dt_str and att.check_out <= end_dt_str)

missed_days = 0
for dt in dateutil.rrule.rrule(dateutil.rrule.DAILY, dtstart=start_dt, until=end_dt):
    if not resource_calendar_id._is_work_day(dt.date(), resource_calendar_id.id):
        continue

    if not attendance_ids.filtered(lambda att: fields.Date.from_string(att.check_in) == dt.date() and fields.Date.from_string(att.check_out) == dt.date()):
        missed_days +=1

result = (contract.wage / 30) * missed_days

start_dt = datetime.datetime.combine(fields.Date.from_string(payslip.date_from), datetime.datetime.min.time())
end_dt = datetime.datetime.combine(fields.Date.from_string(payslip.date_to), datetime.datetime.max.time())

start_dt_str = fields.Datetime.to_string(start_dt)
end_dt_str = fields.Datetime.to_string(end_dt)

resource_calendar_id = employee._get_resource_calendar()
attendance_ids = employee.attendance_ids.filtered(lambda att: att.check_in >= start_dt_str and att.check_out <= end_dt_str)

lates_count = 0
for dt in dateutil.rrule.rrule(dateutil.rrule.DAILY, dtstart=start_dt, until=end_dt):
    employee_att_ids = attendance_ids.filtered(lambda att: fields.Date.from_string(att.check_in) == dt.date())
    if employee_att_ids:
        emp_check_in = fields.Datetime.from_string(employee_att_ids[0].check_in)
        calendar_att_ids = resource_calendar_id._get_day_attendances(dt.date(), dt.min.time(), dt.max.time())
        if calendar_att_ids:
            hour, minute = divmod(calendar_att_ids[0].hour_from * 60.0, 60)
            calendar_start_dt = dt.replace(hour=int(hour), minute=int(minute))
            if (emp_check_in - calendar_start_dt).seconds / 60 > 10.0:
                lates_count += 1

result = (contract.wage / 30) * (lates_count // 11)

start_dt = datetime.datetime.combine(fields.Date.from_string(payslip.date_from), datetime.datetime.min.time())
end_dt = datetime.datetime.combine(fields.Date.from_string(payslip.date_to), datetime.datetime.max.time())

start_dt_str = fields.Datetime.to_string(start_dt)
end_dt_str = fields.Datetime.to_string(end_dt)

resource_calendar_id = employee._get_resource_calendar()
attendance_ids = employee.attendance_ids.filtered(lambda att: att.check_in >= start_dt_str and att.check_out <= end_dt_str)

cumm_lates_minutes= 0.0
for dt in dateutil.rrule.rrule(dateutil.rrule.DAILY, dtstart=start_dt, until=end_dt):
    employee_att_ids = attendance_ids.filtered(lambda att: fields.Date.from_string(att.check_in) == dt.date())
    if employee_att_ids:
        emp_check_in = fields.Datetime.from_string(employee_att_ids[0].check_in)
        calendar_att_ids = resource_calendar_id._get_day_attendances(dt.date(), dt.min.time(), dt.max.time())
        if calendar_att_ids:
            hour, minute = divmod(calendar_att_ids[0].hour_from * 60.0, 60)
            calendar_start_dt = dt.replace(hour=int(hour), minute=int(minute))
            late_minutes = (emp_check_in - calendar_start_dt).seconds / 60
            cumm_lates_minutes += late_minutes
        
late_hours = cumm_lates_minutes // 60
result = (contract.wage / 30) * (late_hours // 4)

# cost per hour
hour_cost = ((contract.wage / 30) / 8 )

# start calculating overtime cost
result = 0.0
if payslip.hr_overtime_line_ids:
    for line in payslip.hr_overtime_line_ids:
        if line.work_day_type_id and line.work_day_type_id.is_holiday:
            result += hour_cost * line.worked_hours * line.work_day_type_id.rate / 100.0
        else:
            result += hour_cost * line.worked_hours * line.rate / 100.0

Hey, I want to recomend my module for odoo 8.0:

https://www.odoo.com/apps/themes/8.0/material_backend_theme/

I have inherited hr.holidays module and create new module.Override write method of hr.holidays model and add some new functionality in this method. Remove call super method from new write method using

Existing
return super(hr_holidays,self).write(cr, uid, ids, vals, contex=None)
Repalce with
osv.osv.write(self,cr,uid,ids,vals,context=contex)

Odoo 10 and PostgreSQL 9.4 BDR

We are trying to set Odoo10 (One customized MLM Module) with PostgreSQL 9.4 BDR at Debian Linux

When we have done setup Odoo10 database with PostgreSQL 9.4 BDR and trying to start Odoo server. Its provide the error for Primary key is not set for many tables or Drop the particular table, which don't have Primary key.
error

File "/opt/odoo/odoo/addons/project/report/project_report.py", line 88, in init
tools.drop_view_if_exists(self._cr, self._table)
File "/opt/odoo/odoo/odoo/tools/sql.py", line 5, in drop_view_if_exists
cr.execute("DROP view IF EXISTS %s CASCADE" % (viewname,))
File "/opt/odoo/odoo/odoo/sql_db.py", line 141, in wrapper
return f(self, *args, **kwargs)
File "/opt/odoo/odoo/odoo/sql_db.py", line 218, in execute
res = self._obj.execute(query, params)
ProgrammingError: "report_project_task_user" is not a view
HINT: Use DROP TABLE to remove a table.

**warning**
HINT:  Drop the secondary unique constraint(s), change the table(s) to UNLOGGED if they don't need to be replicated, or exclude the table(s) from the active replication set(s).
WARNING:  Secondary unique constraint(s) exist on replicated table(s)
DETAIL:  Table public.mail_wizard_invite_res_partner_rel has secondary unique constraint mail_wizard_invite_res_partne_mail_wizard_invite_id_res_par_key. This may cause unhandled replication conflicts.
HINT:  Tables without a PRIMARY KEY cannot be UPDATEd or DELETEd from, only INSERTed into. Add a PRIMARY KEY.
WARNING:  Table public.mail_wizard_invite_res_partner_rel has no PRIMARY KEY
HINT:  Tables without a PRIMARY KEY cannot be UPDATEd or DELETEd from, only INSERTed into. Add a PRIMARY KEY.
WARNING:  Table public.mail_message_mail_channel_rel has no PRIMARY KEY
HINT:  Tables without a PRIMARY KEY cannot be UPDATEd or DELETEd from, only INSERTed into. Add a PRIMARY KEY.
WARNING:  Table public.project_tags_project_task_rel has no PRIMARY KEY

How to use the sum of a field obtained in a view to perform other operations

Hello,

I understand that ERPOnline offers a free subdomain in form of xxx.erponline.vn but I wonder if I can use my own domain name mycompany.com instead?

I am new to Odoo and like it much but I is not delivered with my country specific chart of accounts.
How can I make it work in Odoo / ERPOnline?