How to add Project Field to Manufacturing Order

Custom Field

Activate developer mode
Go to Settings > Technical > Database structure > Models
Search for model mrp.production and open it
Add a new field named x_project_id with parameters shown in the attached screen shot "Selection_034.png"
Go to Manufacturing > Operations > Manufacturing Orders and open one
From debug menu click to see the dropdown menu then click the menu item "Edit Form View". See attached "Selection_036.png"
Edit the architecture as seen in the attached scree shot "Selection_037.png" then save it.
Reload the page (Ctrl+F5, or Command+R if you are on Mac) to see the project field is now on the Manufacturing Order form.

Now, you are almost done. Just a few more steps to ensure future updates will not revert your customization:

Do the step 6 above
Click on the link in the field Model data. See attached "Selection_039.png"
Check Non Updatable then save.

Hope this could help!

0

16 August 2022, by

David Tran

| 0 Answers | 3,729 Views

How to create a chart of accounts for my country from scratch

Korean Chart of Accounts Kế toán Chart of Accounts

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?

0

2 June 2015, by

Daniel Bak

| 0 Answers | 4,948 Views

Odoo 8 packaging report

Warehouse Management Logistics

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.

0

26 October 2015, by

nischal

| 0 Answers | 4,689 Views

How to Set Default Debit Account and Default Credit Account for Opening Entries Journal in odoo 8

How to Set Default Debit Account and Default Credit Account for Opening Entries Journal in odoo 8
And I want to know
"Opening Expense Account" Internal Type="Regular" and Account Type="Expense" and set Default Debit Account
Account Code ? and Parent Account ?

"Opening Income Account" Internal Type="Regular" and Account Type="Income" and set Default Credit Account

Account Code ? and Parent Account ?

Please Answer me

0

30 May 2016, by

Md Abul Hossain Hashem

| 0 Answers | 3,790 Views

Facing problem to set odoo10(MLM module) database in postgresql 9.4 BDR at Debian linux

Odoo 10

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

0

7 January 2018, by

SNS Odoo

| 0 Answers | 3,918 Views

TypeError: product.step1() is not JSON serializable

Warehouse Management

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.

0

28 September 2016, by

Uppili

| 0 Answers | 4,732 Views

Chart of Account Report (account.general_report.) subtotal...

how to subtotal debit , creid by date or by peroid?

0

14 September 2016, by

Jason

| 0 Answers | 3,816 Views

Extending a osv_memory and use that column in xml

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

0

21 January 2016, by

Gert

| 0 Answers | 3,552 Views

How to apply payment via xmlrpc?

I have created invoice in Odoo and I need to apply payments to this invoice via xmlrpc.

How should I do this?

I tried to create voucher for this invoice but it seems that this isn't enough..

I'm using PHP.

0

7 December 2015, by

Tim Thickhorn

| 0 Answers | 4,536 Views

Help

Welcome!