Category Archives: OpenERP
OpenERP is an enterprise resource planning softwaree and an incredible platfom for business applications development.
OpenERP Point of Sale: Product Quantity in different warehouse, Discount restriction by password
As we are developing new features in OpenERP Point of Sale, here are some more important features that we have implemented in OpenERP 7 Point of Sale.
In this blog we can see following features:
– Enhancement in discount restriction using password
– Display product quantity in different warehouse from POS.
Here in below screen we can see that we can define maximum limit of discount and password.
We can also define users, and point of sale who can access this discount features during point of sale operation.
This is a normal screen from where we can define discount and right now we can see that we have displayed products which have quantity > 0.
Now when we click on any product, so immediately we will have this kind of view, and we can see big image of that product and we have a link here “Details”, which will open warehouse list with number of quantity of this particular products.
For discount to be apply on all products in the order, we can enter amount in this field.
So we have discount applied on all products in the list.
If user is trying to enter discount more than given limit, then it will ask for password, and if password is correct then only given discount can be applied.
Here is the receipt which has discount amount displayed with each products.
And the same discount is transferred in the backend order also.
SagePay integration with OpenERP
We have implemented solution for allowing payment process via SagePay from OpenERP. We will see how this module is developed.
We will start from configuration of SagePay account information. It is very important to select appropriate “MODE” of SagePay account.
It is possible that customer may have more than one credit cards. We can configure credit card related information into Customer form itself. We are storing credit card number into database with encrypted format.
To process with sagepay, we have added option into OpenERP voucher form. We can easily make payment or stop it from here.
We are allowing to make three types of transactions with SagePay from OpenERP.
- Payment
– Deferred
– Authenticate
Further process will work according to selected transaction.
After making process, SagePay server will give response about transaction and we are storing that into database for future actions.
We are storing mainly following data:
- Transaction ID
– Transaction Status
– Transaction Message
Now It is very easy to stop your transaction for any reason.
We are restricting user to make any invalid actions on transactions.
It is displaying VOID response from SagePay server. It is possible to perform on transactions which are registered with SagePay.
As mentioned above, it is possible to ABORT only DEFERRED transactions.
We are getting status “REGISTERED” for AUTHENTICATE type of transaction. And that transaction has to AUTHORIZE with SagePay.
We are keeping record of each and every transaction with detail information in OpenERP.
This is how SagePay Simulator page looking.
Here we have to Add IP address of our server or machine from where we are accessing our SagePay account through API. And also add appropriate Currency code for allowing transactions.
It is displaying list of transactions that is related with our account.
OpenERP integration with BluePay
Recently we have made integration with OpenERP with Authorize.net for payment services. Now we have integrated OpenERP with another Payment services, BluePay. We can have more information from http://www.bluepay.com. With help of this module, it is very easy to process with credit card from OpenERP interface.
First of all we have to create account on BluePay and get required information and use those information to connect with BluePay from OpenERP. We have tested each transaction in TEST mode.
It requires credit card information to make transactions. We are storing required details into Customer form. We are using AES algorithm for securing credit card number into database.
Sometimes it is require to know that customer has enough balance in his credit card or not. We are giving facility that user will enter amount that he has to check for particular customer and get relevant message.
As we are storing credit card number in a secure way in database so it is not allow to change credit card number directly.
We have improved GUI of voucher for sending payment request to BluePay. It allows to send request only one time if it will succeed. And also stroing transaction related information into voucher for future purpose. It will cancel payment request with BluePay if we are going to cancel voucher.
Sometimes it is require that customer wants to pay amount in installment. We are allowing to create recurring payment request with BluePay.
We are keeping track of messages for each and every transactions occur during recurring payment.
User can change any parameter during recurring payment process execution. And can cancel it also.
We are tracking details of each and every transactions with BluePay.
User can print transaction details on PDF report by entering date range and proper parameter selection.
OpenERP: Supplier Sales Report
We are discussing about business where company is getting products from suppliers, stores it in warehouse or any other locations, and selling of it. Sometimes it requires to inform supplier that how many daily sales occur for products and how much remain at the end of the day.
Some companies are not buying products from suppliers but keep it in their warehouses and selling on behalf of suppliers.
In intial state, we have define and assume that one product is supplied by one supplier only.
For sending email we have created email template which make it more generic.
And for automatic sending emails, we used cron jobs which makes work very easy.
It is possible that all supplier don’t require notification about products those sold today. We make it optional also.
Now going to make sales order where one product has supplier defined and require to get notification about sales.
And we have completed all process of delivery order also.
When cron job is going to execute, it is sending email like below:
You can find PDF report as a attachment.
OpenERP: Calculate resource hours based on job position
In many industries it requires to distribute work between employees as per their skills and availability. Without proper management, we never know that how many total working hours in our company according to designation or job position and how many in use and pending.
Here we are linking job position with working time.
This is configuration detail of working time.
For our example, there are three employees related with Marketing job position.
Now we are going to create Project Task for marketing employee. Still now this task is not assigned to any particular employee. This way we have created 2 Tasks.
As you can see there is one approved leave request of employee who belongs to maketing designation.
We can see now how many hours available with us for particular job position between some periods. There are total 3 employees related with that job position.
Working hours for 1 person for 1 day is 9 hours. so it is 9 * 3 = 27 hours for 3 persons.
Allocated Hours means total task hours assigned to that job position. Holiday Hours in below screen considered as approved leave of any employee related with that job position.
You can create directly task for remaining hours for same job position on particular date.
OpenERP 7 : Hotel Management
Hotel management module is already available in OpenERP 6.1. Now this module is available in OpenERP v7 with many extra features.
Following screen shows enhancement for Reservation process and unique identification for each reservation.
User can generate reservation report also.
Following screen will display Reservation link with one Folio even reserved more than one room.
Now user can perform more options from Resevation form.
There is a good feature which we like to show here is Availability of Rooms. If the room is not available then it will not be visible during room selection.
We have developed some views for Reservation – Kanban View
Reservation – Calendar View
User can check the Room Availability between given dates in case of advance booking is required.
OpenERP : Roster Management Module
As we know OpenERP is such a strong and wide ERP and we can perform unbelievable implementation in it.
We have implemented a concept called ‘Roster Management’ which is mainly creating recurrent tasks of employees for certain projects and periods.
For any organization, it mainly require to define public holidays according to their country and region.
There is leave request by an employee which is already approved.
This is an important form for creating recurrent task.
Let’s check fields details here.
Cancel Leave – It will create task for employee and cancel employee leaves which are already approved and send an email to that particular employee also.
No Employee – It will create tasks without assigning any particular employee.
Start Date – This date will consider for starting date of creating task and check for employee leaves those already approved.
End Date – This date will consider for ending date of created task and check for employee leaves those already approved.
Start Time / End Time – Consider it for Task creation
Day Length – Sometimes task may span in more than 1 days. Default value is Zero.
Recurrency Period – Daily / Weekly / Monthly
After click on Generate button, it will open following window. It will display Public Holidays as well as employee approved leaves. By default, it will not create any task for those dates which include in both sections. It will create task on holiday or leave if user remove it manually from list.
As you can see in following screen, there is no task created for 12, 13 and 15 date.
It is sending an email like below in case of employee leave has been cancel.
Employee’s cancelled leave
This menu display all tasks those start and end in current week. It consider week from Monday To Sunday.
There is a facility to send an email or print tasks for employee for particular period.
It is sending list of tasks in PDF file as a attachment to each employee on their working email address.
It is also possible to print in PDF report.
For monthly option we can have following:
– Date of Month
– Day of Month
For weekly task creation, we have this following screen.
OpenERP Point of Sale: Customer selection with Fiscal Position
Till now in OpenERP Point of Sale we have made many features like,
– Session wise customer selection
– Quick Create, Edit of customer
– Pricelist applied to customer
– Unique serial number on product
– Total discount on product
– User wise restriction on discount, qty.
– Create Sales Order from POS
– Create Invoice from POS
– Display real quantity of products
– Load only products if quantity is more than 0.
– POS Return (Return products from POS Interface – Recent development)
Recently we have developed new feature that applies Fiscal Position based on customer selection.
In below screen, we have created a fiscal position and replacement tax also.
Now in one product “2L Evian” we have selected that tax.
Now we will assign this Fiscal Position to particular customer. So once this customer is selected in order, it will apply on the products.
Now if we check this fiscal position applied on Sales Order, the we have following total and tax applied on order.
Again, in below screen if we take same customer and product in POS, then we will have same amount in the order line.
So this way Fiscal Position is working for OpenERP Point of Sale.





































































































