1.

2.

3. 

4. 

Hi All,

My name is Fadli, my company assigning me to set up integrated distribution system covering sales, inventory/warehouse, manufacturing (Master Production Schedule, Material requirement Planning), I think the rightness and perfectness it must be integrated with accounting too. But for now, I’ll focusing on sales, inventory/warehouse and manufacturing.

I don't know specifically and sure detailed about proper choice open source ERP that suitable for our company business process. The fast way it's absolutely hiring professional ERP consultant that can help us more accurate, fast to decide. But, the company trust me to learn and finding first, before hiring consultant. It's good for the company and me too.

From the middle December 2015, I Have 3 candidates open source ERP. Openbravo, Adempiere and Odoo. I don't have good method in deciding and comparing and have no a lot of time what the best from 3. But I spent a few days to learn from my coach, mentor, colleague and google also.

So, in the end of December 2015 I'm decided to choose odoo. The reasons is :
1. Absolutely open source and have proprietary product too.
2. Web based
3. Have all basic functionality between community and proprietary versions.
4. Have all database and all core applications.
5. The software covers all the standard warehousing, manufacturing, and sales channels
6. Powerful web interface I think
7. Better I have chosen one than no one.
8. If you asked me, is this the most suitable than Adempiere or Openbravo, I will answer "I need more time to learn 3 of that", but I have looking in mailing list, forum, community from other people experience.

I have several questions, but before that I'll illustrate my company :
1. Our company is manufacturing factory
2. From raw material until finish good, the product through many production section, its about 9 work centers production.
3. Our production method based on customer order, it seems "make to order", cmiiw. But, on production, we can't producing using fixed number or sure number of goods production, we need to defining yield percentage before production. For example if we want to produce 1000 goods, we must planning about 1100. Because we have pareto in production like defect, broken or failed goods and etc. We can take temporarily conclusion, although our method is "make to order", our production section will create some stock of goods after production, it's means, in next production, before we are planning production, we need to check last stock first.
4. We have many work center, it means, we have multilevel bill of material. For illustration, the picture below I hope can help to understand what its need.

 

For last two months, I've installing, try to understand odoo 9 using my existing business case in our company, I try to create sales order then automatically create manufacturing order. I have some big question.
The question is :
1. When the sales order created, can we check stock first? If the needs ready on stock, so no need to create manufacturing orders. But if the stock only have some, then then the system create automatically the rest of needs.
2. Can system automatically create multi level manufacturing orders, of course in every levels always checking the stock first? The trigger is not the minimum stock limit, but the sales orders from customer. So, if the stock has 0, if no orders from customer, no need to create stock. But, if you have stock 1500, and the orders is need 2000, so system will automatically create the rest of needs, 500. See the picture below to illustrate.

 

The question is :
3. Which the suitable version of odoo, 9 or 8 ? since odoo 9 still lack of documentation and forum/mailing list.

4. I'm very appreciated if somebody sharing to me link tutorial / pdf / video. How to proper setup the "setting" in each module like sales, purchase, warehouse/inventory, manufacturing, so I can learn how to setup the right setting for my business case from example.

5. I would appreciate too, if somebody wanna discussing with me using skype, email, facebook or anything.

Hi everyone ! So Everything was working fine for me until the last days where i'm having an issue.

So my admin user ( whith all the access ) can't create invoice from Sales Order .

The situation: I create a sale order and the status is sale to invoice
What happen When trying to create the invoice , i have this message :

MissingError

One of the documents you are trying to access has been deleted, please try again after refreshing.

I am working on a custom module for Odoo 9 that interacts HR contract (model hr.contract).
My situation is that I want raise onchange event on employee_id field but the onchange method was originally written in old API with the combination of a Python method and XML definition as below:

    def onchange_employee_id(self, cr, uid, ids, employee_id, context=None):
        if not employee_id:
            return {'value': {'job_id': False, 'department_id': False}}
        emp_obj = self.pool.get('hr.employee').browse(cr, uid, employee_id, context=context)
        job_id = dept_id = False
        if emp_obj.job_id:
            job_id = emp_obj.job_id.id
        if emp_obj.department_id:
            dept_id = emp_obj.department_id.id
        return {'value': {'job_id': job_id, 'department_id': dept_id}}

<field name="employee_id" on_change="onchange_employee_id(employee_id)"/>

Dear all,

I want to add extra cost other than the product cost, such as transportation, freight, loading, or even customs.
I want to add these costs together, and then distributed to the products or POs i choosed, in order to recalculate the price in the PO itself, and update it in inventory.
I tried to use Landed Cost but i couldn't perform such calculation, I also tried to perform it using Purchase Cost Distribution but when click on Update i got that error:

Integrity Error

The operation cannot be completed, probably due to the following:
- deletion: you may be trying to delete a record while other records still reference it
- creation/update: a mandatory field is not correctly set

[object with reference: journal_id - journal.id]

Can any one help me with this please.
Thanks

Hello im new to odoo - 9. shall we make ledger accounts for each customer and vendor or assign existing receivable and payable accounts to it ?

Hey guys,

i'm trying to solve call a wizard(lets call it wiz2) out of another wizard(call this wiz1), then comfortably change the records of the wiz1-model via the model of wiz2.
My problem ist now that i get errors.. over and over, may one of you is able to help me.
here is my code so far:

The Code of the wiz1:

# -*- coding: utf-8 -*-
from openerp import models, fields, api
from openerp import exceptions


class TransferExtension(models.TransientModel):
    _inherit = 'stock.transfer_details_items'
    
    @api.multi
    def do_enter_serials(self):
        self.ensure_one()        
        #get the reference on new model
        wizardmodel = self.env['serial.wizard']
        #create new record
        res_id = wizardmodel.create({'item_clicked':self.id})
        #Read the view_id.
        view = self.env.ref('unique_serials_v1.view_serial_wizard')
        #call the other wizard
        return { 
            'name': 'Eingabe der Serialnummern',
            'type': 'ir.actions.act_window',
            'view_type': 'form',
            'view_mode': 'form',
            'res_model': 'serial.wizard',
            'res_id': res_id,
            'views': [(view.id, 'form')],
            'view_id': view.id,
            'target': 'new'
        }    

# -*- coding: utf-8 -*-
from openerp import models, fields, api
from openerp import exceptions


class SerialWizard(models.TransientModel):
    _name = 'serial.wizard'
    
    item_clicked = fields.Many2one('stock.transfer_details_items',string='Item')

Odoo Server Error

Traceback (most recent call last):
File "/opt/odoo/openerp/http.py", line 537, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/opt/odoo/openerp/http.py", line 588, in dispatch
return self._json_response(result)
File "/opt/odoo/openerp/http.py", line 526, in _json_response
body = simplejson.dumps(response)
File "/usr/lib/python2.7/dist-packages/simplejson/__init__.py", line 354, in dumps
return _default_encoder.encode(obj)
File "/usr/lib/python2.7/dist-packages/simplejson/encoder.py", line 262, in encode
chunks = self.iterencode(o, _one_shot=True)
File "/usr/lib/python2.7/dist-packages/simplejson/encoder.py", line 340, in iterencode
return _iterencode(o, 0)
File "/usr/lib/python2.7/dist-packages/simplejson/encoder.py", line 239, in default
raise TypeError(repr(o) + " is not JSON serializable")
TypeError: serial.wizard(7,) is not JSON serializable

Dear All,

After I'm installing Odoo 8 from bitnami in windows 7 64 bit, I'll try to backup database for backup, so when I'm trying in development, If I need to database rollback like first installing, I can restore from the backup, In Odoo 9 before, I do like that, but when I'm trying Odoo 8 I have some problem, The originally after first installing, when I try to create backup from odoo gui, the database manager in web. I got error message "access denied" when I try to backup database bitnami_openerp. So, I try to find the solution in google link : Title.

In file C:/odoo/apps/odoo/conf/conf/openerp-server.conf, I change admin_passwd = YOUR_PASSWORD. Then restart the server. After that, the error "access denied" is gone, but I have new error one.. `pg_dump`. Like picture below :

So for now, I'll try to backup manually from pg admin. But, if I'm backup from pg admin, there is need to backup all files in C:/odoo too?

Odoo Server Error
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 537, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 574, in dispatch
    result = self._call_function(**self.params)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 310, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 113, in wrapper
    return f(dbname, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 307, in checked_call
    return self.endpoint(*a, **kw)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 803, in __call__
    return self.method(*args, **kw)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 403, in response_wrap
    response = f(*args, **kw)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 944, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 936, in _call_kw
    return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/email_template/wizard/mail_compose_message.py", line 54, in default_get
    res.get('model'), res.get('res_id'), context=context
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/email_template/wizard/mail_compose_message.py", line 104, in onchange_template_id
    values = self.generate_email_for_composer_batch(cr, uid, template_id, [res_id], context=context)[res_id]
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/email_template/wizard/mail_compose_message.py", line 168, in generate_email_for_composer_batch
    template_values = self.pool.get('email.template').generate_email_batch(cr, uid, template_id, res_ids, fields=fields, context=ctx)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/email_template/email_template.py", line 514, in generate_email_batch
    result, format = self.pool['report'].get_pdf(cr, uid, [res_id], report_service, context=ctx), 'pdf'
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/report/models/report.py", line 274, in get_pdf
    paperformat, specific_paperformat_args, save_in_attachment
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/report/models/report.py", line 447, in _run_wkhtmltopdf
    wkhtmltopdf = [_get_wkhtmltopdf_bin()] + command_args + local_command_args
  File "/usr/lib/python2.7/dist-packages/openerp/addons/report/models/report.py", line 54, in _get_wkhtmltopdf_bin
    raise IOError
IOError

We have an implementation on sales.order that worked correctly until last week. Suddenly, some of the custom fields disappeared. If I check the FormView in debug, it shows the correct xml, but the UI is wrong.


Tests:

- Recovered a Monday backup, the UI is OK (lets call it "working" DB). - Check modules: Although there where some differences, installing and/or removing them didn't change anything. Module Drop shipping was in the "fault" DB and not in the "working" and Sale_service module was in the "working" DB but not in the "fault" one. Once this differences were solved, the problem persists and the same modules are installed in both DB. - A diff between FormViews confirmed that they are exactly the same. Even select arch from ir_ui_view where id = 566; returns the same content in both DBs. - Checked all possible configuration issues (menu, views…) everything is the same.