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 »
Mass copy of accounts function is used to carry out a mass copy of number of Accounts with a given range from one folder to another. In accounts transfer by giving the range of accounts, the given range account will be copied to another folder. In the following example, the account range from 1010 to… Read More »
There might be a scenario where we want to cancel the posted payment receipt. Sage X3 provide feature to reverse the posted payment receipt. To successfully bring this functionality follow below steps. Navigate to: A/P-A/R accounting>Payment/ Receipt entry >RCHQ>Options/Menu Bar> Accounting Cancellation Click on ‘Accounting cancellation’. Select the negative generation type. Select the accounting. Click… Read More »
It’s Very obvious to declare the variables while developing any kind of application. These variables contains a value for particular field. While declaring this variable, we have to set the length of the variable. Two obvious way to set length and corresponding disadvantages: Check with the length of the field data type of that field.… Read More »
Sage X3 has a special in-built feature to add levels in graphical requester. Follow the below instructions to add levels to graphical requester. Step1: Go to Setup –>Usage –>Reports –>Graphical requester You will find the Graphical requester screen and create a record as shown below, In the below screen, we have added the “SORDER” and… Read More »
Sage X3 provides an inbuilt function to retrieve the number and name of month from the particular date. Following are the functions you need to write for the same. To retrieve number of month from given date: month(exp_date) To retrieve name of month from given date or given number of month: month$(exp_date) month$(exp_num) Where, exp_date … Read More »
In Sage X3, sometimes you may have to check for the initialization of a particular mask variable. Sage X3 provides an inbuilt function to do the same. Below function is used to know whether a mask variable is initialized or not. varinit ( zone_name [, exp_index ] ) Where, Zone_name : [ class ] name_of_variable.… Read More »
If we want to debug the code on version 7 or on any higher version, eclipse will help us in that. We cannot get the window back if we knowingly or unknowingly close the debugging window. Sometimes we may need to uninstall or re-install eclipse, even if we click on debug button. This issue can… 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 »
In Sage X3, we may have to display a particular message for several times based on the certain condition. We can define such frequently used messages in a local menu and can access them through coding. To access the message defined in a local menu in coding, Sage X3 provides an inbuilt function: mess(exp_num, exp_chap,… Read More »
