In Sage X3 latest versions, we are provided with new feature to define filter criterion on the database. This function defines a filtering condition on a database query. The condition is expressed in Sdata where syntax. This function is only valid inside a Where clause of a database instruction (For, Filter, File, Link). Syntax: Where evaluesdata(EXPRESSION,… Read More »
In Sage X3, we may come across a scenario where we fetch the gross price directly from the price list without defining the product for units other than sales unit in the price list screen. This functionality can be achieve by following steps: Navigate to: Setup → Sales → Price Lists → setup In this… Read More »
You may come across the situation where you get any error message, and you need to find out the local menu of that message. You can go to the >>Transaction>>text search Hope this helps! About Us Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance… Read More »
In Sage X3 version 9 when your run web service through ‘Classic SOAP Web services’ the output appears in unreadable format as shown in below screen. To retrieve the output in readable XML or JSON format. Enter the below input in “Request Configuration” field. For Output in XML format : “adxwss.optreturn=XML&adxwss.beautify=true” For Output in JSON… Read More »
You may come across the situation where we give some page size in the crystal which is not compatible with the PDF size and we get a half cut print out as shown in below screen shot. To overcome this we can change the paper size on Sage X3 before giving the print: Go to… Read More »
In custom Sage X3 development, we frequently use parameters for the use of constant values. Here we have an option to control the visibility of parameter on Parameter Value screen. Navigate to : Development>Data and parameters>Development setup>Parameter definitions Check the Changeable checkbox and click on save button. Now navigate to : Setup > General parameters… Read More »
“Renew the service contract” functionality can be achieved by using below steps: Pre-requisites: 1. Service contract must be invoiced. Navigate To: Customer Relations -> Customer Support -> Service Contract -> Management tab 1. Change the end date of the contract.Select next date of the current end date. e.g in above screenshot, we have changed end date… Read More »
Sage X3 provides a special variable to know the current variable value in case of input, initialization, selection or help mode. Variable: [S]zc The type of ZC depends on the context. That is it corresponds to the type of the variable being entered (at the time the check or help is executed) or being initialised.… Read More »
Sage X3 provides an inbuilt function to verify if there are any duplicate values in a series of variable or numeric expressions, alphanumeric expressions or dates. The function used for this purpose is UNI. If the series contain duplicate value(s), the UNI() will return the position of the duplicate value. If there are no duplicate… Read More »
If you come across a scenario where you want to restrict user from creating a sales order for net price less than minimum price then sage X3 provides a standard functionality Non block ctrl price,profit,qt. Navigation: Setup –> General parameters –> Parameter Values Sales – Authorization — SDACLOK (Non block ctrl price,profit,qt ) Set Non… Read More »
