Web Based Software – Bright Future

web based software

Web based applications or internet based software have grown from past years over traditional desktop based application which needs to be installed on every computer. Web based software is now becoming the future of software industry since it allows you with lots of advantages which we will be covering in this post. We all are using web based applications some of the examples are google documents or any other email applications which can be opened with the help of internet using browser.

Although from past years we have seen that many web based applications are emerging in the industry another good example of web based software is CRM software where a salesman can use it anywhere to enter the leads and prospect customer contact. Also many web based software allows you with an option where you can access it locally by installing on your personal computer incase of internet connectivity is not available. Gaining powerful popularity web based software is leading the market by replacing the traditional software installation and also it allows you with cost effectiveness specifically for small businesses.

Some of the advantages of using web based software or why web based software are the future of software industry:

No Installation :

Web based software does not require to install anything on your computer which helps you to freed up disk space, and there is nothing to download or updates you need to do since everything is installed on the main server.

With the help of Browser you can start the application quickly with internet and can get real time data and reports. Time is less consumed since there are no tricky steps towards the installation of the tool.

Mobility and Movement:

With web based software you can move anywhere without worrying about filling the information or data into the tool since you need only internet to start the application. There are some applications and software in the market which can also support Mobile so that in case of emergencies you can log on from mobile to run the show.

Cost Effectiveness :

As compared to traditional software web based application are considered as cost effective tools since an individual or less people can also purchase the licenses. Unlike in traditional software implementation where you have to wait for implementation and the high cost even if there is few users in your organization.

Apart from that there are many other advantages of web based software which clearly indicated that the future is bright in the industry such as you don’t need specialized IT team to handle the software, No specialized servers or staffs towards the implementation of the software. You get quick assistance from the vendor incase of any queries you come up with.

Have any questions about web-based software or interested in business software implementation? Get in touch today.

ProcessMaker New version 2.0.40

One of the leading open source BPM and workflow management – ProcessMaker released its new version 2.0.40. The new version some with new features & improvements. Some of them are listed below – source of this material is here – Link

Features:

The Administrator can define Languages, timezone and memory limit.

New installation interface and much more. . .

Some of the improvements include fixed bugs, calendar administration interface improvement Read complete detail about bug fixtures and improvements on this link

Bista Solutions Releases eBay Integration Module With Odoo OpenERP

Odoo ERP with Ebay

Bista Solutions and Odoo announced the release of an ecommerce module which integrates eBay with Odoo OpenERP. The Odoo eBay connector was developed by Bista Solutions over a period of two years. Bista Solutions developed this connector while working with several leading eBay sellers. With the addition of this eBay connector, Odoo further consolidates its position as a leading open source web based ERP and a solid alternative to ERP such as NetSuite and SAP.

Key Benefits

  • A single, integrated business application that ties your business together across ecommerce, CRM, marketing, order management, inventory, manufacturing and accounting
  • A single system that merges your online and brick-and-mortar operations to manage your entire business in real time
  • Manage one or more web stores and conduct ecommerce in different countries, languages, currencies and channels

Some features of Odoo OpenERP eBay connector

  1. Product and order Import: Import all the products and orders from eBay into OpenERP.
  2. Inventory Sync: Synchronize your inventories and stock level on eBay stores from OpenERP.
  3. Update order status: Update status of your orders from OpenERP to eBay store with tracking number.
  4. List products to eBay from OpenERP: List all your product images, Catalogue search using different templates.
  5. Re List Products: Manage auctions including listing and relisting of your products with respect to the expired date and time.
  6. Product Schedule Management: Schedule listing of products based on your requirements.
  7. Product Status Update: Manage your products descriptions, images, attributes, title, etc. in OpenERP.
  8. Analytics: Receive advanced Business Intelligence for your eBay stores and combine them with information with other channels.
  9. High Volume Processing: Integrate with scanners and process batch printing of labels, picking & packing lists for processing large volumes of orders.

Bista Solutions is a leading OpenERP partner with many successful implementations in ecommerce and manufacturing. For information regarding implementing, integrating, customizing and migrating OpenERP please contact us on sales@BistaSolutions.com.

Click here to check video of eBay integration with OpenERP

About Bista Solutions:

Bista Solutions is a dynamic software company providing world-class business solutions to a wide range of enterprises. Bista Solutions has offices in US & Canada with a development center in India. The company has many years of expertise in analyzing the requirements of businesses and developing applications to meet their business needs.

About OpenERP:

OpenERP / Odoo is a complete web based ERP solution for Small and Midsized Enterprises, with more than 500+ modules available including CRM, BPM, etc. OpenERP also provides you with customizable reports, Dashboards and other utilities such as barcode tracking, inventory tracking, inventory management, fleet management, etc.

Bista Solutions
www.BistaSolutions.com

To know more about this you can watch our video below. If you would like to implement this for your business, please send us a message or give us a call at 404-631-6219 (full list of international numbers here).

How to create Ad-Hoc reports in Odoo

A number of times clients ask us whether OpenERP has the capability to make Adhoc reports. It is very important for the client to have access to information which has been entered into the ERP and view it from a particular perspective. The base_report_creator module can be used to create powerful Adhoc reports, though it requires some level of technical expertise from the user to create the report – they should know the Object in the ERP, how they are interlinked and the fields etc.

The base_report_creator module which can be used for Adhoc reports
null

The new option called “Custom Reports” which is created by this module

Odoo ERP Software

Creating a new custom report by selecting the objects whose data need to be part of the report. Also a Menu option to access this custom report can be created from this page
ERP Software System

Specifying the fields which need to be displayed in the custom report and how to group them and whether to show them on the graph.
Open source ERP

The newly created custom report
ERP Software for Business

The report can also be shown as a Graph
Odoo ERP Software

How to generate Reports in Excel, Word & pdf format from Odoo

There are many companies or people who feel more comfortable with excel file format. Odoo (OpenERP) allows you to export the reports in Excel, word or pdf format/

Whenever we create the report in RML it just outputs in pdf. Hence further processing on the generated reports and the pdf version is just not enough.

There are 2 ways to generate report which can be exported to Excel / Word formats.
1. Using Jasper Reports
2. Using Aeroo Reports.

The advantage with Aeroo report is that it has a cool “Printscreen” functionality with which you can export any list view into Excel. Even the Analytic reports like “Sales Analysis”, “Leads Analysis” etc can be exported to Excel format. This is very powerful for the Clients, in case they want to run additional analysis using Excel Pivot tables.

The modules “report_aeroo”, “report_aeroo_ooo” and “report_aeroo_printscreen” are required for this functionality to work. Also it uses Open Office to generate the Excel/Word report, so OpenOffice has to be installed and running as a service for this to work.

This link has the details of how to install and setup OpenOffice as a service. I just had to run OpenOffice using the following command “/usr/lib/openoffice.org3/program/soffice “-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager” -nologo -headless -nofirststartwizard”

The following are the details of my /usr/bin/openerp-server
————————————-
#!/bin/sh
export PYTHONPATH=”/usr/lib/openoffice.org/basis3.1/program/” #change this to your OOo path!!!
cd /usr/lib/python2.6/site-packages/openerp-server
exec /usr/bin/python ./openerp-server.py $@
————————————-

See below from how the Aeroo Report, Printscreen report is configured. The reports which you define can also be setup to output in Excel by using a similar setting.

If you’re interested in implementing Odoo or have any questions, get in touch! You can reach us using our contact form or at sales@bistasolutions.com.

How to set up OpenERP for different Time Zones

How to set up OpenERP for various timezone kindly follow the following steps to select timezone in OpenERP:

How to set up OpenERP for different Time Zones
How to set up OpenERP for different Time Zones

Click on the “Edit Preferences” wheel at top right corner

How to set up OpenERP for different Time Zones
How to set up OpenERP for different Time Zones

Click on the “Preferences” tab

Select the timezone from drop down menu
How to set up OpenERP for different Time Zones

Select the timezone from Drop Down Menu

Following code will be working for “GMT-x” time zones. Mostly US based.

FMT = ”%Y-%m-%d %H:%M:%S” #Time Format
#########################Timezone Logic########################
timezone_time = self.pool.get(”res.users”).browse(cr,uid,uid).context_tz #Timezone selected in OpenERP
now_utc = datetime.now(timezone(”UTC”)) #fetching UTC time
now_utc1 = str(now_utc)[:19] #Truncating time only
now_tm = datetime.now() #system time
current_now = str(now_tm)[:19] #Truncating system time only
if timezone_time:
current_timezone = now_utc.astimezone(timezone(timezone_time)) #getting the time of selected timezone
current_timezone = str(current_timezone)[:19] #Truncating timezone time only
else:
current_timezone = current_now #Current time
###############################################################

#Difference between the UTC and Timezone time
UTC_timezn = datetime.strptime(now_utc1, FMT) – datetime.strptime(current_timezone, FMT)

#Difference between the Current and Timezone time
currnt_timezn = datetime.strptime(current_now, FMT) – datetime.strptime(current_timezone, FMT)

openerp_selected_tm = self.browse(cr,uid,ids[0]).last_ebay_order_import_date #getting user selected time from OpenERP

currentTimeFrom = datetime.strptime(openerp_selected_tm, FMT) – currnt_timezn #Subtracting the currnt_timezn from user selected time

Final_time = currentTimeFrom + UTC_timezn #Final time by adding UTC_timezn

How to use Average Price Formula in OpenERP

Below is the method of calculating the Average Pricing in OpenERP

Formula

NP = (AP * QS + PP * QP) / (QS + QP)

Example: NP = [AP(13.42)*QS(733)+PP(15)*QP(10)] / [QS(733)+QP(10)]

NP = 13.44

Abbreviations:

  • NP (New Price): New Average Price once product have been received in the warehouse.
  • AP (Average Price): Old Average Price before product received in the warehouse.
  • QS (Quantity Stock): Quantity stock before product received in the warehouse.
  • PP (Purchased Price): Purchase Price(Unit Price) in Purchase order.
  • QP (Quantity Purchased): New Quantity received in Purchase order.

How to Run OpenERP 6.1 on custom ports

To run OpenERP 6.1 simultaneously with our existing OpenERP installation, we need to specify different ports for XML-RPC. Here”s the Command to run OpenERP 6.1 from source with custom port option(Run this command from OpenERP6.1 source folder):

#su OpenERP -c “python OpenERP-server –xmlrpc-port 8089 –xmlrpcs-port 8091 –netrpc-port 8090″

Below image shows the port definition in Debug configuration of the eclipse!

open source ERP
OpenERP custom ports on eclipse

The Advantages of using Linux Operating system

Linux is one of the widely used Open source operating system assembled under the model of free and open source software development and distributions. Linux kernel and operating system first released on October 5 1991 by Linus Torvalds is one of the defining components of any Linux system.

There are different operating systems available which we use daily but here i will provide you with some of the best reasons where Linux installation on a machine is better as compare to other operating system specifically for those who are new to computer world.

1: Viruses/malware

Viruses and malware can attack your PC anytime and this is one of the most important reasons why you can select Linux. As on Linux operating system the concern of viruses attack become zero. Therefore purchasing of virus protection software cost is waived off after using Linux.

2: Security

Being Open source in nature Linux provide you with good security in your Operating system. Incase any virus released in Linux operating system you will get quick patches released either on the same day or next day. This normally doesn’t happen if you use any other operating system.

3: Cost effectiveness

Another reason for being open source is the cost effectiveness as other operating system requires licensing towards the installation. Say for eg: Microsoft licenses are only allowed on a single computer whereas Linux can be distributed to any number of computers without spending single penny.

4: Freedom

With Linux advantage you have freedom to control every part of your operating system. Again Linux provides you with freedom of licences and control over desktop look and feel.

To know more in details contact us today.

How CRM software can help your organization

Previously we have discussed that Customer relationship management (CRM) software or Lead management software is very important for an organization who is into either products or service selling. A lead management or client management is very necessary in today cut throat completion to make powerful client base for a business. A small business CRM can help in achieving this because it allows you to have customer information with the previous records of their activity in the CRM software which make quick and easy to access as and when required.

Again with the help of advance CRM software available where the communication can be shared in group for eg: A is constantly communicating keeping loop with B. negotiation with customer C and incase A is not available, B can handle the client easily which helps in customer relationship.

Today pace in selling or in business is necessary as keeping the customer on hold may loose customer interest, Henceforth with a use of customer relationship management software you can pace up your sales, lead management, customer management, marketing automation etc. With few clicks you get all the history of the customer you are looking out for wasting your time on going through papers and other stuff. If you have history of your customer purchase and transactions it becomes easy when re-ordering happens.

Hence with the above one can say CRM software can help in different sales and marketing areas of an organization. A CRM application is helpful not only organization/sales perspective but it can help the customer also which dealing with your organization.