What’s New in Odoo 9?

Odoo 9 New Features

Here are the exclusive features of Odoo 9 Community and Enterprise Version:-

WEBSITE BUILDER

Untitled

  • New WYSIWYG Editor
  • Versioning
  • New Building Blocks
  • Easy Form Builder
  • Latest Customization Tools
  • Alpha Beta Testing
  • Support for Multi-Website

THEMES

Untitled

  • Ready-to-use Website Themes
  • Customizable Modules
  • Drag & Drop Building Blocks
  • Dynamic features
  • Inbuilt Blogs & eCommerce Options
  • New App Themes Store

E-COMMERCE

Untitled

  • Customer Portal Management
  • Allows Digital Products such as publications, and code.
  • New Payment Gateway Integration options
  • New Shipping Integration facilities such as UPS, USPS, FedEx, and DHL
  • Integration with leading eCommerce Portals eBay and Amazon

SUBSCRIPTIONS MANAGEMENT

Untitled

  • Plans
  • Automated Monthly Recurring Bills
  • Options to Setup Subscription Fees
  • Customer Management
  • Setup KPIs and Customizable Dashboard

CONTRACTS MANAGEMENT

Untitled

  • Latest Contract Management
  • Recurring Contracts Management
  • Fixed Price Management
  • Time & Material-Based Module

NEW DESIGN

Untitled

  • Clean Interface & Easier to navigate
  • Rapid Fast
  • 100% Responsive and Supports Mobile in ISO/ Android
  • Simple filters & groups
  • Fantastic Dashboards

MOBILE APPLICATIONS

Untitled

  • All Apps – 100% Responsive
  • Supports IPhone & Android
  • Adapted views
  • Interface with Phone

ODOO SIGN

Untitled

  • Drag & Drop of Facilities
  • Option for PDF Preview
  • Templates Management
  • Supports Multiple Roles
  • Public Sharing

PROJECT MANAGEMENT

Untitled

  • Customizable Module
  • Forecasting Feature
  • Updated Timesheets on Tasks

TIMESHEETS

Untitled

  • Mobile App for Timesheet Management
  • Chrome Plugin
  • Super-Fast
  • GTD Planning & Statistics
  • Work in Disconnected

INVOICING & PAYMENTS

Untitled

  • Send by Regular Mail
  • 24.000 Banks Synchro
  • SEPA Payments
  • OFX, QIF, CSV, CODA Import
  • Check Printing
  • Batch Deposit
  • Follow-Ups
  • Multi-Companies

NEW ACCOUNTING

Untitled

  • Amazing Dashboards
  • Awesome Reports
  • Improved Reconciliation
  • Smart Fiscal Year Closing
  • Simplified Configuration
  • Revised Assets
  • Export to Excel

VoIP INTEGRATION

Untitled

  • Plan Calls
  • Auto-popup
  • Dial Queue
  • Reschedule a Call
  • Send Email
  • Customer & Opportunity

MASS MAILS

Untitled

  • New WYSIWYG Editor
  • No front/back switch
  • Open / Delivered stats
  • Link Tracker

LINKS & TRACKING

Untitled

  • Marketing Campaigns
  • URL Shortener Tool
  • Smart UTM Tracking
  • From Visit to Revenue

POINT OF SALES

Untitled

  • Restaurant
  • Customer Management
  • Kitchen printer
  • Barcode Compatibility

IMPROVED WMS

  • Unified interface
  • Shippers integration
  • Better returns Management

If you’d like to learn more about the differences between Odoo 9 Community and Odoo 9 Enterprise, click here.

If you’d like to learn more about our Odoo implementation services, click here.

Finally, if you’d like to get in touch, you can reach us at +1 (858) 401 2332 or by using our contact form.

Overview of “NoSql” in BigData

  • by bista-admin
  • Oct 26, 2015
  • 0
  • Category:

In this digital world, data is growing very fast and has become more complex in terms of volume, variety, and velocity in nature. Today, the world needs databases to be able to store and process big data effectively. There is a demand for high performance while reading and writing operations are executed. This affects large-scale and high-concurrency applications, such as search engines, Facebook, and Amazon hence the traditional database limits itself to such complex requirements, therefore various types of non-relational databases that are commonly referred to as NoSQL (Not only structured query language) databases. Their primary advantage is they handle unstructured data. ACID is not the major concern, NoSQL uses BASE instead which works on eventual consistency.

BigData title=

What is ACID and BASE in term of NoSQL?

The RDBMS strongly follows the ACID (Atomicity, Consistency, Isolation, and Durability) properties; on the other hand, NoSQL databases follow BASE (Basically Available, Soft State, eventual consistency) principles.

Characteristics of NoSQL:

Elastic scaling: In NoSQL, new nodes can be added or removed from the data layer without application interruption.

Bigger Data Handling Capability: Because of its elastic nature of handling, Big Data becomes easier with better performance.

Lesser Server Cost: RDBMS relies on expensive proprietary servers and storage systems whereas NoSQL databases use clusters of cheap commodity servers which reduces the cost per gigabyte in NoSQL.

No Schema or Fixed Data model: NoSQL does not require a rigid database schema to be defined. Here, the data can be inserted into the database without first defining a database schema. It also allows a changed format or data model, without application disruption. This provides flexibility in NoSQL.

Integrated Caching Facility: to increase data output and performance, NoSQL stores cache data in system memory.

Handling relational data:

NoSQL databases cannot handle joins in queries. Hence, to handle relational data, the database schema needs to be designed differently. Three main techniques for handling relational data in a NoSQL database are as follows:- 

• Multiple queries: Instead of retrieving the data with one query, one can use several queries to get the desired data. NoSQL queries are comparatively faster than SQL queries.

• Caching/replication/non-normalized data: In this approach, it stores actual foreign values instead of storing foreign keys in the model’s data.

For example, Each blog comment includes the username instead of the user id, this provides easy access to the username without another lookup. Whenever you change a username, this will be updated in many places in the database itself. Hence, this approach works better when read operations are less than write operations.

• Nesting data: In MongoDB, it is possible to put more data in a smaller number of collections.
For example: In a blogging application, storing comments within the blog post is recommended so that with a single retrieval you get all the comments. Thus, this approach stores all the related data in a single document.

NoSQL over RDBMS in the below areas:

● It supports semi-structured data and volatile data.
● It supports flexibility in the schema.
● Read/Write operations have very high throughput.
● Horizontal scalability is achieved.
● It supports Big Data in Terabytes/Petabytes.
● It also supports Analytic tools on top of Big Data.
● No need for expensive hardware machines.
● Memory caching increases the performance of queries.

To learn more about big data for your business, you can contact us at +1 (858) 401 2332 or by using our contact form.

Bista Implemented Odoo for well-known Education Organization in the US

Odoo Implementation

Client Profile

(IUG) Interpreters Unlimited group is an US based leading Event Management Company.

They offer services for the live events including:

  • On-site Interpretation
  • Telephone Interpretation
  • Document Translation
  • Transportations
  • Language Translation
  • Language Interpretation 

IUG is serving the industries for over 45 years and with this experience they stand as the oldest language service providers in the world.

Business Needs

IUG was using multiple software systems for various business activities such as accounting and payroll, Task management and Timesheet, CRM etc. They were looking for an integrated system which can allow them to take the entire requirement into one system. This would help them to minimize the system cost and improve the coordination between teams.

Key Implementation

After understanding the Business requirements, Bista Suggested Open Source ERP (Odoo) as a platform which will take all the business needs together. 

Bista Implemented Below ERP Modules

  • CRM
  • Event Management
  • Project Management & Task Management
  • Accounting
  • Document Management
  • Customer Portal
  • Vendor Portal

Replaced with 

  • Quick Books
  • IUX Application 

Customized Implementations

Some of the Business needs where unique, there was no default module available in the ERP, Bista’s professional team has customized and redesigned system according to IUG Business needs

Below are some of the Customized Implementations

Key Integrations

  • Google Map Integration with Odoo

The Maps feature helps the customer service executive to efficiently find the nearest Interpreter/Transporter for the event and also guide Interpreter with the direction and distance of the event. 

  • Mobile App Integration

An IOS/Android App is developed for the quick access of the IUG services, The ERP application designed by Bista is integrated with the Mobile App to provide customers with the real-time updates and best user experience. 

  • Customer/ Interpreter Portal Integration with Odoo interface

Bista has implemented customer / interpreter portal with lot of customization as per IUG’s Business need. 

  • Fax Integration with ERP System

We also implemented an integrated system wherein the application interacts with the fax to send and receive faxes through the Interfax one of the leading providers for online faxes in USA. 

  • Data Migration from legacy system to new advance Odoo.

Bista has also successful migrated the complete Business data of IUG dated back to January 2006 from their legacy system IUX and QuickBooks. 

  • EDI Implementation

By using electronic data transfer method, we have successfully implemented the claims processing for the medical industry. With this implementation IUG has become a vendor of Amerisys, a billion dollar company for processing and providing services for all claims submitted by Amerisys. IUG provides service for the claims and sends a bill to Amerisys in an encrypted 837P format, a standard format in US for processing profession medical claims. With this it became easy for IUG to automatically process the customers insurance claiming process. 

  • Customized Reporting Dashboards

Bista has implemented the customized reporting dashboard for various levels of user groups like for Operations, Accounting and Management Dashboards. These Dashboards provide a very intuitive UI (User Interface) with the consolidated reports on various data and present it to the users. Also, in Dashboard we have provided graphical representation like, Bar Graph, Line Graph and Pie Charts for better UI presentation to the Users. 

What was the Impact on Client Business after Project Implementation? (Benefits)

The ERP Implementation done by Bista Solutions helped IUG in number of ways, such as, 

  • Cost Effective
  • Integrated System
  • Saves Time & Efforts
  • Organized and allied work experience
  • High-end professional services company

Client Testimonial

“Bista’s team was very responsive and provided good cordial customer service. They spent around 4 to 6 months on site for understanding our business. Their post launch service was excellent; they provided us support during California business hours.”

– Mr. Sayed Ali, President of Interpreters Unlimited Group

Tableau Keyboard Shortcuts

Here are Few Amazing Tableau Keyboard Shortcuts :

 

Tableau Keyboard Shortcuts

Navigation and Selection Shortcuts

In addition to the standard keyboard shortcuts there are several key combinations that can make navigating and selecting marks fast and easy.

Description Keyboard/Mouse Action
Windows Mac
Selects the mark Click Click
Selects a group of marks Drag Drag
Adds individual marks to the selection Ctrl+Click Command-Click
Adds a group of marks to the selection Ctrl+Drag Command-Drag
Pans around the view Shift+Drag Shift-Drag
Zooms in to a point in the view (requires zoom mode if not map) Double-click , Ctrl+Shift+Click Double-click , Shift-Command-Click
Zooms out from a point on a map (requires zoom mode if not map) Ctrl+Shift+Alt+Click Shift-Option-Command-Click
Zooms out Shift+Double-click Shift–Double-click
Zooms in to an area in the view (requires zoom mode if not map) Ctrl+Shift+Drag Shift-Command-Drag
Zooms in and out on a map Scroll Scroll
Drags a row and scrolls through a long list simultaneously Click+Drag to bottom of pane+Hold Click-Scroll, Command-Hold

Field Selection Shortcuts

There are several key and mouse combinations that can make creating a view and selecting fields fast and easy.

Description Keyboard/Mouse Action
Windows Mac
Opens the Drop Field menu Right-click+Drag to shelf Option-Drag to shelf
Copies a field in the view to be placed on another shelf or card Ctrl+Drag Command-Drag
Adds a field to the view Double-click Double-click

 

If you’d like to implement Tableau for your business, reach out to us at sales@bistasolutions.com or give us a call at +1 (404) 631 6219.

Tableau – Quick Tips & Tricks

Here are few Tips of Using Tableau :

Note: We have used a Sample Superstore Excel source for these examples.

TIP # 1: Right Click Drag: Quick Field Property Selection

Normally when you select a field you need to drop the Dimension, Measure or Set in first then apply the SUM, Average or alteration of Field Property. However if you want to save yourself a click, you can right click, drag a field onto a worksheet by using a right click, drag once you let go. You will be prompted with a window showing all the possible field dimensional properties or measure calculations.

Tableau-Drop-Field

 

TIP # 2: RUNNING TOTALS

Create a visualization using the Year/Month level of the Date Fields. Add the Sales measure twice, and use a Bar for one mark, and Line for the other one.

Tableau-Dashboard

To see a “running total since inception”, simply add a “Running Total”, quick table calculation to the second sales measure. Note this is a dual axis chart.

TIP # 3: Chart Types – Side-by-Side Bar Chart

To examine the side-by-side bar chart, let’s first take three rows of vertical bar charts. These represent sales volume by state and are divided into the three different departments of our fictional company.

Tableau-Graph

Third view has two primary deficiencies. First, it limits the comparison of the state-level performance within a specific department. In other words, Technology sales performance can be compared across the different states, but it is far more difficult to compare Technology to Office Supplies.

Here’s where the side-by-side bar chart really shines.

Tableau-Side-by-Side-bar

The side-by-side bar chart is a great way to compare each category in each state and department together as separate business units. Immediately, we can see that all the three departments in California are the best. Perhaps surprisingly, the fourth-best performer is Washington’s Technology department.

One can also format this chart in different ways to highlight different aspects of your data (i.e. to tell a different story). I choose to colour-code all of the product categories so that if you want to visually scan a comparison of category to category, it will be easier.

There you have it. Now with a side-by-side bar chart, we can easily compare individual department performance within each state as well as on the whole.

If you’re interested in implementing Tableau for your business, you can get in touch with us at sales@bistasolutions.com.

 

Calculating Landed Cost in Odoo

  • by bista-admin
  • Oct 09, 2015
  • 0
  • Category:

Definition of Landed cost: The total cost of a landed shipment including purchase price, freight, insurance, and other costs up to the port of destination. In some instances, it may also include the customs duties and other taxes levied on the shipment.
It is the total price of a product once it has arrived at a buyer’s door.

In Odoo (OpenERP), we by default have a landed cost module,which had some limitations, so we add the functionality which overcomes these limitations and provide you an efficient way to calculate your selling price of the product by considering all these factors.

Process:

We add these Freight, Insurance etc cost as a product and differentiate it with the normal product.

Landed-Cost-in-odoo

The Service costs specify for each landed service gets calculated on the purchase order and define as a Total Landed cost.

For our client, we split these landed cost in different category like Order Level (Which get applied on the PO Order level), Order line level (PO line level calculation), per container (Calculated based upon no. of container PO has).

Also, we add the landed cost concept on the Purchase order and pass it to the Shipment of the product level.

Calculating-Landing-Cost

In the above figure, you can see the different Landed cost service which got apply for the Purchase order. These costs are getting populated on the purchase order base upon different conditions, like for the domestic PO, there are different landed cost than that of foreign PO.

The Landed Costs Total Untaxed shows the total value of the purchase order including these landed costs.

Following figure shows the landed cost which gets applied on the purchase order level and also give you bifurcation of the order level landed cost base upon the product quantity or product weight.

Calculating-Landing-Cost

Price Unit gives you information about the unit price of these products or unit prices of the lot that is getting created after the addition of the landed cost.

Our client also had Container scenarios, like one purchase order had the more than one container on which these products are shipped.

How-to-calculate-landing-cost

Price Unit gives you information about the unit price of these products or unit prices of the lot that is getting created after the addition of the landed cost.

Our client also had Container scenarios, like one purchase order had the more than one container on which these products are shipped.

Landing-cost-calculation-in-Odoo

So, we provide additional functionality to get information about landing cost which get applied to respected container.

Same procedure of calculation of landed cost is repeated for the shipment level if required.

Landed-cost-in-Odoo

Once the new lot is created, it will have these additional landed unit prices.

For more information regarding this module, please contact on sales@bistasolutions.com.

 

Odoo FosDick Warehouse Management Connector

Odoo FosDick Warehouse Management Connector

Fosdick is the warehouse services provider who manages all the stock and shipment operations. We have created Odoo FosDick Warehouse Management Connector

  1. Submitting the orders to FosDick – iPost to submit all the delivery orders to FosDick
  2. Get the tracking information from FosDick – Use Fosdick API to retrieve the status & the tracking number of each delivery order

1. Submitting Orders to Fosdick

  • Server Name: The hostname is used to send the orders.
  • Customer Name: The customer name, specific to the company, as provided by Fosdick; is used in the URL
  • Client Code: Defines the XML parameter ‘ClientCode’.
  • AdCode: Defines the XML parameter ‘adCode’ (“TEST”)
  • Logfile: Place to log the information
  • Debug Mode: By default, we log the execution of the batches (when submitted and when received with status); in debug mode we want to log each delivery orders submitted
  • Test Mode: Defines the content of the XML parameter “test¨
  • Write to File: An option to write the XML to a files with timestamps

 

Fosdick-Connector

Submit the orders.

To submit the orders, just run the scheduler and it will submit all the Ready to Transfer Odoo ERP Orders to Fosdick.

Fosdick-scheduler

2. To track order status, you require following parameters:

● URL
● Username
● Password
● Write to file : An option to write the XML to a files with timestamps
● Span Time : Number of days of shipments to retrieve

To track the orders, configure your tracking details in configuration form and click on button ‘Fetch Tracking’. It will track all the submitted orders.

Fosdick-odoo-connector

For more details regarding this module and connector email us on sales@bistasolutions.com or call on USA: +1 (858) 401 2332 / Other Regions +91 897 609 8988

 

 

ETL, ELT & ETLT Is Now Easy with Hadoop

ETL tools are basically used to migrate data from one place to another by performing three functions:

  • Extract data from sources like ERP or CRM applications : In the extract step, data has to be collected from several source systems and in multiple file formats, like the flat files with (csv) delimiters and files with XML extensions. There may also be a need to get the data from legacy systems, which store data in formats that are understood by very few people and nobody else uses it further.
  • Transform that data into a format that matches other data in the warehouse : The transformation process includes many data manipulation steps, like moving, splitting, translating, merging, sorting, pivoting, and many more.
  • Loading the data into the data warehouse for analysis: This process can be performed through batch files or row by row, in real time.

All the above processes sound simple but take days to complete the process.

ETL Process

 

“Power of hadoop with ETL”

Hadoop brings at least two major advantages to traditional ETL:

  • Ingesting huge amounts of data without having to specify a schema on ‘Write’.

 A prime property of Hadoop is the “no schema on-write”. This implies that you don’t have to pre-define the data schema before loading data into HDFS. This holds true for both structured data (such as point-of-sale transactions, details of call records, ledger transactions, and even the call centre transactions),as well as for unstructured data (like comments from users, doctor’s notes,  descriptions on insurance claims, and web logs) and social media data (from websites like Facebook, LinkedIn and Twitter). Irrespective of whether your input data has explicit or implicit structure, one can quickly load it into HDFS, which will then be ready for downstream analytic further processing.

  • Unload the transformation of input data by parallel processing at scale.

Once the data is loaded in Hadoop you can perform the traditional ETL tasks like cleansing, aligning, normalizing and combining data by employing the massive scalability of MapReduce function. Hadoop also permits you to keep away from the transformation bottleneck in the old and typical ETLT, by unloading the ingestion, transformation, and integration of unstructured data into the data warehouse. Since Hadoop allows you to use more data types than ever before, it enriches your data warehouse which otherwise would not be feasible. Due to its scalable performance, you can appreciably speed up the ETLT jobs. Adding on, since data saved in Hadoop persists for a much longer period, one can provide more granular details of the data via EDW for high-fidelity analysis.

For more Information or Implementation services, you can contact our expert on sales@bistasolutions.com or call on USA: 404 631 6219 / Other Regions +91 897 609 8988

How Hadoop Can Overcome the Challenges with Big Data Analytics

No doubt that the new wave of big data is creating new opportunities but at the same time it is also creating new challenges for businesses across all industries. Data integration is one of the important challenges that many IT Engineers are currently facing. The major problem is to incorporate the data from social media and other unstructured data into a traditional BI environment.

Big-data

Here we have discovered a robust solution to overcome data-related challenges.

We are talking about “Hadoop”, a cost-effective and scalable platform for BigData analysis. Using the Hadoop system instead of Traditional ETL (extraction, transformation, and loading) processes gives you better results in less time. Running of Hadoop Cluster efficiently implies selecting an optimal framework of servers, storage systems, networking devices, and soft wares.

Generally, a typical ETL process will extract data from multiple sources, then cleanse, format, and loads it into a data warehouse for analysis. When the nature of source data sets is large in size, fast-growing, and not in a structured format, traditional ETL can become the bottleneck, because of its complex, expensive,e and time-consuming process to develop, operate and execute.

Data-warehousing title=

Fig #1: Depicts the Traditional ETL Process

Hadoop

Fig#2: Depicts ETL offload Hadoop.

Apache Hadoop for Big Data

Hadoop is an open-source framework that is based on a java programming model that supports the processing and storing of large data sets in a distributed computing environment. It runs on a cluster of commodity machines. Hadoop allows you to store petabytes of data reliably on a large number of servers while increasing performance cost-effectively, by just adding inexpensive nodes to the cluster. The reason for the scalability of Hadoop is the distributed processing framework known as “MapReduce”.

MapReduce is a method to process large sums of data in parallel while the developer only has to write two codes which are “Mapper” and “Reduce”. In the mapping phase, MapReduce takes the input data and assigns every data element to the mapper. In the reducing phase, the reducer combines all the partial and intermediate outputs from all the mappers and produces a final result. MapReduce is an important advanced programming model because it allows engineers to use parallel programming constructs without having to know about the complex details of intra-cluster communication, monitoring the tasks, and handling failures.

The system breaks the input data set into multiple chunks, and each one of them is assigned a map task that processes the data in parallel. The map function will read the input in the form of (key, value) pairs and produce a transformed set of (key, value) pairs as the output. During the process outputs of the map, tasks are shuffled and sorted and the intermediate (key, value) pairs will be sent to the reduced tasks, which will group the outputs into the final results. To perform processing using MapReduce, the JobTracker and TaskTracker mechanisms are used to schedule, monitor, and restart any of the tasks that fail.

The Hadoop framework includes the Hadoop Distributed File System (HDFS) which is a specially designed file system with a streaming access pattern and fault tolerance capability. HDFS stores a large amount of data. It divides the data into blocks (usually 64 or 128 MB) and replicates the blocks on the cluster of machines. By default, three replications are maintained. Capacity and performance can be increased by adding Data Nodes, and a single Name Node mechanism.

For more information or Implementation services, you can contact our expert at sales@bistasolutions.com or call on USA: +1 (858) 401 2332 

How Internet of Things (IOT) will Change the Future of ERP

 The Future of ERP

internet_of_thing

Many websites and  journals  talk about the history and evolution of ERP . Let’s today understand how the industry has  evolved along the last few decades and where is the  ERP system is heading to catch up the ever growing face of industrialization.

• Industry 1.0 was the first ever step towards evolution, this was when mechanical engines came into being. The production equipment was driven by water and steam power.

• Later, in Industry 2.0 mass production was achieved by vision of labor and use of electrical energy.

• Industry 3.0 was all about automation of processes with the help of electronics and IT. This was the first time the world got acquainted to the systems which did their job.

• Today, the world awaits Industry 4.0, where all our physical machining will be managed through the sophisticated electronic/IT systems that people built. So basically, it is the advent of cyber-physical systems. We will have sophisticated cloud based ERPs work along with the machine equipments and sensors in our production plant to manufacture the most popular item of the season exactly as per market demand. Isn’t that fascinating?

This rings a bell – IoT (Internet of Things )

Internet of things is a widely popular area of interest for many. Imagine this working with your system to seamlessly analyze and execute your manufacturing. This is the future of IT industry, and I won’t be wrong to say – this is the future of ERP.

iot

Today’s cloud based ERPs are no less than a wonder, they are completely browser based and have absolutely no limit. From marketing, demand planning, sales, manufacturing, purchase to accounting, it can do just everything that you need. Its modular built makes easier for maintaining and evolving with the market demand. The next big thing we’ll know about  its compatibility with IoT.

Today ERPs have the ability to talk to other systems flawlessly to communicate crucial data. Why can’t an ERP then talk to an internet enabled device? Why can’t we collect data gathered by the device through its sensors about the manufacturing tools and equipment? All of these questions have definite answers, and that is the reason some of us have already started on the quest from “why can’t we?” to “how can we?” .

The first step towards Industry 4.0 is to have a futuristic ERP, which looks at your company ahead of you. We can assist you to make this leap. For more information you can consult our experts on sales@bistasolutions.com or call on USA: +1 (858) 401 2332 / Other Regions +912266219900