While working on one the projects, we came across a situation where Sage ERP X3 was not updating the existing index in SQL server table whenever we added the activity code and did the validation even though the activity code was active. GUMU™ Sage CRM Integrations: Sage ERP X3 | Sage 100 | Sage 500 | Sage 300 After some R&D, we… Read More »
This blog refers to the issues faced in installing patches in Sage ERP X3 v7 with destination type ‘Server’. Read ahead for the solution If even after entering proper path for the patch files, you are getting the below error: GUMU™ Sage CRM Integrations : Sage ERP X3 | Sage 100 | Sage 500 | Sage 300 To overcome the situation, you just… Read More »
We always do customization’s for X3 system but what if we are required to do customizations based on Client workstation details? That means doing customization’s for particular Users or Personal Computers. In such cases, the keyword ‘Getui’ can be of great help. GUMU™ Sage CRM Integrations: Sage ERP X3 | Sage 100 | Sage 500 | Sage 300 Getui is used to… Read More »
You may come across a situation where you want to increase the memory in sage ERP X3 for a particular user in a particular process. That particular process may need a higher memory for a transaction to process. In Sage ERP X3, it can be done with help of the keyword “maxmem”. MAXMEM indicates the… Read More »
In a situation dealing with arithmetic operations, you may want to roundup the calculation result to up to two decimal places. Sage X3 has a special function to roundup a decimal number to two decimal places. ar2: This function roundups a decimal number to two decimal places. Syntax: ar2(exp_num) Parameter details: exp_num: Decimal number that… Read More »
A developer in sage ERP X3 may come across a requirement where he/she wants to do validation depending on whether the field is enabled or disabled. Sage ERP X3 offers a Numeric function “varmode” from which, we can identify whether the field is enabled or disabled. “Varmode” is used to determine if a mask variable can… Read More »
You may come across a situation where you have a numeric operation and you want to truncate the number of digits after the decimal point. Sage ERP X3 has a special feature for truncating the numbers with the help of “fix” keyword. The type of result is an Integer or Decimal depending on whether the… Read More »
Sage ERP X3 has a functionality of creating Import/Export template which works quite efficiently. The only thing that has to be done manually through export utility under Usage is : Imports/Exports->Exports, (GEXPOBJ). However, Sage ERP X3 has a functionality of creating Import/Export template in XML format which can be done manually after following some simple… Read More »
An ERP system on its own is insufficient for the growth of a business. What you need is an ERP system which works in sync with a CRM system to attend increased efficiencies for both the systems. GUMU™ for Sage CRM – Sage X3 Integration is a comprehensive business intelligence system, specially designed to satisfy… Read More »
While working on a crystal report we come across the situation where we want to process data from several tables before running the report. In this situation X3 provide specific coding feature where we can write code to pull data from several tables and screens and we can pass to Crystal report before running. We… Read More »
