Posted in Odoo, OpenERP, OpenERP Installation, Point of Sale (POS), Uncategorized

Odoo v10 Point of Sale: POS Graphs


Click here to download from Odoo Apps

Click Open Graphs button to see graphs.

Odoo pos main screen
Odoo pos main screen

Point of sale graph module shows graphs of top customer, top product, top selling location etc…

User can also Filter by limit and duration..

POS Bar Chart
POS Bar Chart

Click on Pie Chart button to view Pie Chart.

POS Pie chart
POS Pie chart

Filter By Duration.

POS Duration Filter
POS Duration Filter

Filter By Data Limit (e.g. top 10 income by journal).
Also you can generate JPEG and PNG file.

Data Limit
Data Limit

Posted in Configuration, OpenERP, OpenERP 7.0, OpenERP Installation, Ubuntu

OpenERP 7 with SSL on Ubuntu 12.04


Lets assume that apache and required packages are installed on system.

There are some commands needs to execute to run OpenERP on SSL.

sudo apt-get install apache2
sudo a2enmod ssl proxy_http headers rewrite

Now we have created certificate and key so we have to execute these commands one by one.

sudo mkdir /etc/ssl/openerp

openssl genrsa -des3 -out oeserver.pkey 1024
openssl rsa -in oeserver.pkey -out oeserver.key
openssl req -new -key oeserver.key -out oeserver.csr

At last we signed certificate here.

openssl x509 -req -days 365 -in oeserver.csr -signkey oeserver.key -out oeserver.crt

We also created apache configuration file.

sudo vim /etc/apache2/sites-available/openerp

<VirtualHost *:443>

SSLEngine on
SSLCertificateFile /etc/ssl/openerp/oeserver.crt
SSLCertificateKeyFile /etc/ssl/openerp/oeserver.key

ProxyRequests Off

<Proxy *>
Order deny,allow
Allow from all
</Proxy *>
ProxyVia On
ProxyPass / http://127.0.0.1:8078/
<location />
ProxyPassReverse /
</location>

RequestHeader set “X-Forwarded-Proto” “https”

SetEnv proxy-nokeepalive 1
</VirtualHost>

Now enable above configuration execute below command

sudo a2ensite openerp

After above configuration, just restart OpenERP server and use this URL to test: https://127.0.0.1

Posted in OpenERP, OpenERP 7.0, OpenERP Installation

How to install new module in OpenERP 7.0 ?


As we all know that OpenERP 7.0 is near to release soon and all are waiting to use in their live business. We are trying to make people aware that how to install new module in this new version. We found some extra steps which are require to install new module which is different than OpenERP 6.1 version so just sharing with you all guys. We have created a Demo module and put that into addons directory.

1.openerp_7_login_page

Now as we can see, by default there are very less menus available at left sidebar and you won’t find ‘Update Module List’ which is there in OpenERP 6.1 by default.

2.module_list

Now lets do some small changes to see all other configuration options in left side menu list. First go to ‘Users’ menu and select ‘Administrator’ and click on ‘Edit’ button. Now change the value of ‘Administration’ field to Acess Rights and make Technical Features checkbox True. Now save record and reload again. It should display all other menus in the list. If you are not able to see all menus, you may have to re-login into the webclient.

3.admin_user

After performing above steps, you can see all menus at left sidebar as shown in following screen.

4.detail_menu_list

Now according to older version, click on ‘Update Module List’ and follow the instructions.

5.update_module_option

Finally, you will get your new module in the list.

6.module_in_list

 

Posted in CentOS, OpenERP, OpenERP Installation

How to install OpenERP on CentOS ?


As we all know that we can install OpenERP on most of the operating system. Today we have done installation on CentOS. Steps are very easy to perform this operation.

Persons who have experience on Ubuntu, they can do this job very easily. We have a command in Ubuntu ‘apt-get install‘ to install required packages. Whereas in CentOS, you can do this with the help of ‘yum install‘ command.

Create new system user with this command
adduser openerp

Now install and configure the PostgreSQL.

yum install postgresql postgresql-server

Sometimes it may happen that by default system is installing older version of postgresql (version from 8 series). Here, I am going to setup version 9.X on my machine. I have installed CentOS 6.3 x64. I have to take postgresql from repository using wget command.

wget http://yum.pgrpms.org/9.1/redhat/rhel-6-x86_64/pgdg-centos91-9.1-4.noarch.rpm

Now, install repository

rpm -i pgdg-centos91-9.1-4.noarch.rpm

For excluding posgresql, we have to change into repository file of CentOS and add ‘exclude=postgresql*’ under the [base] and [updates] sections:

cd /etc/yum.repos.d
vi CentOS-Base.repo

Let’s check that postgresql packages are available.

yum list postgres*

After above configuration, we can install PostgreSQL 9.

yum install postgresql91 postgresql91-server

And execute following commands:

service postgresql-9.1 initdb
service postgresql-9.1 start

To set postgres user, password switch to postgres user.

su - postgres

psql postgres postgres

postgres=# alter user postgres with password ‘postgres’;
ALTER ROLE
postgres=#

By default postgresql access is limited to local computer. For making it active, change into following files. You can also change default port.

/var/lib/pgsql/9.1/data/postgresql.conf

After making changes, you have to restart postgresql service by following command.

service postgresql-9.1 restart

postgres=# show listen_addresses;

listen_addresses

——————

*

(1 row)

postgres=# show port;

port

——

5432

(1 row)

Now we have to setup and install required packages for OpenERP.

yum install python-dateutil python-feedparser python-gdata python-ldap
python-libxslt1 python-lxml python-mako python-openid python-psycopg2
python-pybabel python-pychart python-pydot python-pyparsing python-reportlab
python-simplejson python-tz python-vatnumber python-vobject python-webdav
python-werkzeug python-xlwt python-yaml python-zsi

For missing packages, you can execute it following way.

easy_install python-openid

And its done.

Posted in OpenERP, OpenERP Installation, Sale

How to Install Sale / Any Module in OpenERP


If you have already installed OpenERP and created database with the use of Web Client then after some initial configuration, immediate next step will be to install required modules. Now the question is how to install modules? Here we are with the Answer…

You may like to visit How to install OpenERP 6.1 and OpenERP 6.0 on Windows Vista and Windows 7 in 10 Minutes.

Once you finish the installation process, Open WebClient by using the URL: http://localhost:8069/web/webclient/home

Next step is to create the database,

Please visit our post on How to create database in OpenERP?

Open WebClient by using the URL: http://localhost:8069/web/webclient/home

Homepage - OpenERP Web Client
Homepage – OpenERP Web Client

Click on the Settiings -> Modules -> Modules

Modules - OpenERP Web Client
Modules – OpenERP Web Client

There are four filters available.

Filters - OpenERP Web Client
Filters – OpenERP Web Client

Apps ->  List of Main Modules

Extra ->  List of Extra Addons

Installed->  List of Installed Modules

Not Installed-> List of Not Installed Modules

As of now No Module has been Installed; Click on Apps Filter and search for the Sale Module

Sale Module - OpenERP Web Client
Sale Module – OpenERP Web Client

Now Click on Install button to install Sale Module.

Sale Module Installation in Progress - OpenERP Web Client
Sale Module Installation in Progress – OpenERP Web Client

Once Sale Module will be installed, it will ask for “Install your Chart of Accounts”; Click Cancel.

Sale Module Installed - OpenERP Web Client
Sale Module Installed – OpenERP Web Client

Refresh the Window. Apply the Filter “Installed” and verify the installed Modules.

Sale Module Installed - OpenERP Web Client
Sale Module Installed – OpenERP Web Client

Done!!! 🙂

Posted in OpenERP, OpenERP Installation, Windows

How to install OpenERP 6.1 and OpenERP 6.0 on Windows Vista and Windows 7 in 10 Minutes


How to install OpenERP 6.1 and OpenERP 6.0 on Windows Vista and Windows 7 in 10 Minutes

Download Windows Auto-Installer from http://www.openerp.com/downloads/

Download Windows Auto-Installer of OpenERP
Download Windows Auto-Installer of OpenERP

Click on the installer.

Select a language in which you want to install Open ERP.

Installer Language of OpenERP
Installer Language of OpenERP

Click next in the following wizard.

OpenERP Installation Wizard
OpenERP Installation Wizard

Accept the Terms of Agreement to install OpenERP 6.1 / 6.0

Accept GNU General Public License to install OpenERP
Accept GNU General Public License to install OpenERP

There are three types of installation are available to install OpenERP 6.1

Select Type of Install to install OpenERP
Select Type of Install to install OpenERP

We select All in One installation.

All in One installation to install OpenERP
All in One installation to install OpenERP

Keep the default values for Hostname, Port, Username and Password.

PostgreSQL connection configuration to install OpenERP
PostgreSQL connection configuration to install OpenERP

Select the destination folder where you want to keep all modules related to OpenERP 6.1 and click Install.

Select destination folder on your system to install OpenERP
Select destination folder on your system to install OpenERP
OpenERP installtion in progress
OpenERP installtion in progress

It will take 5-10 minutes to complete the installation.

OpenERP installtion in Completed
OpenERP installtion in Completed

Finish the installation.

OpenERP installtion Completed
OpenERP installtion Completed

We are ready to go…

http://localhost:8069/web/webclient/home

OpenERP Web Client
OpenERP Web Client

Done!!!

🙂

Posted in Open Source, OpenERP, OpenERP Installation, PostgreSQL

How to backup and restore OpenERP database ?


There are two methods to perform backup and restore operation for OpenERP database.

Lets go through step by step:

Method 1: Using GUI

Follow the steps to create backup and restoring database.

1) Goto Login page,
2) Click on Manage Databases,
3) There are various options available on left side bar.
4) Follow the screens displayed below.

OpenERP database backup
OpenERP database backup
OpenERP database restore
OpenERP database restore

Method 2: Using command prompt (Using PostgreSQL)

It is advisable that if backup has been taken from command prompt then restoring should be from command prompt only.

Follow the screen steps for creating backup and restore.

1) Executing following command will create a blank database.
Command: createdb –encoding=UTF-8 testdb

Create blank database
Create blank database

2) Executing following command will create a backup of database : openerp_61
Command: pg_dump -f backup_openerp_61 openerp_61

OpenERP database backup from command prompt
OpenERP database backup from command prompt

3) Execute following command will restore your db into blank database created in step 1.
Command: psql testdb < backup_openerp_61

OpenERP restore database from command prompt
OpenERP restore database from command prompt

Problem during restoring from command prompt :

Upto here, assume that everything is working in the same PC. Now let say, someone is trying to restore database using command prompt for which, the database has been backed up from another PC.

Please check following screenshots.

OpenERP database backup process
OpenERP backup database process

In above case, You can see the error message `role “john” does not exist`. It means that database has been backed up from another PC having name is ‘john’.

So now, in this case there are two solutions to restore this database as follows.

1) Either you can open dump file, and change the role name wherever you find name ‘john’ as your role displayed in following screen. Here I have changed name as ‘navrang’ in place of ‘john’.

OpenERP restore database process
OpenERP restore database process

2) Another option is, if dump file is too long to change role/owner name, then you can create a user in your PC named ‘john’ so it will work as it is.

And this way we can restore our database.