Hi everyone!

I noticed that at the end of the view for Leave Request (example) there is a "Messages and communication history" box.

Below the code:

I want to create a new custom module that whenever the button "Save" is clicked (the leave request is saved), it will add a message in 'oe_chatter' (chatterbox) saying that "New leave request has been created" (attached is the example message)

Kindly let me know if you have an idea. Thanks in advance! :)

I am looking for option to maintain automatic version wise document in the odoo.
For e.g.. intial draft document prepare by one official that is version 1 and then it is modified by another official is version 2, finally got approved by top official version 3.
By this way document, version wise document is maintaind and log is also maintained.
Please advice me

Kindly let me know the procedure to make Employee Advance Request ?
I can't see the analytic account option in that form. In many cases, when the staff ask for Advance Request, s/he needs to mentioned the Analytic Account to make sure that there is still budget available on it and the supervisor approve and finance pay.

After the staff return, where s/he has to put/input the actual transactions ?
How to settle the cash advance if the actual expense is over / under the cash advance request.

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

Using this module we purchased: https://apps.odoo.com/apps/modules/12.0/to_hr_overtime_payroll/

I want to create a different salary rule with different computation base on Overtime HOUR TOTAL for each Overtime Type group by type. How would I achieve it using python code?

For Example I have OTREG and OTSUN

CODE : OTHOUR : SALARY RULE : PYTHON CODE

OTREG0006 : 05 : REGULAR OVERTIME : ????

OTREG0617 : 05 : REGULAR OVERTIME : ????

OTSUN0006 : 08 : SUNDAY OVERTIME : ????

OTSUN0617 : 04 : SUNDAY OVERTIME : ????

I am trying to take reports using yearly salary by head which gives employee name, net salary, and total salary.
My HR Team is asking me to include bank account numbers of each employees in the report, how do i get it can any one help me with it.

Hello,

I've installed erponline, and I'm trying to get the "Categories" feature within my forum as you did guys (Categories with "General Discussions", "Agents & Resellers", "Developers"…).

I could not manage to install such a feature. Do you know how to do it?

Thanks

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

In my sales order invoice template I get only one variant attribute of a product.I want to print all variants of a product in my    invoice template.I  tried this below code in report_invoice_document

<t t-set="itr" t-value="0"/> 
      <tr t-foreach="o.invoice_line_ids" t-as="l">
             <t t-set="itr" t-value="itr+1"/>
             <td><t t-esc="itr"/></td>
             <td><span t-field="l.name"/>||<span t-field="l.product_id.product_variant_ids"/>
                    <span t-field="l.product_id.is_product_variant"/>||<span t-field="l.product_id.attribute_line_ids"/>||
                    <span t-field="l.product_id.attribute_value_ids"/></td>

[456] pants (Blue, Small)||product.product(2,)True||product.attribute.line(10, 11)||product.attribute.value(1, 4)

We are currently using Odoo 10 Enterprise edition . We need to reconcile paypal transactions with the sale order invoice and for that we need to get the paypal transaction from Paypal account (Not talking about paypal configuration which can be used in odoo e-commerce).We referred this link https://www.odoo.com/documentation/user/9.0/accounting/bank/feeds/paypal.html and it didn't helped us. We need to get the same thing happening in link . But not sure how to achieve it .