Category Archives: FAQ

How To Find Object Abbreviation of Current screen

In Sage X3, we have come across a situation where we need to find the Object Abbreviation of the screen. GABREV is the global variable which stores the Object Abbreviation of the screen.  Fig. Object Name About Us Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP… Read More »

How to find the week number of the date

We came across the requirement where client want to calculate the week number of the date provided for the further calculation. We have Week(date) which will return you the week number  of the provided date. For example: I am running this query on 30/10/2017. Hope this helps.   About Us Greytrix is one stop solution… Read More »

How to get file name for system messages

You may come across where you need to check the filename for system messages. The variable messname contains the filename for system messages. The default for this name is “FRA”. System messages are accessed by the mess function. The value of the [S]messname variable is determined: as a priority by the adonix start-up option: adonix… Read More »

How to solve “At least one runtime must have a max queries number defined” issue in Sage X3 Ver 11

We may come across a scenario where we get “At least one runtime must have a max queries number defined” error while creation/start up of Batch Server. The problem can be solved by using below steps: In below screenshot we have faced an error while creation/start up of Batch Server. This error has occurred because… Read More »

How to Solve “Record already exist error” while creation of Transaction and Masters

We may come across a scenario where we get “record already exist’ error while creation of transactions and masters. The problem can be solved by using below steps: In below screenshot, we have faced an error while creating a product. This error occurs because the product of sequence number BMS089 already exists in the X3 for… Read More »

How to force the display of the fields in a mask

Envzo forces the display of the fields in a mask. Example : # in record deletion # the’OBJect controls the links with the table dictionary # each analysed table is displayed in this window $VERF For [A_TZ]LIEN(2) Where LIEN=FICANU & ANNUL=1 FICHIER = [F:A_TZ]CODFIC Read [A_TB]CODFIC = FICHIER If !GSERVEUR & !GIMPORT If [M:VLC]NUMERO=”” [M:VLC]TEX… Read More »

How to call web service in Sage X3 Version 9 (PU9) using .NET applications

In Sage X3 Version 9 there are some changes with respect to authenticating process of web service while connecting form third party application like .NET. From PU9 onwards it’s mandatory to pre-authorize the connection with the username and password. Let’s see in details with .NET code snippets. Inherit the Sage X3 class ‘CAdxWeServiceXmlCCServiceBasicAuth’ which helps… Read More »

How to call web service in Sage X3 Version 9 (PU9) using .NET applications

In Sage X3 Version 9 there are some changes with respect to the authenticating process of web service while connecting form third-party application like .NET. From PU9 onward it’s mandatory to Pre-authorize the connection with the user name and password. We need to create a class in .NET which connects the Sage X3 web service… Read More »