Odoo. Approved by IT Libertas. December 2016

Manufacturing costs, No auto procurement for MRP, Fuzzy search

IT Libertas, Aleksandr Filippov

The following apps have been tested and have been approved by IT Libertas developers, in order to help you use Odoo. When programmers had faced any bugs, they fixed them. The resulted modules are structured and would be used as a base of Odoo implementation. Besides, each description contains links to download an application and to configure it with your own hands

Product cost based on bill of materials

Odoo 8
MRP Costprice 0001
The app automatically calculates cost of products according to costs and prices of its components', defined in bill of materials.
As a result 2 types of prices are available:
  • BOM Cost Price - according to internal costs of components;
  • BOM Sale Price - according to public prices of components.
In both cases components' prices/costs are just summed up with multipliers from BoMs.
The app also let set up automatic prices update based on ones, defined through calculations. 

No manufacturing order autoconfirm

Odoo 8

Standard Odoo package assumes that, when manufacturing procurement is confirmed, a manufacturing order is not only created but also confirmed

This app changes such behavior, preventing automatic confirmation of manufacturing orders. Thus, orders would be in the state "New, when procurement is launched.

Производство в состоянии "Новое"
Подтверждение снабжения с правилом "производство"

Fuzzy Search

Odoo 8
fuzzy_search_main

The app is a tool to create GIN & GiST indexes for text and char fields with possibility to implement the fuzzy search operator "%" in Odoo domains.
How to use:

  1. Add indexes under the menu unit  "Settings -> Database Structure -> Trigram Index". It would speed up operators "like" & "ilike" in case of significant number of records;
  2. Use the operator "%" for fuzzy search.
To set up:
  1. Make sure the extension "pg_trgm" is installed;
  2. Add "pg_trgm" to a database or provide your postgresql user with the rights SUPERUSER.