Category Archives: FAQ

How to launch SQL Request in Sage Enterprise Management

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 »

How to Know Current User Code in Sage X3

In Sage X3, there exist some standard global variables which provide information regarding current functional processing. For eg., current function, current user, a name of current user etc. The global variable GUSER provides a code of a user which is currently logged into Sage X3 applications. You can easily use this global variable into your… Read More »

How to generate simulated accounting entries in Sage X3 Version 11

In Sage X3 we come across issues related to accounting effects not getting posted correctly. Issues such as account missing and unbalanced journals. To rectify such issues we need to find the accounting effects which are getting triggered during the posting of any journal. To debug this Sage X3 provides an inbuilt functionality “Simulated Entry… Read More »

How to fetch Folder Language using Global variable in Sage X3?

In our earlier blog, you may have to fetch the Language using the variable “messname”. There is another way to fetch the folder language is using the Global variable “GLANGUE”. The variable will return “CHAR” type value. Please refer below screenshot for the syntax. Hope this blog helps! About Us Greytrix is a one-stop solution… Read More »

How to fix “No web services processes declared in Syracuse Hosts” error?

You might have come across an issue where you get a message “No web services processes declared in Syracuse Hosts” while trying to start web service pool in Sage X3 versions 9 and above. To fix this issue follow the below steps: Go to Administration>>Administration>>Servers>>Hosts. Click on the edit button as highlighted in the below… Read More »

Error “Creation not possible” on work order in Sage X3

While creating the work order by using copy functionality. We may face an error that “creation not possible ”. To overcome this error follow the below steps. Navigate to: Manufacturing >Production scheduler>Remove from scheduling. Enter mandatory details on the below screen and click on create. Now you can create the work order by using copy. About Us… Read More »

How to extract a Substring from a String in Sage X3

While dealing with strings, we often require certain characters or a substring from given string. Sage X3 provides a special function to extract a substring from provided CLOB or a string. Syntax:  mid$(EXP_STRING,EXP_POS,EXP_NB) Where,  EXP_STRING is an expression returning a CLOB or string value. EXP_POS is an expression returning an integer value that is the… Read More »

How to change background of the log in page

We get the default image as a background of a login page as shown in below screenshot To change it you can go to the path D:\Sage\Syracuse\syracuse\bin\node_modules\syracuse-auth\html\images In the images folder put the image which you want to be seen as a background of a page with name background About Us Greytrix – a globally… Read More »

How to Merge Business Partners (BP) in Sage X3

Many a times, the user creates 2 similar business partners in Sage X3 instead of 1 business partner, this results in 2 separate entities in all the related inquiries or reports. In such cases, Sage X3 provides BP Merge functionality which allows two BP accounts to be merged together, which will automatically transfer all the… Read More »