ERP | OpenERP Implementations

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:

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 and OpenERP announced the release of an ecommerce module which integrates eBay with OpenERP. The OpenERP 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, OpenERP further consolidates its position as a leading open source web based ERP and a solid alternative to expensive 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 OpenERP eBay connecter

1. Product and order Import: Import all the products and orders from eBay into OpenERP.
2. Inventory Synch: 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 is a complete web based ERP solution for Small and Midsized Enterprises, with more than 500+ modules available including CRM, BPM, etc. OpenERP also provide you with customizable reports, Dashboards and other utilities such as barcode tracking, inventory tracking, inventory management, fleet management, etc.

Bista Solutions
www.BistaSolutions.com

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

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

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

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.

The newly created custom report

The report can also be shown as a Graph

There are many companies or people who feel more comfortable with excel file format. 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.

You can see a demo of the Printscreen functionality here

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 $@
————————————-

openerp reports

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.

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

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

How to set up OpenERP for different Time Zones

Click on the “Preferences” tab

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