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 »
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 »
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 »
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 »
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 »
1. Setup variable to be updated. Note: Uncheck Expense notes 2. Setup Variable for a portal default value as well as the maximum allowable value to be claimed via the portal. These can be configured as separate variables or can comprise the same variable. Note: Check the Folder, The variable for the default and/or maximum values will… Read More »
You may come across the situation where you would like to know the database size of the folder or amount of space utilized by the folder in the database. Sage X3 has a special feature of getting database size of a particular folder in the screen. New Stuff: How to define filter criterion on database query… Read More »
Have you came across a scenario where you want to change the name of “Module and Sub Module”. Image 1: Home Page Navigate To: Administrator>Authering>Navigation Page Image 2: Pages Now Edit the Home Page content. Image 3 Edit module name like “Orders to sales orders”. Image 4: Navigation Pages Now, you can check the names of Module… Read More »
We may came across a scenario where we want to upgrade apache service using binary files. We can achieve this by using below steps: Note: Here we are upgrading apache from 2.2.17 to 2.2.34. Download the zip file for apache 2.2.34. Extract it in the system. Stop the apache service. Copy all the files from extracted… Read More »
How will multi-currency support benefit organizations? Today, businesses are not bound by borders. With globalization and the growing transparency in business operations, organizations are exploring opportunities in foreign markets. To function exceptionally in the global marketplace, businesses need multi-currency support to carry out seamless transactions. Given the complexity in managing multi-currency for different scenarios, Sage… Read More »
