Category Archives: Technical

How to add the Dashboard in Sage X3 Version 12

In some requirement, user may wants to see some reports when they login to the Sage X3, or for the management people thy need to see the any sets of records like Open Sales Order, Open Invoice, outstanding and many more on the login of the Sage X3. We can achieve this by following the… Read More »

Getting the List of Accessible Classes in the Current Application

We may encounter a scenario where we want to know the names of the classes that are accessible in a current application. For this, CLANAM function can be used. The CLANAM function is basically used for acquiring the list of classes accessible to the current application.CLANAM function returns the Char type. Syntax : clanam(< Class… Read More »

How to Change the Title of a Tab Dynamically?

Sage X3 provides an inbuilt function to rename the title of a tab at runtime. We can change the tab title dynamically using following function: Chgtfd [class] expr_c Where, class: describes an open mask. In the absence of this parameter, the default mask is used. expr_c: describes expression of the type Char containing a valid… Read More »

How to get the value of the current variable/field in Sage X3?

ZC contains the value of the current variable (in input, initialization, check, selection and help mode). Class, Type and Dimension: Type of zc depends on context that corresponds to type of variable being entered (at the time of check or help is executed) or being initialized. [s]zc Examples: # In a routine associated with a… Read More »

How to add Conditional styles to a Patch File in Sage X3?

We may come across a situation, where we want to add Entry Point to Patch file in Sage X3. Follow the below steps: Step 1: Kindly navigate to Development > Utilities > Patches > Patch Creation Then we will get the below screen. Step 2: Click on Client Radio button, then select Type of Patch… Read More »

Handling the Customized Fields Using Entry Transaction in Sage X3

In Sage X3, whenever we do any change on transaction screens like order, shipment, receipts or any other screens, we need to validate Entry Transaction. But, we may come across a scenario where user wants the modifications to behave differently depending on the transaction selections. For e.g., A customized field on Sales Order is to… Read More »

How to give space between string by coding in Sage X3?

How to give space between string by coding You may come across a scenario were you need to provide the space  between string.X3 has a function “space$(n)” which  returns a string with n spaces, Syntax as below. Syntax: space$(nb_esp) space$(nb_esp) returns a string comprising nb_esp spaces(ascii code 32). This function is thus equivalent to string$(nb_esp,… Read More »

How to Find a Factorial of Any Integer Number in Sage X3?

We may come across a situation, where we need to calculate a factorial of any integer. Sage X3 provides built-in function ‘fac’ to calculate the same. Fac: It calculates a factorial of any integer value. Syntax: fac(integer) To better understand this, refer the below snippet of code:

How to validate alphanumeric date field in Sage X3?

There can be occasions when you want to accept date input in an alphanumeric field in grid. As, alphanumeric field does not have calendar control so you need to validate the entry section by writing our own code. Here we are describing how to achieve same via code. Below is the code we have written after… Read More »

How to avoid clashing between local variable and table column name?

In Sage X3, we may come across the situation where we may be having some variable name declared in the code file and the same variable in table. Sage X3 has special keyword to make differentiation between local variable and the table variable as there can be same name used while declaring the local variable… Read More »