Dear Friends,
I am using odoo 8, and i want to create packing-list, which should provide me details for each Delivery like Package_name, Dimensions_of_package, material_inside_package.
From the picking report it only provide me the material but does not provide the package_name.

Any help will be highly appreciated.

Regards
Nischal.

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 .

I like to add some fields in the warehouse so I added the class with columns in the stock.py. But it shows error. I can not find what the error is.

The error message is

Traceback (most recent call last):
File "/home/rck/Desktop/odoo-8.0/openerp/http.py", line 539, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/home/rck/Desktop/odoo-8.0/openerp/http.py", line 590, in dispatch return self._json_response(result) File "/home/rck/Desktop/odoo-8.0/openerp/http.py", line 528, in _json_response body = simplejson.dumps(response) File "/usr/local/lib/python2.7/dist-packages/simplejson/__init__.py", line 366, in dumps return _default_encoder.encode(obj) File "/usr/local/lib/python2.7/dist-packages/simplejson/encoder.py", line 269, in encode chunks = self.iterencode(o, _one_shot=True) File "/usr/local/lib/python2.7/dist-packages/simplejson/encoder.py", line 348, in iterencode return _iterencode(o, 0) File "/usr/local/lib/python2.7/dist-packages/simplejson/encoder.py", line 246, in default

raise TypeError(repr(o) + " is not JSON serializable")

TypeError: product.step1() is not JSON serializable


My py code in stock.py is

class product_step1(osv.osv):
_name = "product.step1"

_columns = {

'name':fields.float('Name'),

'b':fields.float('B'),

'c':fields.float('C'),

'd':fields.float('D'),

'e':fields.float('E'),

'f':fields.float('F'),

'g':fields.float('G'),

'h':fields.float('H'),

'i':fields.float('I'),

'j':fields.float('J'),

}

my xml code in stock_view.xml is


<record model="ir.ui.view" id="step1_tree_view">

<field name="name">step1.tree</field>

<field name="model">product.step1</field>

<field name="type">tree</field>

<field name="arch" type="xml">

<tree string="Product Details">

<field name="name"/>

<field name="b"/>

<field name="c"/>

</tree> </field> </record>


<record model="ir.ui.view" id="step1_form_view">

<field name="name">step1.form</field>

<field name="model">product.step1</field>

<field name="type">form</field>

<field name="arch" type="xml">

<form string="Product Details">

<sheet>

<group>

<group>

<field name="name"/>

<field name="b"/>

<field name="c"/>

<field name="d"/>

<field name="e"/>

</group>

<group>

<field name="f"/>

<field name="g"/>

<field name="h"/>

<field name="i"/>

<field name="j"/>

</group>

</group>

</sheet>

</form> </field> </record>


<record model="ir.actions.act_window" id="action_step1_form">

<field name="name">step1</field>

<field name="res_model">product.step1</field>

</record>
<menuitem name="Product Details" parent="menu_stock_root" id="step1_menu_mainform"/>

<menuitem name="Product Description" parent="step1_menu_mainform" id="step1_menu1_mainform" action="action_step1_form"/>


When I click the Quants and stock Moves tab in warehouse this error has been shown.

Notify me where I'm doing the mistake.

Thank you.

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

Recently there have been several fundraising for Odoo.

We would recommend one, which is worth paying attention to:
https://www.indiegogo.com/projects/upgrade-odoo-community-edition#/

Help us to upgrade Odoo Community Edition to the beautiful and functional management software!

Please share by facebook, twitter, google+!

Best regards,
8cells Team

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

class mrp_product_produce(osv.osv_memory):
    _inherit = "mrp.product.produce"

    _columns = {
        'test': fields.char('test')
    }

 <record id="view_mrp_product_produce_wizard_sss" model="ir.ui.view">
            <field name="name">MRP Product Produce</field>
            <field name="model">mrp.product.produce</field>
            <field name="inherit_id" ref="mrp.view_mrp_product_produce_wizard"/>
            <field name="arch" type="xml">
                <data>
                	<xpath expr="(//field[@name='product_id'])[2]" position="after">
                		<field name="test"/>
                    </xpath>
                </data>
            </field>
        </record>

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

Hello All,
i'm new to odoo and i have created my first module
i'm trying to create a workflow that sends an outlook email when the workflow status changes and , i need to know how can i get this task done
Thanks,