In Sage Enterprise Management, we may come across a scenario where we may face the below journal, not open error while running the accounting interface. This error resolve by following steps: Navigate to: Common data → G/L accounting tables → Journal codes Enter the company and opening date and click on the OK button. Hope… Read More »
In Sage Enterprise Management, as you know we have a special function to print the reports. To print a report, we need to enter the values in report parameters. In case, there are multiple parameters and you want to print the report for same parameters in future then instead of entering all the parameter values… 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 »
As you know, whenever we want to upload any file either in Sage X3 or in any programming, we get drop box from standard for file selection where we can select the file to be uploaded. As said, this pop up comes from standard. But, in Sage X3 we can pop up dropbox through our… Read More »
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 »
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 »
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 »
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 »
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 »
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 »
