Key to a Successful Implementation of ERP Software Solution

Businessmen like to follow an order of business. They prefer knowing what is going to be done and who would be doing that. Tasks are accomplished without any delay when people are held accountable. In any line of work, processes require outlining, an agenda needs to be set. What’s more, the value of it can be seen unquestionably, in any situation, especially ERP implementations.   […]

Read More 2 Comments

Why Businesses Are Opting For Customized ERP Solutions?

Finding an ERP System that fits all the criteria on your checklist could be a hectic task. There are so many types of ERP Systems available in the market offering you a wide array of distinctive features. Using an ERP solution with features that would make no sense to your business or one that lacks some essential features needed for your business will only be a pitfall.   […]

Read More Leave comment

Use Of Line Chart Component In Pentaho BI Server

A chart is a graphical representation of data, in which “the data is represented by symbols, such as slices in a pie chart, lines in a line chart or bars in a bar chart.A data chart is a type of graph or diagram, that organizes and represents a set of numerical or qualitative data. A line chart is a two-dimensional scatterplot of ordered observations where […]

Read More Leave comment

Extracting Year And Month From A Date Value Using Pentaho Kettle

This blog is dedicated to the need of extracting year and month value from a particular date column with a default yyyy/mm/dd HH:mm:ss format.For that we’ll make use of mainly the calculator step in Pentaho to extract the given month and year for that particular date.This calculator step provides you with predefined functions that can be executed on input field values. In the screenshot below […]

Read More Leave comment

Use Of Fiscal Position In Odoo?

Odoo is an open source erp software which supports multi-currency/Multi-company environment. When clients/customers/companies are operating in a Multiple countries/States where Tax policies varies in terms of their operation, Fiscal Position feature is really needed. This feature helps in mapping taxes and accounts with their relative taxes and accounts as per countries or group of countries involved in the operations. Configuration of Fiscal Position ? In […]

Read More Leave comment

How to setup NFS on cent OS 6.6 final

How to setup NFS on cent OS 6.6 final NFS(Network File System) share storage, it requires two server one is a server and second is client server. server1 Client let’s be a root sudo su To setup NFS server use below cmd. yum install nfs-utils nfs-utils-lib add services on startup chkconfig nfs on service rpcbind start service nfs start Now export the shared […]

Read More Leave comment

Blog: Fill The one2many fields on Onchange

Please find the below code to fill the one2many fields on ONCHANGE Method in open source ERP. <field name=”indent_id” on_change=”onchange_indent_id(indent_id,branch_name)” attrs=”{‘invisible’:[(‘delivery_type_others’,’!=’,’direct_delivery’)],’required’:[(‘delivery_type_others’,’=’,’direct_delivery’)],’readonly’:[(‘state’,’!=’,’intransit’)]}” /> select the record in the above field to fill the onchange data in below one2many. <field name=”receive_indent_line” nolabel=”1″ attrs=”{‘readonly’:[(‘state’,’in’,(‘done’))]}” on_change=”onchange_receive_indent_line(receive_indent_line)”> <form string=”Material Details”> <field name=”product_code”/> <field name=”product_name”/> <field name=”generic_id”/> <field name=”batch”/> </form> </field> Onchange Method for the above field: def onchange_indent_id(self,cr,uid,ids,indent_id,branch_name): v={} values=[] […]

Read More Leave comment

How to install Pentaho Bi Server with ubuntu 12.04 LTS server

PART-I Pr-requisites 1)Ubuntu Server Find OS: lsb_release -a Outupt : No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 12.04.3 LTS Release: 12.04 Codename: precise 2) Mozilla firefox(Preferrable for pentaho) Version 35

Read More Leave comment

Concatenating Two Fields Using Pentaho Data Integration

In formal language theory and computer programming, string concatenation is the operation of joining character strings end-to-end. For example, the concatenation of “foot” and “ball” is “football”. In programming, string concatenation generally occurs at run time, as string values are not in general known until run time. However, in the case of string literals, the values are known at compile time, and thus string concatenation […]

Read More Leave comment

Time consuming search issue (Deletion of temporary search)

In our Central server ( Customer Relationship Management) large amout of data is processed, there is also a search function that requires continuous insertion of vast amount of data in temporary tables of search. To search a record a record first the records will be fetched using all the filters provided by hitting a dynamically prepared sql query. The results are then inserted in temporary […]

Read More Leave comment