Checking lead-times in OpenERP

December 23, 2011 Leave a comment

In case you need to check your suppliers’ lead-times in OpenERP, it is quite easy. You need to go to Warehouse > Reporting >  Movement Analysis. You will be able to see a view where you can filter by partner, product, location and other attributes the planned lead-time and execution lead-time. This is a great report for checking the accuracy of lead-times.

Movement Analysis View in OpenERP

Movement Analysis View

Data integrity issues in MRP implementations

December 22, 2011 Leave a comment

A good description of the data integrity issues found in MRP implementations can be found in the article on MRP in Wikipedia. In a nutshell, if the

English: MRP

Image via Wikipedia

information in your manufacturing system is bad, don’t expect its planning to be any better (or GIGO). While you are implementing the MRP module in OpenERP, you should pay attention to the following information items in your systems:

  • Lead-times: critical for the timing phase of your planning. If production or supplier lead-times are not accurate, don’t be surprised to find planning dates that are not realistic.
  • Stock levels: very critical, since all the procurements are created when the stock levels drop down below its reorder point or when a customer makes an order (depending on how you have your system set-up)
  • Bills of Materials: your system will procure either raw material, work in process inventory or end-items. Which items it will procure depends on the accuracy of Bill of Materials. Your BoM needs to reflect how your product is assembled. I found some places where the BoM only reflects the cost structure of the end-item, and that is wrong. The cost of the end-item is a different problem that needs to be addressed in a different module than the manufacturing module.
  • Products: your system needs to have all the products you procure (either by purchasing or manufacturing) and sell. And its description needs to be complete.
  • MPS, or production schedule: needs to be available in order to make the plan. In all the manufacturing plants there is a production schedule. People might not be aware there is one, but actually you can find it in the daily or weekly manufacturing plans.
  • Reorder points: you need reorder points (minimum and maximum stock levels) in some products in order to not disrupt your quality of service. We will not get into the calculation of these items (by now)

    We will get into more detail on these items and how to address them in further posts


Deleted records in OpenERP

December 21, 2011 Leave a comment
The blue/white elephant logo of the PostgreSQL...

Image via Wikipedia

Sooner or later you will find yourself with pgAdmin (or any other query tool) querying the OpenERP database in order to pull statistical information. It happens, and it is a healthy sign of your OpenERP implementation.

Something you need to keep in mind is how OpenERP “deletes” its records. It does not physically remove them. It just marks them as deleted. And it does so with the active field in the table. This field, which happens to be a boolean field, if true indicates that the record is not deleted. Otherwise you should not take the record into account in your queries.


Time-outs and the openerp-web client

December 20, 2011 Leave a comment

Sometimes you need to change the time-out setting of your openerp-web client application. There might be many reasons for this, among them the need to submit long  processes or views that take minutes to retrieve the desired data. Doing this is no big deal with the GTK client, but gets tricky  when it comes to the web client since you get a time-out error message after two minutes of inactivity.

How do you solve this? It’s easy. In OpenERP v5 you need to locate the file In that file, search for the file that reads:


In my web client, that happens to be the line 49. Then you change the parameter of the settimeout function to the number of seconds you desire. Then restart your web client.

With OpenERP v6 is pretty much the same story, now you do not need to modify the source code. You only need to change the openerp-web.cfg configuration file. In that file, you will find the following entry in the OpenERP Server section:

openerp.server.timeout = 450

Then you have to restart your web client application.
That’s all you need to do in order to change your timeout settings in your OpenERP Web Application.


OERPEnv: an environment manager for OpenERP

My business partner Cristian developed last week an application for managing different independent development/production environments in OpenERP. The idea is the tools allows you develop new modules easily, test new ones and test different configurations. For those with experience in Drupal, OERPEnv is similar to the drush tool. These days this tool is under development, so we don’t recommend it for those without Linux experience.

Below is the repository link where you can download the tool:

If you have any question, please feel free to ask.


Categories: Configuration, Python, Ubuntu

Squid, CherryPy and OpenERP

Squid (software)

Image via Wikipedia

This is going to be quick…

Squid and CherryPy (therefore the web client of OpenERP) do not get along pretty well. Reason being CherryPy expects to know the originating URL by reading the http “X-Forwarded-Host” header. The only reverse proxies that add this header are Apache (mod_proxy) and Lighttp. This does not happen with Squid. Actually it does, but this information is published under the variable “Origin”. The result is in order to integrate CherryPy with Squid, you need to modify a little bit the CherryPy code.

In the file lib/, located under the root of CherryPy (v3) you can find the proxy function. Just by setting the input variable of the “local” function, which is set by default in “X-Forwarded-Host”, to “Origin” is enough. And doing so you will be able to save a lot of time (in my case 4 hours) and trouble.

You might wonder why you need this, just in case you need to work  with OpenERP behind a reverse proxy like Squid.


A list of OpenERP blogs

Not covered by (they should be added there though). Some of these blogs are in spanish and one of them is in portuguese, but I thought it makes sense to list them here as well.

And last but not least…
It’s shocking to see a newspaper specialized in OpenERP
Categories: Uncategorized