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>

and I get the output               

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

                   
Is there any solution to solve this ??

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.

**When I am going to create node 1 ==> SELECT bdr.bdr_group_create( local_node_name := 'node1', node_external_dsn := user= dbname= password=);
at my first BDR machine, its provide **warning** like below.**

**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

Please let me know if any one faced this kind of problem. Please provide the solution on this.

Thank in Advance

..py file

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

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

…xml file

 <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>

gives next error ;-(

2016-01-21 11:06:12,725 6351 INFO db_20160107 openerp.modules.module: module SSS_po_project_task: creating or updating database tables
2016-01-21 11:06:13,758 6351 INFO db_20160107 openerp.modules.loading: loading SSS_po_project_task/views/mrp_view.xml
2016-01-21 11:06:14,347 6351 ERROR db_20160107 openerp.addons.base.ir.ir_ui_view: Veld test` bestaat niet

Fout context:
Weergave`MRP Product Produce`
[view_id: 1288, xml_id: SSS_po_project_task.view_mrp_product_produce_wizard_sss, model: mrp.product.produce, parent_id: 907]
2016-01-21 11:06:14,348 6351 DEBUG db_20160107 openerp.models: Exception while validating constraint
Traceback (most recent call last):
File "/media/disk2/workspace/odoo8_sss/openerp/models.py", line 1251, in _validate_fields
valid = valid or fun(self._model, cr, uid, ids)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 202, in _check_xml
self.postprocess_and_fields(cr, uid, view.model, view_doc, view.id, context=context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 806, in postprocess_and_fields
fields_def = self.postprocess(cr, user, model, node, view_id, False, fields, context=context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 716, in postprocess
fields.update(self.postprocess(cr, user, model, f, view_id, in_tree_view, model_fields, context))
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 716, in postprocess
fields.update(self.postprocess(cr, user, model, f, view_id, in_tree_view, model_fields, context))
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 643, in postprocess
xarch, xfields = self.postprocess_and_fields(cr, user, field.comodel_name, f, view_id, ctx)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 832, in postprocess_and_fields
self.raise_view_error(cr, user, message, view_id, context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 360, in raise_view_error
raise AttributeError(message)
AttributeError: Veld test` bestaat niet

Fout context:
Weergave`MRP Product Produce`
[view_id: 1288, xml_id: SSS_po_project_task.view_mrp_product_produce_wizard_sss, model: mrp.product.produce, parent_id: 907]
2016-01-21 11:06:14,362 6351 ERROR db_20160107 openerp.http: Exception during JSON request handling.
Traceback (most recent call last):
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 537, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 574, in dispatch
result = self._call_function(**self.params)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 310, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/service/model.py", line 118, in wrapper
return f(dbname, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 307, in checked_call
return self.endpoint(*a, **kw)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 803, in __call__
return self.method(*args, **kw)
File "/media/disk2/workspace/odoo8_sss/openerp/http.py", line 403, in response_wrap
response = f(*args, **kw)
File "/media/disk2/workspace/odoo8_sss/addons/web/controllers/main.py", line 948, in call_button
action = self._call_kw(model, method, args, {})
File "/media/disk2/workspace/odoo8_sss/addons/web/controllers/main.py", line 936, in _call_kw
return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/module/module.py", line 534, in button_immediate_upgrade
return self._button_immediate_function(cr, uid, ids, self.button_upgrade, context=context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/module/module.py", line 495, in _button_immediate_function
registry = openerp.modules.registry.RegistryManager.new(cr.dbname, update_module=True)
File "/media/disk2/workspace/odoo8_sss/openerp/modules/registry.py", line 370, in new
openerp.modules.load_modules(registry._db, force_demo, status, update_module)
File "/media/disk2/workspace/odoo8_sss/openerp/modules/loading.py", line 351, in load_modules
force, status, report, loaded_modules, update_module)
File "/media/disk2/workspace/odoo8_sss/openerp/modules/loading.py", line 255, in load_marked_modules
loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
File "/media/disk2/workspace/odoo8_sss/openerp/modules/loading.py", line 176, in load_module_graph
_load_data(cr, module_name, idref, mode, kind='data')
File "/media/disk2/workspace/odoo8_sss/openerp/modules/loading.py", line 118, in _load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/media/disk2/workspace/odoo8_sss/openerp/tools/convert.py", line 901, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/media/disk2/workspace/odoo8_sss/openerp/tools/convert.py", line 987, in convert_xml_import
obj.parse(doc.getroot(), mode=mode)
File "/media/disk2/workspace/odoo8_sss/openerp/tools/convert.py", line 853, in parse
self._tags[rec.tag](self.cr, rec, n, mode=mode)
File "/media/disk2/workspace/odoo8_sss/openerp/tools/convert.py", line 763, in _tag_record
id = self.pool['ir.model.data']._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context )
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_model.py", line 1025, in _update
model_obj.write(cr, uid, [res_id], values, context=context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/addons/base/ir/ir_ui_view.py", line 273, in write
context)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 372, in old_api
result = method(recs, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/models.py", line 3787, in write
self._write(old_vals)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 248, in wrapper
return new_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 565, in new_api
result = method(self._model, cr, uid, self.ids, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/models.py", line 3959, in _write
recs._validate_fields(vals)
File "/media/disk2/workspace/odoo8_sss/openerp/api.py", line 248, in wrapper
return new_api(self, *args, **kwargs)
File "/media/disk2/workspace/odoo8_sss/openerp/models.py", line 1272, in _validate_fields
raise ValidationError('\n'.join(errors))
ParseError: "ValidateError
Field(s) `arch` failed against a constraint: Invalid view definition

Meer info over fout:
Veld test` bestaat niet

Fout context:
Weergave`MRP Product Produce`
[view_id: 1288, xml_id: SSS_po_project_task.view_mrp_product_produce_wizard_sss, model: mrp.product.produce, parent_id: 907]" while parsing /media/disk2/workspace/odoo8_sss/custom_artissan/SSS_po_project_task/views/mrp_view.xml:21, near
<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>
2016-01-21 11:06:14,370 6351 INFO db_20160107 werkzeug: 10.0.0.64 - - [21/Jan/2016 11:06:14] "POST /web/dataset/call_button HTTP/1.1" 200 -
2016-01-21 11:06:32,661 6351 INFO db_20160107 openerp.modules.loading: loading 1 modules…
2016-01-21 11:06:32,684 6351 INFO db_20160107 openerp.modules.loading: 1 modules loaded in 0.02s, 0 queries
2016-01-21 11:06:33,400 6351 DEBUG db_20160107 openerp.modules.loading: Updating graph with 107 more modules
2016-01-21 11:06:33,440 6351 INFO db_20160107 openerp.modules.loading: loading 108 modules…
2016-01-21 11:06:41,515 6351 INFO db_20160107 openerp.modules.module: module SSS_po_project_task: creating or updating database tables
2016-01-21 11:06:42,663 6351 INFO db_20160107 openerp.modules.loading: loading SSS_po_project_task/views/mrp_view.xml
2016-01-21 11:06:43,565 6351 ERROR db_20160107 openerp.addons.base.ir.ir_ui_view: Veld test` bestaat niet


Can anyone help me please????

Dear all,

At Odoo, I want every cash transaction -whether cash in or cash out- to go only through a cash box in Cash Registers.
I made a purchase for a foreign currency (USD) other than my default functional currency(EGP), when reconcile i put that foreign currency cash account, but it didn't reconciled, it bring up a ValidateError:

Field(s) `currency_id` failed against a constraint: The selected account of your Journal Entry forces to provide a secondary currency. You should remove the secondary currency on the account or select a multi-currency view on the journal.


I configured the journals as follows:

- Cash journal (EGP): Currency is: EGP, the secondary currency of the selected account for the journal is: EGP
- Cash journal (USD): Currency is: USD, the secondary currency of the selected account for the journal is: USD


Can you help me please