In Sage X3, we may come across a scenario where we want to create transactions with any ID of any choice. By default, every time we create a new transaction, Sage X3 itself generates the next sequence number and assign it to the newly created transaction. But, it is difficult to remember this auto generated… Read More »
In Sage X3, we may come across a scenario where we want to create invoice with any ID/number of our choice. By default, every time we create a new transaction, Sage X3 itself generates the next sequence number and assigns it to the newly created invoice. To overcome this, kindly refer to the below steps… Read More »
We may come across a scenario where we want to replace the old value of field with new one, In that case Sage X3 has the Utility through which user can achieve this feature. For Example: If User wants to update the package field of all the products from old value “C01” to new value… Read More »
While dealing with arithmetic operations, you may want to roundup the calculation result to the next nearest number. Sage X3 has a special function to achieve this. ARR : rounds a number to the next nearest number. ARR ( exp_num1, exp_num2 ) Parameter details: exp_num1: Decimal number that will pass to “arr” function. exp_num2: if… Read More »
One of our clients’ came up with new requirement, where they wanted to allow only few banks access to the users. Sage X3 has functionality where you can restrict the users to access multiple banks. Follow the below steps Add the Row level permission. Navigate To: Set up >Users>Row Level Permission. Assign the Row level… Read More »
In Sage X3, if you come across a scenario where you want to know count of fields defined in a particular screen, Sage X3 provides an inbuilt function to know number of fields defined within a particular screen. You can use this function if and only if the screen is open. Syntax: masknbf(<class|num_exp>) Where, class… Read More »
You may come across the situation where you want year from particular date. Then you may probably use a format$ keyword function to get the year value. But in Sage x3 version 7 you can use another Keyword i.e. “year”. The type of result is Integer. year: year returns the day number of a valid date, including… Read More »
Sage X3 has a solution which is used to find the number of records in a table with the help of keyword “nbrecord” along condition. In order to know the number of records in the table, perform the below query. The output will be number of the clients available against the corresponding table. About… Read More »
You may come across the situation, where you want to concatenate a char or CLOB value to a char or CLOB variable. Sage X3 has a special Keyword named APPEND to perform the concatenation of two or more string values. From a functional point of view, Append Field1, Field2 is equivalent to Field1+= Field2. if… Read More »
In the business process we may need a process wherein the Remittance will be created automatically on daily basis. In Sage X3 we can do this in simple way by using the Batch process. Refer to below steps for the same. Step 1: Create the task follow the below steps for the same: Navigate to… Read More »
