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 »
A contract order is a long-term commitment with a supplier concerning one or more products, for a global quantity and value to be delivered. The contract order is further divided in shipment requests that are made as a function of the contract. A contract can also be intercompany or site transfer. These shipment requests are… Read More »
Sage X3 has a feature in which we can increase the address lines for a customer. This feature can be achieved by following below steps:- Navigate to Set up → General parameters → Folders → SEED Under screens tab, there are various activity codes which are used for functional sizing of the screens. To increase… Read More »
We may come across a scenario where you need to copy a BOM which may have same usage with different BOM Code. Sage X3 has a feature in which you can create copy of BOM. Several types of BOM copies are necessary to facilitate the management of the technical data: – First level BOM… Read More »
Stock count is a process of counting inventory on a periodic basis throughout the year. This is a two-step process as explained below- A stock count session is generated to select the products and /or locations to be counted along with other parameters and selection criteria. A Count screen is used to check the count. To… Read More »
