As we all know that Sage X3 can have more than one folder/application. So the question is how we will get to know current folder/application name while accessing Sage X3 ERP. Here X3 provide special “nomap” variable, which complete your requirement. nomap is a variable that is only accessible in read mode and which determines… Read More »
In Sage X3, Supplier Document Number Field is available on purchase invoice screen in management tab. It is a mandatory field which means while creating entry we can’t skip this field. We have to enter data in this field then only we can proceed further. We had a requirement from client that data entered in… Read More »
In Sage X3, only posted transactions will be considered for accounting effects. Here in this blog we had a requirment from a client that , there should be a field on the header of purchase invoice screen, in which total transaction amount of the Supplier should be displayed for current fiscal year according to the… Read More »
In Sage X3 , selection screen on a particular field helps users to search easily and select as per the requirement. In Sage x3, If user want search selection should be there on any field, then it is easy if we are directly using custom data type for the same, but if we have used… Read More »
As you know, Sage Enterprise Management provides its own select, update statements like SQL. For efficiency, we can use SQL queries in Sage X3. Sage X3 provides special function to execute SQL statements/ commands. The special function is Execsql. It is used to launch a SQL request that does not require the return of information,… Read More »
adxmac is a function used to identify the server in which the current folder, or one of its reference folder, is installed. It also allows you to obtain the network name of the client (in version 7 mode, the client is the node.js server) Syntax: adxmac(Index) Examples: # What is the application server name APPSERV_NAME=adxmac(0)… Read More »
We may have come across a situation where you need to find a particular value from a series of numerical, alphanumerical or date expressions or variables. This can be achieved using “find”. Syntax: find(value_to_seek, list_exprg) value_to_seek is the value that needs to be found list_exprg is the series of numerical/alphanumerical/date expressions/variables Example: Consider an example… Read More »
We use the external resource like JAR file to execute our certain functionality, for which we need to upload the JAR file in the JAVA Bridge server and then we can access the same with 4GL code. Below are the steps to upload the JAR file in JAVA Bridge Server. Login into the JAVA bridge… Read More »
To implement the business logic we need to use SQL Query to fetch the required data from the Database. To execute the SQL Query from Sage X3 we need to know the database type. We can fetch the database type as below: The “TYPDBA” column in “ADOSSIER” table holds the value which will help to identify… Read More »
It’s Very obvious to declare the variables while developing any kind of application. These variables contains a value for particular field. While declaring this variable, we have to set the length of the variable. Two obvious way to set length and corresponding disadvantages: Check with the length of the field data type of that field.… Read More »