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: Interrogation of client workstation properties »
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: How to Increase Sage ERP X3 memory for a particular… »
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: How to roundup decimal number to two decimal places »
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: How to find if a field in the screen is… »
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: How to Truncate numbers after decimal point »
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: How to execute import utility using code »
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: Sage ERP X3 integration with Sage CRM using GUMU™ »
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: How to pass dynamic data in Crystal reports from Sage… »
Sage ERP X3 has a functionality of creating Import/Export template which works quite effeciently. The only thing that has to be done manually through export utility under Usage is Imports/Exports>Exports, (GEXPOBJ). New Stuff: How to use Adxuid to control multiple users in Sage ERP X3 However, Sage ERP X3 has a functionality of creating Import/Export… Read More: How to execute export utility using code »
In order to handle multiple users for different sessions, Adxuid is used for control the multiple users. New Stuff: How to know patch level in Sage ERP X3 The adxuid returns a unique identifier for each user who is logged at different sessions. The result is an integer type. So we can handle the code,… Read More: How to use Adxuid to control multiple users in Sage… »
