Odoo v10 Point of Sale: Print x-report (Mid-day sale report)


Click here to download from Odoo Apps

Configure Hardware Proxy / PosBox for the printer, If hardware is not connected or not configure then it will print in PDF format

POS Configuration
POS Configuration

Print X-Report from below button

Printing file
Printing file

Here is the printed X-Report

Report
Report

Advertisements

Odoo V9 POS Reorder, Reprint


Click here to download from Odoo Apps

POS Reorder module allow user to view past pos orders, reorder the particular draft order and make a order as draft from POS. It is also possible to re-print receipt and view products of order from pos order list. There are some filter based on state, date of order and also searching functionality.

Here you can set configuration for order list in POS.
As per below image you can set start date that is used for display POS orders from start date to till date in order list.
Record per page is used to display number of records per page in order list.

POS Config
POS Config

Then create a button on home screen of pos as given in the below image.
Create another button on home screen to make a pos order as draft.

POS Buttons Scrren
POS Buttons Scrren

Now here is the list of past pos orders in tabular format.
On this orders table you can do filtration, re-print receipt, re-order the order, view products of order as given in the below image.

POS Order List
POS Order List

Here is the product popup that contains list of products of particular order.
Whenever you click on product icon it will show order details. You can also re-order from this popup.

POS Products Popup
POS Products Popup

How to drop the database in OpenERP?


Do you want to drop database in OpenERp using Web Client? Here we provide step by step menthod to drop the PostgreSQL.

Click on the Manage Databases Link to drop Database (PostgreSQL).

Before you create any database, you need to install OpenERP.To install OpenERP 6.1 and OpenERP 6.0 on Windows Vista and Windows 7 in 10 Minutes, 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?

Once you have the database and in case you want to drop it then follow the steps given below:

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

Click on the Manage Databases Link to drop Database (PostgreSQL).

Manage Databases in OpenERP Web Client
Manage Databases in OpenERP Web Client

Click on the Drop Link

Drop Database in OpenERP Web Client
Drop Database in OpenERP Web Client

Select the database to drop and provide the master password, in our case “admin” 🙂

Drop Database in OpenERP Web Client
Drop Database in OpenERP Web Client

It will ask for the confirmation to drop the postgreSQL database.

Drop Database confirmation in OpenERP Web Client
Drop Database confirmation in OpenERP Web Client

Click on Ok.

Done!!! 🙂

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!!!

🙂

Maintain log of Product sale price in OpenERP…


Assume that we are running our business in OpenERP and managing all our processes in good way. We are selling products to our customers and update product price according to market. When we have started our business, we were sell product X in 10 USD but now we are selling the same product in 50 USD. It shows that our business is going good way and also getting new customers.

But we have one big question in our mind is that how this price has been changed from 10 USD to 50 USD means at what time we have changed price of our product. We have no track for this change. Just to overcome from this situation we have implemented a solution.

After installing module, you will see “Product Rate” menu at this location : “Configuration/Products”

Now select product that you want to configure. We have just added some prices as per date.
Latest price is selected according to last date.

Now just open product form. You will see “Update” button besides Sale Price field. User can also enter price manually. Sale Price will update from configuration table after click on “Update” button.

How to install Magento in Ubuntu ?


Now it’s turn to install another eCommerceMagento‘ which is feature-rich eCommerce platform built on open-source technology. Magento is available in two editions: Community and Enterprise.

Installing and Configuring Apache

$ sudo apt-get install apache2

You may see following message during installation:

apache2: Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1 for ServerName

To fix that problem, you need to edit the httpd.conf file. Open the terminal and type

$ sudo gedit /etc/apache2/httpd.conf

By default httpd.conf file will be blank. Now, simply add the following line to the file.

ServerName localhost

Save the file and exit from gEdit.

Finally restart the server.
$ sudo /etc/init.d/apache2 restart

* Restarting web server apache2
…. waiting             [ OK ]

sudo a2enmod rewrite

Installing PHP

sudo apt-get install php5 php5-curl php5-gd php5-mcrypt php5-mysql

Installing MySQL

sudo apt-get install mysql-server

To know more system requirements click on following link :

http://www.magentocommerce.com/system-requirements

Now create directory for magento

mkdir /home/magento
chgrp www-data /home/magento
mkdir -p /home/magento/{public,log}

Configuring Apache Virtual Host

Now we are going to create simple virtual host configuration file that will help Apache to display the data of directory /home/ubuntu/magento for any HTTP request to localhost.magento.com

Create “magento.com” file in this location “/etc/apache2/sites-available/” with following content.

<VirtualHost *:80>

ServerName localhost.magento.com
ServerAlias http://www.localhost.magento.com

DocumentRoot /home/ubuntu/magento/public

LogLevel warn
ErrorLog /home/ubuntu/magento/log/error.log
CustomLog /home/ubuntu/magento/log/access.log combined

</VirtualHost>

Use a2ensite command and restart Apache to load the new configuration file.

sudo a2ensite magento.com
sudo service apache2 restart

To ensure that the domain localhost.magento.com resolves locally to the computer require entries to /etc/hosts file.

# For magento

127.0.0.1 localhost.magento.com
127.0.0.1 http://www.localhost.magento.com

Now hit localhost.magento.com in your browser to check working status after completion of above entries.

Now we will execute installation steps of main topic.

Type following command on prompt. It will ask for root user password.

mysql -u root -p

Now lets create database for Magento.

CREATE DATABASE magento;
INSERT INTO mysql.user (User,Host,Password) VALUES(‘magento’,’localhost’,PASSWORD(‘magento’));
GRANT ALL PRIVILEGES ON magento.* TO magento@localhost;

Now download latest stable Magento from
http://www.magentocommerce.com/download
and put zip file into /home/ubuntu/magento/public

If error: ERROR 1133 (42000): Can’t find any matching row in the user table
FLUSH PRIVILEGES;

For testing Magento, you can download it from
http://www.magentocommerce.com/downloads/assets/1.6.1.0/magento-sample-data-1.6.1.0.tar.gz

mv magento-sample-data-1.6.1.0/media/* media/
mv magento-sample-data-1.6.1.0/magento_sample_data_for_1.6.1.0.sql sample_data.sql

Now we have to insert sample data into database that we earlier created for Magento.

mysql -u magento -p
USE magento;
SOURCE sample_data.sql;

Now everything is setup so open your browser and type localhost.magento.com and follow installation steps. You will find following screen.

Here is your Magento is working.

How to configure Request for Quotation in OpenERP ?


Today I am going to post a new OpenERP functional video.

My topic is Request for Quotation.

For each business deal, we need to have sales, purchase, quotation and all these things in matter.
OpenERP provides all these facilities to manage our business easily.