Tag Archives: Sage X3 technical blogs

How to get Log File name generated using openlog in Sage X3

We can generate logs using openlog. Also, it is possible to get the name of the log file generated using getlogname() function.  Syntax: LOG_FILE = getlogname() This function returns the file name of the last Sage ERP X3 engine log. When the log mode is activated, a file located in the ‘TMP’ subfolder of the folder… 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 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 add the filters in the object based selection

We have scenario where we need to show same selection as per standard object but we need to have additional filter on selection. In this scenario, there is no need to add the additional selection criteria. We just need to add the following selection filter as below. Example: We need Customer selection using the BPC… 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 »