Odoo studio Limitations

Odoo studio allows you to customize the user interface with very limited programming knowledge. It allows to write some Python code as well but a very limited portion of features can be customized from there. Here are the areas and industries where it will not work or somehow will create hurdles,

  • Nothing you do in odoo studio can be used in the community edition of odoo.
  • for all many enhancement to odoo 12, there are major weaknesses associated with recording custom odoo applications.
  • Because of the way you develop with odoo studio, it can again be very tough to control processes inside production installations.

Highly Customized business process

If your current business process if highly customized or proprietary to your owned business then generic ERP process may not work for you well and can turn into confusion for your employees.

Manufacturing Process

This is the main area where the Odoo studio will not work because of complicated processes. E.g. if you are looking to execute the work order in different stages and at the similar time you need some task order to go to the near stage after a real amount of time, it should be possible to customize

Import/Export of data

The migration will really not useful on this area, we have recently viewed an issue of importing work order and so the customer has had to change to the on-premise odoo
When you migrate from another system, your import process requires a high degree of customization and for that, you will need a full path to the Odoo backend system to write Python code.

Same way, you can not customize the export process very well.

Crons and Schedulers

Because you have restricted access to the Python//backend system, you can’t write crons very well and can’t automate many methods you want.

Ownership of the Data

The hosted answer limits the control of your data to the Odoo itself. However, they have a reliable cloud but if you want to keep the data completely, you will have to sort of premise Odoo that means, self-hosted Odoo. That doesn’t expect that you will have to choose some odoo partner to host your odoo on their support, you can have your private leased server from any provider and you can host it there.

At Silent Infotech we recommend going for either On-premise community or on-premise Enterprise. It’s a myth that it is hard to manage the on-premise odoo instance. We have Odoo special cloud and infrastructure in place to host on-premise odoo with the full power of customization.

We are a leading provider of ERP/CRM services, we provide advance initiative technology

Our team of experienced and dedicated developers has enough talent tons of experience in developing software products and solutions.

ERP solutions and Integrations based on OpenERP

We at Silent Infotech create a solution that enables the business, organization, and startups with perceptive design and innovative technology.

ERP system is a major need of any business and we have establishes odoo ERP solution to suits your business. We guarantee you that the ERP module excellently customized and cleverly implemented. Here we will give you the warranty for methodical formation, secure data service and the facility of the configuration.

Our odoo specialists are able to deliver you the scalable, adaptable and guardian solution. Our odoo solutions can help an existing Magento store. By the new odoo integration feature it is manageable inventory, integrate sales orders and POS and deliver faster results.

Here in silent infotech, our experts offer stellar service integral to your business.

Our Services as ERP system Solution

In silent infotech, we provide you the odoo ERP service with some advance innovation.

  • We provide the hosting, installation, implementation. Configuration and support.
  • We can customize the odoo module with business specific needs.
  • Training and support for business employees.
  • Odoo based solution and e-commerce system maintenance.
  • Data migration.
  • Seamless odoo integration of existing business processes.
  • Odoo has a centralized database that supports existing apps.
  • Comprehensive troubleshooting, support, and maintenance.

Our Odoo ERP innovations

(1) Odoo Middleware 

Odoo middleware is a core engine to serve as a RESTful interface to the third party applications on the behalf of Odoo.

Benefits

  • This wheel has been invented to keep the centralized routing of the calls from all the third-party applications.
  • Mobile apps can be kept very lightweight in terms of code and all the business logic can be handled on the server side hence apps can perform well.
  • It will provide a universal interface to VOIP applications, Thermal printers, POS devices, IoT Devices which are obvious components to be integrated with Odoo.
  • Almost all the customization will survive the version upgrades of Odoo.

(2) Royal mail integration

Odoo module integrating with royal mail shipment service.

Royal Mail serves as biggest postal services in the United Kingdom having a rich set of API and strong authentication mechanism.

Odoo has been integrated with RM-Royal Mail APIs in order to fully automate the process of label printing and shipping. It has been several years since industry seeking such an automated process to reduce the efforts and focus on main business.

Watch video

(3) Payfort Payment Gateway integration

PayFort is the Most Trusted Online Payment Gateway in the Middle East because of the local currency support and local technical support. They have clients from various industries and who are industry leaders in the Middle East like Souq.com and Carrefour UAE.

Our Payfort payment gateway module leverages odoo’s architectural modularity to provide the Merchant Odoo system an integrated payment processing functionality. This type of integration allows the Merchant’s Customer to check-out on the Merchant’s payment page without being redirected to external sites and thus enjoy the seamless User experience.

Watch video

(4) Zimbra mail integration with odoo

Zimbra an email collaboration suite has more than 500 million trusted users worldwide. Here in silent infotech, we provide consultation, implementation and migration services with support for your Zimbra email solution.


(5) Open cell integration with odoo

Absolute integration of two giant financial systems in order to achieve smooth migration without any extra migration cost! Established fully IFRS compliant accounting system for a telecom giant XGate

Similar integration for odoo and quickbook accounting/bookkeeping system has been achieved as well.

Our recent achievements

Cloud-based ERP for Radiofrequency

we have built cloud-based ERP system for Radio Frequency industries. it is capable to take care of end to end process of Sales, Purchase, Inventory and warehouse management. It also includes the manufacturing process.

Watch video

allows you to manage inventory with multiple warehouses and multiple locations.
It is fully cloud-based and will provide you with full mobility. Watch Video

AI-based Seafood Supplychain

our AI based seafood supplychain ERP provides real-time traceability of seafood and where the seafood supplier can trace and track the freshness and quality of seafood. We are providing supply chain planning, supplier scheduling, product configurator, order to cash, purchasing, inventory, warehousing, and shipment Read More

Kare Portal – The cloud-based Electronic Health record system

Cloud-based Electronic Health Records System (EHR System) for seamless integration between and Patient, Doctor and Pharmacies with the secure channel.

The patient portal, Doctor’s portal, and Pharmacy portal are three main components on the same platform. Read More

How to use RFID for inventory & warehouse management

RFID stands on “Radiofrequency Identification”.

RFID is the technology which is working on radio frequency waves. So this technology is used to automatically identify the objects.

Here the objects could be anything, it could be a book in a library, any item which you are purchasing from the shopping mall, inventory in the warehouse, or maybe your own car. Not only objects it can be used to tracking the animals as well as the birds.

In this technology, the RFID tags used to get attached with the object which we want to track. This RFID reader is continuously sending the radio waves, so whenever the object is in the range of the reader then this RFID tag is used to transmit its feedback signal to the reader.

It is nearly similar the technology which is used in the barcode. But in case of a barcode, the object and the scanner should be in a line of sight. As in the RFID, technology is not a line of sight technology so far as this object is in within the range of the reader, the object is able to identify the reader and it is able to send a feedback signal back to the reader.

Using the RFID technology we can track the multiple objects at the same time.

RFID system contains 2 components,

  1. RFID reader
  2. RFID tag

RFID tags are coming in many ways,

  1. Active tags
  2. Passive Tags
  3. Semi-Passive Tags

If it is a mobile handled like we will be using today only a handled reader and an RFID tag will be needed.

RFID readers mainly consist of 3 components

  1. RF signal generator – It generates the radio wave which is transmitted using the antenna. Also, receive the feedback signal which is coming from the tag.
  2. Receiver / Signal Detector – To process the information which is being sent by the RFID tag.
  3. Microcontroller – many times this RFID reader is directly connected with the computer.

How to use RFID for inventory & warehouse management

  • Supplier reserve the products through the application for reservation.
  • Transfer through the system to the warehouse manager.
  • After agreeing the supplier’s warehousing application the warehouse manager chooses to confirm the expected storage.
  • Suppliers follow up the requirements, import the information by electronic tags and single phase correlation with shipments.
  • The staff collates the information of the goods ready for shipment through the vehicle read-write device.
  • The RFID reader installed at the door of the warehouse instantly reads out the goods and sends the information to the company.
  • Achieve real-time dynamic management of supplier’s shipment information and confirm shipment information again.

Warehousing Process

  • After goods enter the storage area, the staff scan the goods in the storage area.
  • If quantity and excepted quantity are kept, the next step will continue.
  • The system follows up stocks and supply information and lays down the location of goods.
  • And sends the information to the onboard computer to indicate the best path.
  • After the goods are mounted, scan the RFID labels on the track and check the cargo information.
  • Information has been associated with the shelves to completes the warehousing process, to achieve the synchronization of checking location.

Outbound process

  • After the delivery order is received by the information, it sends to the forklift truck.
  • After the goods are off the shelves, the staff scan the electronic labels on the shelves to unbind the goods with the shelves.
  • The staff scanned the goods in the shipment area and confirmed the shipment information.
  • When the goods are transported to the doorway of the warehouse, the RFID fixed reader on the door of the warehouse checks the cargo information and quantity again.
  • Completing the outgoing process after confirmation.

Inventory Process

  • First, the system sends the inventory plan to the PDA(Personal Digital Assistant) handset.
  • The staff can check the information about the goods by checking PDA.
  • After receiving the instruction, the staff scan all the goods by mobile mode.
  • Read all cargo information at one time.
  • Record the inventory results synchronously and compare with the inventory plan to achieve dynamic inventory.

Benefits of RFID

  • Allows individual stock items to be traced, located and retrieved without human intervention.
    • Because the RFID chip system monitors the stocks 24/7
  • Automatically identifies stock levels to check for when recording is required.
    • This is so that user time for manual recording can be reduced.
  • Provides more accurate system and eliminates human errors.
    • This is because the company will benefit from fewer errors in ordering costs and so save money.
  • Many RFID tags can be read at once
    • This saves time because of whole pallets of products can be checked simultaneously.
  • Tags can be overwritten – the information can be changed.
    • This enables to be updated, for example when the stock is moved from one side of a store to another.
  • Security of stock is increased.
    • This is because of tag readers can be placed at exits so that if stock if moved without authority it triggers the alarms.
  • It can help to save money.
    • This is because RFID tags can prevent over-stocking on items such as perishable goods that have a short shelf life.
  • RFID technology at the point-of-sale can be used to monitor demand trends.
    • This is so stores can use the information to predict what should be ordered or for similar products to be considered for sale.

Barcode Vs RFID

BarcodeRFID
Barcode system requires a line of sight for a read.RFID system uses a radio wave proximity system.
Barcode reader typically operates in distance of 1 to approx 18 inches.RFID system can operate in distances greater than 100m.
Due to the line of sight requirement, barcode system can only read a single barcode at a time.RFID system depending on certain types and/or flavors of systems can read anywhere from 10’s to 100’s tags in simultaneously.
The quality of a barcode can deteriorate rapidly over a short amount of time resulting in failed read attempts.RFID tags are typically more rugged and therefore have a longer life expectancy than barcode labels.
Barcode readers are only able to read information from the barcode label.RFID system has the ability to read and write to the RFID tags.
Today barcodes are found on almost every item and there are no privacy issues involved with its use.RFID tags are more reusable and rugged as they are protected by a plastic cover.
Barcodes are a universal technology in that they are the norm for retail products; stores that own a barcode reader can process barcodes from anywhere in the world.RFID contain high levels of security; data can be encrypted, password protected or set to include a ‘kill’ feature to remove data permanently.

Silent Infotech’s Solution

We have developed the AI based seafood supplychain ERP where the where the seafood supplier can trace and track the freshness and quality of seafood. We are providing supplychain planning, supplier scheduling, product configurator, order to cash, purchasing, inventory, warehousing, and shipment.

In this ERP Seafood Caught by the fisherman and is then tagged with RFID or QR Codes, this then gets transferred, and the sensors on the seafood transmit information in real time about location, time, date, etc.

Odoo Community VS Odoo Enterprise

In the starting phase, odoo familiar as OpenERP is a set of open source enterprise management applications.

The large companies, small business, associations and many different types of organizations used odoo for control, automate, measure and optimize their operations, finance and projects.

In the odoo version 6,7, & 8 there are no technical variations between community and enterprise version and it has changed in V9.

Features of Odoo Community:

The Odoo Community Association is the non-profitable organization which promotes the global use of odoo and assists the synergetic development of odoo feature.

It provides financial, organizational and legal assistance to the larger odoo open source community. It is also provided as an independent legal entity where community member can subscribe the code, funding, and other resources with knowledge and their subscription will be maintained for public benefits.

Odoo software can be used, modified and distributed by anyone.

The source code, bug reports pull requests are hosted by GitHub to access anyone.

Features of Odoo Enterprise:

If the user applies for the proprietary license he/she only can use the odoo enterprise subscription.

  • Modifications are allowed.
  • Distribution only to odoo enterprise subscribers.

All odoo projects are fully hosted on GitHub and access to all partners and customers who have an odoo subscription.

The whole database and back-end applications, without limitations, are in Odoo Community.

  • Basic Functionality is in Odoo Community.
  • Migration to the next version by Odoo SA engineers is in Odoo Enterprise.
  • Several Functionalities are in Odoo Enterprise.
  • Support of the non-customized Odoo Enterprise by Odoo SA Engineers.
  • Apps from Odoo Store.

Odoo Enterprise is a combination of “odoo community + additional functional modules”

The difference between two editions Community version &Enterprise version.

LayerCommunity version Enterprise version 
Required hardwareFrom 2 CPU/ @ RAMFrom 2 CPU/ @ RAM
ScalabilityThe same load balancingThe same load balancing
FlexibilityThe same modular architectureThe same modular architecture
Community and Store AppCan Install any moduleCan Install any module
Enterprise AppNot availableIncluded in the package
LocalizationThe same localizationThe same localization
Out-of-the-boxRequires more customizationIncludes nice UI and more functionality
Access rightsThe same configurationThe same configuration
UIStandard interfaceNice and fast navigation
Support and upgradeNot includedIncluded by vendor
PriceNo licence cost20 EUR/user/month
Development accessIt can be utilized by the developers.To access enterprise you will have to purchase LGPL(Lesser General public license) which has been published by free software foundation.
ControlYou can install any module via community and store appsYou can not install any module directly.
Mobile supportNot availableAvailable
UniquenessCommunity edition does not contain all the features of the enterprise.Enterprise edition does contain all the features of the community.

Hardware & Scalability:

  • If we follow the hardware essence odoo can be estimated for companies of almost any size and odoo did it for 2000 global companies with vast terrestrial distribution but it recommended the breaking applications and database servers for 90 employees. The load balancing of application server would be used for a company who have 250+ employees.
  • There are 90% free and 10% paid applications are available in odoo app store.
  • Odoo Enterprise includes additional unique modules that will move the ERP experience to the next level.
  • Any localization can be installed as additional on both versions.

Flexibility in community and enterprise apps:

odoo have the modular structure, by this, you can customize through modules and database configuration.

 

Installing high availability Odoo 11 on ubuntu 16.04

You must be aware that now odoo has released version 11 officially. To know odoo 11 features click here

In this tutorial I’ll explain you how to install high availability odoo version 11(Community version) on ubuntu 16.04

Note : There is no major difference for installing odoo community and odoo enterprise version.

Overall System Architecture

 

If python is already installed, make sure you have installed python version 3.5 or above. Previous versions of python are not compatible with odoo 11.

Installation Guide

In this tutorial, I assume that you have properly configured your network for the required servers and you have basic networking knowledge to replace/change ip addresses mentioned throughout this tutorial with the appropriate ip addresses.

Database Server(s) Installation

Step 1 : Installation

Before you proceed for the installation, make sure you have configured locale settings properly.

sudo apt-get -y install postgresql postgresql-contrib

Step 2 : Create user with password

sudo -u postgres createuser odoo11
sudo -u postgres psql
psql=# alter user odoo11 with encrypted password '<password>';

 

Step 3 : Allow remote connection from application servers

All below lines in /etc/postgresql/9.5/main/pg_hba.conf file on top

host all odoo8 192.168.1.51/32 trust
host all odoo8 192.168.1.52/32 trust
host all odoo8 192.168.1.53/32 trust
host all odoo8 192.168.1.54/32 trust

Restart postgresql service

systemctl restart postgresql

Application Server(s) Installation

Follow mentioned steps on each of the application server(s) to install odoo application only. For simplicity I will be using the debian package to install the odoo server, you can also follow the manual installation process from other tutorials.

Step 1 : Download latest version

http://nightly.odoo.com/11.0/nightly/deb/odoo_11.0.latest_all.deb

Step 2 : Install odoo

Before you proceed for this command make sure that your locale is setup properly if you are using VPS.

dpkg -i odoo_11.0.latest_all.deb

If you encounter the blow error during the installation

# dpkg -i odoo_11.0.latest_all.deb 
Selecting previously unselected package odoo.
(Reading database ... 26866 files and directories currently installed.)
Preparing to unpack odoo_11.0.latest_all.deb ...
Unpacking odoo (11.0.20171114) ...
dpkg: dependency problems prevent configuration of odoo:
 odoo depends on python3-babel; however:
 Package python3-babel is not installed.
 odoo depends on python3-dateutil; however:
 Package python3-dateutil is not installed.
 odoo depends on python3-decorator; however:
 Package python3-decorator is not installed.
 odoo depends on python3-docutils; however:
 Package python3-docutils is not installed.
 odoo depends on python3-feedparser; however:
 Package python3-feedparser is not installed.
 odoo depends on python3-gevent; however:
 Package python3-gevent is not installed.
 odoo depends on python3-html2text; however:
 Package python3-html2text is not installed.
 odoo depends on python3-jinja2; however:
 Package python3-jinja2 is not installed.
 odoo depends on python3-lxml; however:
 Package python3-lxml is not installed.
 odoo depends on python3-mako; however:
 Package python3-mako is not installed.
 odoo depends on python3-mock; however:
 Package python3-mock is not installed.
 odoo depends on python
dpkg: error processing package odoo (--install):
 dependency problems - leaving unconfigured
Processing triggers for systemd (229-4ubuntu12) ...
Errors were encountered while processing:
 odoo

You can run,

apt-get install -f

This command will installed all the dependency libraries on the system.

Note : Debian package installer by default install postgresql as dependent package, we can stop the postgresql service and remove service from the system startup service list.

sudo systemctl stop postgresql
sudo update-rc.d postgresql disable

Step 3 : Database configurations

Let’s help application server to find the database from the configuration file. (/etc/odoo/openerp-server.conf)

db_host = 192.168.1.61
db_port = 5432
db_user = odoo11
db_password = xxxx

Note : Don’t forgot to replace your database name and database password with appropriate values.

Step 4 : Custom Modules

To install the custom modules on all application server, you need to configure NFS to share the directory which can be accessible from all the application and which should be mounted automatically on system startup.

After successful configuration of NFS on all application server you can add mount path in addons_path param(can be found on odoo configuration file)

Load Balancer Installation

Step 1 : Install nginx

sudo apt-get install nginx

Step 2 : Nginx site configuration

Create a configuration file under /etc/nginx/sites-enabled/xyz.com.conf with below content. Don’t forgot to change the domain name and SSL certificate path.

upstream backend  {
       server 192.168.1.51:8069;
       server 192.168.1.52:8069;
       server 192.168.1.53:8069;
       server 192.168.1.54:8069;
}

upstream backend-longpolling {
server 192.168.1.51:8072;
server 192.168.1.52:8072;
server 192.168.1.53:8072;
server 192.168.1.54:8072;
}

server {
   server_name xyz.com www.xyz.com;

   location / {
       return 301 https://$server_name$request_uri;
    }
}




server {
listen          443 ssl;

server_name xyz.com www.xyz.com;
proxy_connect_timeout       60000;
proxy_send_timeout          60000;
proxy_read_timeout          60000;
send_timeout                60000;

ssl_dhparam /etc/ssl/certs/dhparam.pem;
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forward-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto https;
proxy_intercept_errors on;

location /longpolling {
     proxy_pass http://backend-longpolling;
}

location / {
          proxy_pass http://backend;
}

ssl_certificate /etc/nginx/ssl/www_xyz_com.crt; 
ssl_certificate_key /etc/nginx/ssl/www_xyz_com.key;
}

Step 3 : Restart nginx service

systemctl restart nginx.service

Step 4 : Access odoo application from the browser.

Navigate from your public ip address if port 80 and 443 are already forwarded from the firewall.