Author Archives: Greytrix

How to find Exponential in Sage Enterprise Management (formerly Sage X3)

You may come across the situation where you would like to know the exponential of the value. exp function returns its parameter’s exponential. Description and Comments This function returns the parameter’s exponential (power of e). exp is the inverse of the In function. The result type is Double. Syntax exp(num_exp) Element – num_exp Description – Numeric Expression Restrictions… 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 find Total Payslip Count (Sage X3 People)

In our recent blog “Headings, Variables and Totals (Sage X3 People)”  we have discussed Headings, Variables, and Totals. Now we are going to see about Payslip Count.  PAYSLIP:- It is a piece of paper received by an employee showing how much salary they have been paid in the current pay month. “Generally Payslip are being created… Read More »

Asset splitting functionality in Sage X3

Fixed Assets is one of the solution capabilities of Sage X3. Asset splitting is one of the functionalities of Fixed Assets in Sage X3. Asset splitting is the process of splitting assets i.e. one asset can be split into multiple assets. In Sage X3, we may encounter a scenario where we need to split an… 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 »

How to enable Bank File button in Sage X3

You may come across the situation where we have to download a bank file from manual remittance screen, in most of the scenario you can find bank file button disabled This depends on the payment type. To enable the button you can go to Set up>>AP-AR Accounting>>Payment entry types Select the same payment entry type… 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 enable geographic subdivisions in address

In Sage X3, ‘Geographic subdivision’ function is used to define by country and by geographic subdivision level the codes that allow the subdivisions of a level to be identified. To define the geographic subdivision navigate to Common data > Common tables > Geographic subdivisions and define the code against the subdivision and country. Then navigate… 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 define default allocation type used in order entry | Sage X3

Sage Enterprise Management (formerly Sage X3) is a robust financial accounting system with a wide range of features and functionalities aligned with your specific business requirements. In this blog, we will discuss one of the important concepts of defining default allocation type in Sage Enterprise Management (formerly Sage X3) used in Order entry. Defining an… Read More »