Tuesday, June 25, 2013

Odoo OpenERP 7 Payment Gateway Integration Authorize.net

                          OpenERP has provided wide range of applications like CRM,sales,accounting,Hr and so on . OpenERP has its own method of payment handling in this blog we will see how we can integrate OpenERP with Authorize.net payment gateway to handle online payment method. Through this integration user can see all his OpenERP transaction which is paid through online payment using Authorize.net in their Authorize.net account.

 Let see how it works:

1.Create Invoice either Customer or Supplier Invoice in OpenERP and Validate it.

2. After that fill up Payment Details for Invoice and Pay invoice.

3. Go to Customer Payment and Open Respective Payment for Paid Invoice and click on Authorize button. OpenERP then sends predefined customer credit card information ( or you can specify it before sending it )to Authorize.net for verification.

4. If details sent to Authorize.net is valid OpenERP get verification message and transaction id from Authorize.net.

5. You can loged into your Authorize.net account and Search for Transaction Id you get in OpenERP which is new transaction record created for your OpenERP payment.

6.Open that record and you will get transaction details which is sent from OpenERP.

7. You will also get email as follows from Authorize.net after successful transaction

From: Authorize.Net Auto-Receipt
Date: Wed, Jun 12, 2013 at 7:43 PM 
Subject: Merchant Email Receipt
To: ******************

========= SECURITY STATEMENT ========== 
It is not recommended that you ship product(s) or otherwise grant services relying solely upon this e-mail receipt.
========= GENERAL INFORMATION ========= 
Merchant : ******************
Date/Time : 12-Jun-2013 7:13:47 PDT
========= ORDER INFORMATION ========= 
Invoice :
Description : 
Amount : 100.00 (USD) 
Payment Method : American Express
Type : Authorization Only
============== RESULTS ============== 
Response : This transaction has been approved.
Authorization Code : BBCD9A
Transaction ID : 2194361572
Address Verification : Street Address: Match -- First 5 Digits of Zip: Match

Customer ID : 
First Name : Adam
Last Name : Smith
Company : Demo Address : West Street 
City : NY 
State/Province : NY
Zip/Postal Code : 4556256
Country : USA 
Phone : 123456
Fax : 123456
E-Mail : demo@example.com
Tax : 10.0
Duty : 0.0.
Freight : 0.0
Tax Exempt : 0.0 
 PO Number :PO-00-011

This flow of payment through Authorize.net can be change according to requirement.  

Wednesday, June 19, 2013

Odoo OpenERP 7 Fleet & Route Management

                    A comprehensive web-based Fleet Management System module for OpenERP (FMS) is developed for fulfilling the business management needs of the Fleet & Transport industry. Its well Integrated & Modular architecture makes it apt for effective running of the Fleet & Transport business.
                     OpenERP's Fleet Management System integrates different functions in a transport company such as accounts, inventory, payroll, invoicing, insurance, asset management, vehicle maintainence, driver details, etc. Further, the system has a scope for customization according to client specific needs.

Key Features of OpenERP Fleet Management System 

1) Maintainence of Fleet history including all the relevant details of the Fleet like Model No., Engine Volume, Seats, License Plate, Fuel Type, Registration details, etc.
2) Maintains a complete record of the Driver details like Name, Driving License, etc.
3) Maintainence of Insurance Details.
4) CMMS (Computerized Maintainence Mangement System) for recording & analyzing various maintainence activities of the Vehicle.
5) Management of Fleet Maintainence Contracts including the Fleet Maintainence, Quotation, Fleet Maintainence Orders & its Invoicing.
6) Fuel Tracking which would help in monitoring of Fuel consumption.
7) Odometer Statements specific to the vehicles.
8) Configurable Master Data including Vehicles, Service Templates, Service Tasks, Insurances, Fuel Type, Driving Licences, etc.
9) Accounting Module to meet all the financial & billing needs of the company. Its closely integrated with all other modules.
10) Sales Module to manage all the sales transactions of the company.
11) Purchase Module to manage all the purchase transactions of the company.
12) Warehouse Module to manage all the Inventories & Warehouse requirements of the company.
13) Provision to generate the Work Orders for maintainence of the equipments & assigning the Spare parts required.

Variety of Customizable Reports like 

a) Vehicle Reports.
b) Fuel Consumption Reports.
c) Driver Reports.
d) Fleet Maintainence Reports.
e) Odometer Statement Reports.
f) Financial Statement Reports like P/L(Profit & Loss statement), Balance Sheet, General Ledger, Trial Balance.
e) Invoice Reports. & many more such type of reports.
Asset Management Module for managing all the Current & Fixed assets of the Company. 


Tuesday, June 11, 2013

Odoo OpenERP 7 SaaSKit

Pragmatic Techsoft’s SaaS Kit for OpenERP 7.0 – Architecture and Functionality

SaaS Overview
                        Software as a Service solutions deliver applications to users from a central location. There are two typical approaches to SaaS. In the hosted application model, which is similar to the concept of application virtualization, a provider hosts the application on a server and allows users to access the application across a network. The on-demand SaaS model gives users access to an application as needed, and users pay for the time they use it. Regardless of the approach, a SaaS application represents a single deployment that administrators can patch and upgrade at a single point. 
Pragmatic’s Presence
                       Pragmatic is a leading state of art application service provider (ASPs) with cutting edge and customized open source applications. We are forerunners in implementing SaaS model for openERP and also provide platform for our clients to leverage on the SaaS model by providing the SaaS Kit and PaaS. We also specialize in on premise Cloud that makes it is possible for customers to host their own applications in-house.

SaaSKit Architecture

Home Page is where the users both the SaaS vendor and the end user interact on purchase of various Products/ Verticals. 

Magento Store
Magento Store: Is more like a market place where the SaaS vendor displays the products available on SaaS Platform  

Magento Admin:  To add and configure products, we explain the Admin option by taking an example of various openERP modules/ verticals that are available on SaaS model for sale.

Module:Sales, Purchase, Accounts etc..

Verticals:  Manufacturing, Construction, Etc

Products:  Package of Modules + Verticals.

Registers the customer with details like Shipping address, company name, contact details. At registeration the customer is given an option to select

Magento Store gives two options
 Paid instance
 Free Trial 

Paid Instance:  
                     The customer selects the paid option to use the products of their choice in SaaS model. 

Free Trial:  
                    A Free trial of 30days option is given to test the waters with the products of choice (full functionality) to understand the SaaS model. 

Instance Name Creation:  
                    In both the cases where the user selects to use a Paid/ Free Trial the system prompts to create an instance based on customer preference. The structure and details are given herewith in details. 

 SaaS Kit Data Structure Model  
                    New DB Created for each customer based on their choice  

 Naming convention  
                    Asks user to give a preferred name for future access – Sample:                       user_given_instancename.domainname.com                     
                    Background verification for uniqueness of the named instance       
                    Unique name for each DB is confirmed                       
                    DB name format: user_given_instancename.domainname                      
                    Auto creation of a new Postgres DB                       
                    Mail is send with link custDB.domain.com                     
                    Also is mailed the Credentials for login – Admin User.       
                    Customer login - with restriction on users administered during openERP usage. 

                     To Migrate Customers, SO, Products to openERP 

Open ERP 7.0  
                     SO Confirmation done manually – Paypal etc to receive payment and admin manually confirms the SO in OpenERP. 
                       This triggers the autocreation of the DB   

Master DB - Postgres  
 The Master DB maintains all configuration and maintenance of all SaaS instances by managing the following.  
                  Master DB – Admin details for all SaaS instances.
                  Customer created details are kept under secure instances
                  Confirm SO, payments, receivables, usage period
                  User licenses/ Cust logins
                  DB Expiry - Alerts, Grace period
                  Upgrade option                    

Confirm SO
Free Trial Period      
                  Free/ Trial period – 30Days
                  COD - 30 days  

Upgrade option –
                  From free trial to paid,
                  Add new modules to existing accounts
 Extension –
                  Extension of paid instances 

User licenses/ Customer management
DB Expiry - Alerts, Grace period 

Invoice - Payment gateway - manual. Paypal make transactions and pass entry in openERP

Some of our Customers Using SaasKit
Suncard logo, Officemanager logo