Archive for the ‘ERP’ Category

How to Ensure Data Security With Mobile ERP

Mobile Enterprise Resource Planning (ERP) solutions are very helpful for large corporations. Especially, when it comes down to streamlining business process, managing human resources, tracking inventory, and ultimately boosting business revenues. It has helped many organizations to handle a large amount of data with mobility. But it has come with few disadvantages which include data breaching. So, opting for this situation comes with risk as well. Let us check out the list of security features for better mobile ERP solution-

1) Device Security

Device security allows you lock or wipe the mobile device if it gets lost or stolen. It also incorporates password policies and set up a mechanism to detect device misuse through fiddling with device setting or something else. Apart from this, features like device lockdown and blacklisting of suspicious apps or apps from unknown sources can also enhance the protection of data from hackers.

2) Location Tracking

As the name suggests, it can track or locate the device to minimize the security issues if the devices get lost or stolen. Although it is a basic security aspect, it is undeniably an important feature. mobile-crm

3) Secure Remote Access

It includes setting up a private and encrypted connection between mobile devices and the corporate network. It helps to safely transfer the information and keeping it safe from the hackers, it becomes difficult for them to decode the information.

4) Encryption

It is necessary to have encryption services in EMM. With encryption. IT department of an organization can have full control over the system and encryption process through a separate app-based workspace containing all the saved corporate data. With a strong encryption backup, data will even remain safe in a device without password protection.

5) Data leakage protection

It enables the prevention of deliberate or unintentional exchange of data from a mobile device which means it may provide access to authorized applications on a device when it comes to viewing a file but it will not allow any untrusted application like a cloud-based app to open or save the file. Image result for mobile erp

6) Secure Software Distribution

It helps to securely push the code of the application and it becomes possible to track the installed applications and successfully uninstall the application which violates the security of the system.

7) Advanced features & support in Platforms like Android, iOS, Windows

Some advanced features offer great scope for enhancing data security. It separates the personal and business data to ensure high-level of encryption on Android, iOS, Windows or any device. Image result for mobile erp Although data breaching is a crime, people still do it to harm others’ business. These security features in mobile ERP will solve many problems and keep the data safe from any breach.

Top 5 Client/ Server ERP solutions

Enterprise Resource Planning (ERP) has become  a major component of organizations. It is widely used to increase efficiency and productivity of the company. It helps the companies to manage resources and monitor them on a real-time basis. The global and competitive environment between companies has made it necessary for companies to have some sort of ERP in place. Let us check out the top 5 ERP solutions available in the market-
  1. Epicor

Image result for epicor It has been established in 1972 and has been in the market for a very long time. The company has introduced many reputable products, and has over 20,000 customers in 140 countries all over the world. They have high good value added reseller channel and provides strong industry solutions. The best part about the company is its pool of ERP consultants and products offered by the company are low to moderately price.
  1. Infor

Image result for infor It is the 3rd largest company in the ERP market which was found in 2002. It has a major role in introducing enterprise software for financial systems, supply-chain management and customer relationship management. They have more than 70,000 customers all over the world. The company is known to provide vertical ERP solutions and boast key strength in manufacturing solution. They provide ERP solutions for complex and non-continuous manufacturing. Solutions provided by the company are low to moderate in price.
  1. Microsoft

Image result for microsoft erp With 83,000 world-wide customers, Microsoft has a strong presence in Small Medium Business segment and mid-market. Microsoft ERP products are only sold value through re-seller. You can make data-driven decisions with a complete set of ERP tools to provide global visibility, scalability, and digital intelligence.
  1. Oracle

Image result for oracle erp It is 2nd in the ERP market and number 1 in CRM market. The company has over 30 years of experience in the market. The products offered by them has flexible modules and open for customization. They are in high price band.
  1. SAP

Image result for sap erp It is the largest player in the ERP market. They have over 108 functional modules being pioneer in the industry. The products offered by the company are in high-price band.  

Small Market Business Leader

It is dominated by Microsoft ERP products. The company has gained some acquired customers in recent past which has  added value to its ERP portfolio.

Middle Market Leaders

Epicor and Infor are strong players in middle market. Epicor is robust in financial, hospitality, .retail, etc. sectors.

Global Companies and Large Enterprises

SAP is the leader of this market as it provides accounting solution software, which tightly integrate all major departments throughout the company. Oracle is in acquisition of PeoplSoft has came out as a strong force in ERP market.


The ERP solution is evolving rapidly. Most of the organizations use them for efficiency in their work. Apart from the top five, the open source ERPs are yet to prove themselves as a replacement or commercial ERP applications. The market of ERPs is the future of computing.

Struggling between hiring an agency or a freelancer? Here is a solution!

Choosing between hiring a technology firm and a freelancer is undoubtedly one of the most confusing things. Everyone go through this struggle. The website is a reflection of a company. It defines their work, and give the visitor a rough idea about the company’s profile. One cannot put the company’s reputation at stake to save a few bucks. In this article, we will try to make your decision easier. There are few things you need to know about project & company before hiring.  Let us check out-

1. Know the scope of your project

Image result for scope of project The first thing you need to know is the scope of your project. Evaluate the needs & requirements of your project. Analyze the team requirement and size. You need to decide what kind of website you want to develop. If your project requires a large team, then a freelancer would not be a good choice for you.

2. Hire the right skill set

The right skill set refers to the difference between designing and development. It makes a huge difference. If you are uncertain about these things, you need to go back to the scope of the project, and then decide.
  • Web Designer: The designer develops the look and flow of the site. They work on HTML & CSS most of the time.
  • Web Developer: They are programmers who are primarily focused on coding, mechanics, and functionality of the website. They work on different frameworks and languages.
Now you can easily select which one do you want.

3. Look at their portfolio & experience

Image result for company portfolio Before jumping into an agreement or contract, you need to check out if they are reliable. Check their previous work, portfolio, website, etc. If you are planning to hire a freelancer, then you should check his/ her work profile on those websites.

4. Get to know them

Image result for teamwork Narrow down the candidates, and get to know more about them. Know more about their previous work, check out their reviews on different platforms. Good communication is critical, especially if you’re working with a remote team. Do they reply to your emails on time? Would it be possible for them to provide templates on time?

5. Hire!

Now, you have crossed all four steps, you are ready to hire the team! Image result for hire! You need to be careful while hiring someone for your work. There will be advantages and disadvantages, but you need to evaluate the pros and cons of both, and then make the decision.  

Problem displaying picklist values in vTiger

A lot of people opt for vTiger as their CRM only because it is Free and Open Source but they just discontinue using vTiger because of its minuscule support and even if they Google their problem then there are number of other developers having the same problem unresolved. For the past few days i was facing a similar problem which i think was merely unattended on vTiger forums or on any other CRM blogs. Problem was that “When we created a module (both back-end & front-end) then after selecting it in menu assigned we found that the assigned values of the Picklist were not being revealed by the Picklist Editor”. I will try to explain the solution to this problem step by step so that it saves someone else’s time. The problem is mainly due to the configuration while creating the module(The Module creation file). In the meantime do checkout an extensive post on Open Source CRM You may need to delete the module in case you have created a custom module. It can be done with the help of following code:


$Vtiger_Utils_Log = true;


$module = Vtiger_Module::getInstance('ModuleName');

if ($module)





Here ‘ModuleName’ depicts the name of your module. Copy this code to any text editor and then save file with name ‘Delete_ModuleName.php’. Once created run this file on your webserver. Once done with this go to your module creation file where we’ll resemble the following format:


$Vtiger_Utils_Log = true;



$module = new Vtiger_Module();

$module->name = 'ModuleName';


$module->initTables();                                     // Initialize all the tables required

$module->initWebservice();                    // Creates a entry in vtiger_ws_entity

$menu = Vtiger_Menu::getInstance('Tools');        // Add the module to the Menu       $menu->addModule($module);

$block1 = new Vtiger_Block();                                    // Add the basic module block



$field1 = new Vtiger_Field();                             //Create fields and add to the module

$field1->name = 'name';

$field1->label = 'Name';

$field1->table = $module->basetable;

$field1->column = 'name';

$field1->columntype = 'VARCHAR(255)';

$field1->uitype = 2;

$field1->typeofdata = 'V~M';                                     // Varchar~Mandatory

$block1->addField($field1);                     // Creates the field and adds to block

$module->setEntityIdentifier($field1);       // Set at-least one field to identifier of module

$field2 = new Vtiger_Field();

$field2->name = 'type';

$field2->label = 'Type';

$field2->table = $module->basetable;

$field2->column = 'type';

$field2->columntype = 'VARCHAR(100)';

$field2->uitype = 15;

$field2->typeofdata = 'V~O';                                     // Varchar~Optional


$field2->setPicklistValues( Array ('Employee', 'Trainee') );         // Picklist values are set

// Common fields that should be in every module, linked to vtiger CRM core table

/**Common fileds that have to be incorporated are:

* assigned_user_id

* createdtime

* modifiedtime


$filter1 = new Vtiger_Filter();                                     // Create default custom filter

$filter1->name = 'All';

$filter1->isdefault = true;


$filter1->addField($field1);                                         // Add fields to the filter created

$filter1->addField($field2, 1);

$filter1->addField($field3, 2);

$module->setDefaultSharing('Public_ReadWrite'); / Set sharing access of this module

$module->enableTools(Array('Import', 'Export'));           //Enable and Disable available tools



Points to be taken care of while creating the ‘vtlib module creation file': 1)       Check your vtlib script for the line “$module->initWebservice()”  as it creates entry in vtiger_ws_entity. 2)       “$module->setEntityIdentifier”    must be set at least once for the mandatory field of the module. 3)       While creating field for picklist do ensure that it refers to “$module->basetable” as without it the picklist values will enter the database but won’t be called in UI. This problem was rampant in the default ‘Payslip’ module creation file as its picklist field expunged this table declaration. After formulating this backend and executing we are left with frontend of our module (modules/ModuleName) and all the files of frontend following it. Now in the file naming ‘ModuleName.php’ we have:

var $list_fields = Array ();

var $list_fields_name = Array();

Here we have to add each and every field (in the format assigned) we have declared in ‘vtlib creation file’ to be listed in UI. Following the above steps can help you eradicated deadly errors with picklist values. Please comment in the blog post if you still face issues and we would be happy to help.

Database name in webERP

Recently we implemented a weberp based solution for one of our esteemed clients. The development server was hosted on apthost and hence we had to manage database from the apthost cpanel. As we are all aware of the fact that cpanel will pre-append the user name of the shared user to the database that you create from it, we wanted weberp to adjust database name according to that (or for that matter, what ever may be the reason for you to chose a different database name. In case you are interested in looking at other solutions, do checkout our post on open source erp solutions. Weberp supports multiple companies in one installation and hence there can be multiple databases. The trick here is that the name of the database must match the name of the sub-directory in the companies folder. We have been getting a lot of queries on if we can change the association of sub-directories with the database name in the webERP. Unfortunately as of weberp version 3.11, There is still no getting around the fact that the database name and the sub directory under the company directory should still be identical. In case, you are using webERP thro its web-services, then you would need to make another change for the end points to work correctly. You will need to change the variable $DatabaseName to refer to the name of your database. The variable is defined in apiapi_php.php
Change this to the name of your company and you will be all set to go. Though this is not a proper method and proper implementation should be introduced to specify the name of the company from the API calls, but this works for now. Good Luck with your webERP implementation !!