Friday, June 15, 2012

Manage Annual Maintenance Contracts (AMC) with OpenERP

Contract Management

  1. AMC for products or customers
  2. Response time setup
  3. Multiple products per contract
  4. Reminders for renewal of contracts
  1.      In the following sceenshot you can see list of the contracts for different partners.


2.   Here is the form view of the contract management
We have created a contract here for maintenance of the products provided for different partners in different cities in India.
In the contract lines you can add the products in the contract with response time.
Also we have provided a reminder so that a mail will be sent to the customer to renew the    
contract before the end date.


3.  You can send  a mail using this Contract Created Mail Form wizard.

Friday, June 8, 2012

Business Intelligence For OpenERP Using Jasper Dashboards

Alway's We heard that Customer's would like to see dashboards in CRM.  Pragmatic provided easy solution which integrate OpenERP – Jasper reports in CRM.

We have Developed OpenERP Sales CRM module with Jasper Dashboards which provides Analytical view to the Sale's CRM data, using this data managers or sales user can take corrective action when required.

OpenERP Sales CRM Dashboard offers significant new and enhanced features that can increase effectiveness and productivity in your sales team and organization.Using Jasper dashboards Reporting mangers can understand   sales funnel's effectiveness and sales representatives performance. 

CRM Business Intelligence Using Jasper Reports


OpenERP Sales CRM Module - :
  •    Sales CRM track all details of Leads, Opportunities & Sales Funnel.
  •    Create User Hierarchy ( Management - Reporting manager – Sales           Representative)
  •    Provide Access rights as per users and groups.
Using Jasper dashboards we can analysed -:
  •    Target by Users/Sales team- Yearly, Monthly, Quarterly & half yearly.
  •    Estimated and achieved target by users and sales Teams.
  •    Booking revenue by Individual and Sales teams can be analysed.
  •    Sales Funnel – Region, Solution & Sales person wise.
  •    Monthly Lead generation details
  •    Opportunity Won percentage.
  •    Key Performance indicators
  •    Contribution of top orders
OpenERP Sales CRM Connect with Jasper Dashboards -:
  •   OpenERP – Sales CRM data integrated with Jasper Dashboards
  •   Developed module connects OpenERP and Jasper dashboards
  •   We can export user's to Jasper server.
  •   Once we login into openERP we do not need to login by user into Jasper.
Below are some screenshots of OpenERP Sales CRM – Jasper Dashboards :  

 1)Target by users and sales Team – Provides users estimated and achieved target details



2)Leads Generation dashboards – provides Userwise leads generation details and percentage of won.   


3)Stage wise dashboard

4)Sub category dashboard :

Using above dashbaords Salespeople are motivated to accurately update their opportunity data in the system so they don’t run the risk of being called out for missing or inaccurate data.

Deploying OpenERP with Chef

What is Chef -
Chef is an open-source systems integration framework built specifically for automating the cloud.
With Chef, you write abstract definitions as source code to describe how you want each part of your infrastructure to be built, and then apply those descriptions to individual servers.
The result is a fully automated infrastructure: when a new server comes on line, the only thing you have to do is tell Chef what role it should play in your architecture.
Chef is a systems integration framework, built to bring the benefits of configuration management to your entire infrastructure. 

With Chef, you can: 
  • Manage your servers by writing code, not by running commands. (via Cookbooks) 
  • Integrate tightly with your applications, databases, LDAP directories, and more. (via Libraries) 
  • Easily configure applications that require knowledge about your entire infrastructure ("What systems are running my application?" "What is the current master database server?") (via Search) 
  • Create perfect clones of QA environments , pre-production environments, partner preview environments and more. (via Environments
Once automated, you hold a blueprint for your infrastructure, enabling you to build, or rebuild, automatically in minutes or hoursnot weeks or months. Better still, when you take those environments live and reality intrudes - which, trust us, it will - Chef gives you endless flexibility to adapt on the fly. 
Install Openerp on new server  
We have to first migrate the required files on the target server by using following command 

knife prepare ubuntu@ip
We have created Chef  for automatic installation of  OpenERP and Postgesql. In this chef, we are going to download all modules form the OpenERP Website with latest version, for now we are using  OpenERP 6.0.4  version.
Fristly We install all the Python dependencies for OpenERP by writing recipes in the cookbooks,
Python modules required.
  1. python-psycopg2
  2. python-lxml
  3. python-dateutil
  4. python-cherrypy
  5. python-formencode
  6. python-pydot
  7. python-setuptools
  8. python-lxml
  9. python-mako
Then we are going for the Postgresql installation,
For installing Postgresql 9.1 we have written recipes and with this it also created userUbuntuin your postgresql.
We fetch OpenERP source form launchpad and install that on the server
If you have own branch or any other version control you can pull the code from there.
Once this installations finishes, we are going to make services for the OpenERP in the /etc/init.d/ by the coping files openerp-server.sh and openerp-web.sh.
Here is how recipe look like
#
# Cookbook Name:: OpenERP server
# Recipe:: default
#
# Copyright 2012, Pragmatic TechSoft
#
# All rights reserved - Do Not Redistribute
#
#########################################
#
#                    recipes for the postgresql
#
#########################################
package "postgresql"
service "postgresql" do
supports [:status]
action  :start
end