Odoo or SAP ERP?

Odoo or SAP ERP ? If you are not an IT related person, you might be amazing what ODOO is . ?

Odoo is nothing but a suite of open-source business apps written in Python programming language and was released under the AGPL license . Odoo is the leading open source solution . The previous name of Odoo is Open ERP ( until May 2014 ) . The main Odoo components are the server , 260 core modules and around 4000 + community modules it does possess . Odoo has no licensing cost .

Odoo is a popular business suite for any […] Read more

Odoo server requirements

Odoo server requirements: Choose the right system

The standard Odoo server requirements are quite low. Odoo 8 or 9 are not very demanding when one considers the required hardware. The following grid should give you an idea and help you choose the right server:

To have more details, use the author’s interactive grid here:

This is only an estimation of the typical Odoo server requirements, assuming the database size is “standard” and the usage is typical. Of course, this is not covering the VM possibility although it is well known that VMs will come along with more issues and problems, especially as far […] Read more

Check your Odoo setup in 3 stages

Check your Odoo setup in 3 stages

Check your Odoo implementation

If your implementation was done correctly, your system should not only run very fast but also be very stable. If this is not the case, it is great time to check your Odoo implementation. This means the technical deployment of either Odoo and / or PostGreSQL was not done properly. Before choosing a partner, have you followed the “BE SAFE” recommendations?

If you have not, you already ahving bugs, error messages, server restarts et…. etc… This is the common lot of unexperienced implementations. Now it is time to cross-check your implementation. You can easily do so by checking […] Read more

Odoo extra needed modules

This is a list of Odoo extra needed modules. This list is not exhaustive but is meant to give you the possibility to extend the possibilities and functionalities of your application.

Module name
Type
Source
Branch
Patches
Code lines

account
official
OpenERP S.A.
github/odoo/odoo
12
28 473

account_accountant
official
OpenERP S.A.
github/odoo/odoo
0
64

account_cancel
official
OpenERP S.A.
github/odoo/odoo
0
61

account_chart
official
OpenERP S.A.
github/odoo/odoo
0
35

account_payment
official
OpenERP S.A.
github/odoo/odoo
0
1 456

account_voucher
official
OpenERP S.A.
github/odoo/odoo
0
5 493

analytic
official
OpenERP S.A.
github/odoo/odoo
0
422

auth_crypt
official
OpenERP S.A.
github/odoo/odoo
0
72

auth_signup
official
OpenERP S.A.
github/odoo/odoo
0
542

base
official
OpenERP S.A.
github/odoo/odoo
1
27 723

base_iban
official
OpenERP S.A.
github/odoo/odoo
0
179

base_import
official
OpenERP S.A.
github/odoo/odoo
0
1645

base_setup
official
OpenERP S.A.
github/odoo/odoo
0
411

base_vat
official
OpenERP S.A.
github/odoo/odoo
0
302

board
official
OpenERP S.A.
github/odoo/odoo
0
976

decimal_precision
official
OpenERP S.A.
github/odoo/odoo
0
166

delivery
official
OpenERP S.A.
github/odoo/odoo
0
1 065

document
official
OpenERP S.A.
github/odoo/odoo
0
2 663

edi
official
OpenERP S.A.
github/odoo/odoo
0
608

email_template
official
OpenERP S.A.
github/odoo/odoo
0
1 543

fetchmail
official
OpenERP S.A.
github/odoo/odoo
0
465

knowledge
official
OpenERP S.A.
github/odoo/odoo
0
95

l10n_fr
official
Communauté française d’OpenERP
github/odoo/odoo
0
10 969

mail
official
OpenERP S.A.
github/odoo/odoo
0
9847

mrp
official
OpenERP S.A.
github/odoo/odoo
0
5 181

payment
official
OpenERP S.A.
github/odoo/odoo
0
639

payment_transfer
official
OpenERP S.A.
github/odoo/odoo
0
135

point_of_sale
official
OpenERP S.A.
github/odoo/odoo
10
15 466

procurement
official
OpenERP S.A.
github/odoo/odoo
0
657

product
official
OpenERP S.A.
github/odoo/odoo
3
4 575

product_visible_discount
official
OpenERP S.A.
github/odoo/odoo
2
135

purchase
official
OpenERP S.A.
github/odoo/odoo
7
5 216

purchase_double_validation
official
OpenERP S.A.
github/odoo/odoo
0
160

report
official
OpenERP S.A.
github/odoo/odoo
0
1 106

report_webkit
official
Camptocamp
github/odoo/odoo
0
984

resource
official
OpenERP S.A.
github/odoo/odoo
0
4 555

sale
official
OpenERP S.A.
github/odoo/odoo
3
4 959

sale_mrp
official
OpenERP S.A.
github/odoo/odoo
0
362

sales_team
official
OpenERP S.A.
github/odoo/odoo
0
519

sale_stock
official
OpenERP S.A.
github/odoo/odoo
0
1 312

share
official
OpenERP S.A.
github/odoo/odoo
0
1 063

stock
official
OpenERP S.A.
github/odoo/odoo
3
12 728

stock_account
official
OpenERP S.A.
github/odoo/odoo
0
1 367

stock_picking_wave
official
OpenERP S.A.
github/odoo/odoo
0
388

Modules Web
official
OpenERP S.A.
github/odoo/odoo
2
43 039

OCA Modules

mass
OCA
Akretion […] Read more

Pgbouncer Odoo

Why will pgbouncer save you?

Because out of the box, Odoo is using standard postGreSQL which is unable to kill ids idle connections.

For that reason, whoever is going to production with multi-user configuration needs pgbouncer to be setup and running. Why? Because PostreSQL keeps opening new connections for Odoo but never closes them. They are kept idle and saturate memory until either the maximum number of allowed connections OR the memory runs out.

The more users you have …. and the more workers and threads you get…. and the faster the problem occurs.

As a typical example, for a server being used by […] Read more

Odoo postgreSQL on a VM

Odoo postgreSQL on a VM

Although the official position is to avoid installing Odoo on a VM, I found out over the years that PostgreSQL had improved a whole lot since version 9.2 and it was not foolish to consider a VM under Vsphere as a potential candidate for a production environment.

Odoo & postgreSQL inside a VM

vPostgres 9.2 inherits all the performance improvements made in PostgreSQL 9.2 from upstream and features good out-of-box performance in most situations. vSphere is known for great out-of-box performance for common enterprise workloads. As a result, we refer to the performance best practices for vSphere and PostgreSQL for general performance […] Read more

Improve your Odoo PostgreSQL performance

Improve your Odoo PostgreSQL performance

You probably have noticed already that Odoo and PostgreSQL are installed in separate packages. That should give you the following clue:

 

The standard PostgreSQL installation is neither optimized for your hardware not for your Odoo

 

Before you move into running PostgreSQL with your Odoo and through Python-driven requests, here is a list of the things you should do to give your system a real chance to run decently:

 

PostgreSQL logging

Be generous with logging; it’s very low-impact on the system
Locations for logs are better managed by syslog.
Just use:

log_destination = ‘csvlog’

log_directory = ‘pg_log’

Shared_buffers

work_mem

Start low: 32-64MB
Look for ‘temporary file’ lines in logs
set to 2-3x the largest […] Read more

Odoo accounting setup

Odoo accounting setup

Odoo accounting setup can be done in many different ways.

If your installation is “new”and your client doesn’t have any requirement regading the Chart of Account, the easiest way would be to:

Use the standard COA provided with the Odoo accounting setup.
Complement it manually wth your extra needs.

Yet, if your client wants to integrate his own Chat of accounts because he is familiar with it by mere corporate culture or because it is so big that inputing manually would be a great waste of time, then, you merely have two different alternatives:

Odoo accounting setup using CSV: The following required fields will be […] Read more

Odoo Accounting: The first and most essential step

Odoo Accounting: The first and most essential step

Praesent augue arcu, ornare ut tincidunt eu, mattis a libero. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas nec tincidunt leo euismod non. Suspendisse cursus risus laoreet turpis auctor, nec pharetra massa varius. Suspendisse dignissim sollicitudin sem, id ornare elit aliquam. […] Read more

Odoo partner indonesia

Odoo partner indonesia

 

Odoo partner Indonesia: The issues I see too often

 

Odoo partner Indonesia: the dangers of open-source  wasting months, years, and money

Middle and large size businesses have been targeted by so-called “ERP consultants” more or less affiliated to the Odoo Indonesia Partner program for a few years now in Jakarta and Indonesia as a whole. From my own private experience, less than half of the projects I have been called-in to try fix were finished. In most cases, implementation schedule was long time expired while the budget was already partly or entirely spent.

Bugs, crashes, instability: faulty code and/or implementation

The initial idea was […] Read more