How to give space between string by coding You may come across a scenario were you need to provide the space between string.X3 has a function “space$(n)” which returns a string with n spaces, Syntax as below. Syntax: space$(nb_esp) space$(nb_esp) returns a string comprising nb_esp spaces(ascii code 32). This function is thus equivalent to string$(nb_esp,… Read More »
We may come across a situation, where we need to calculate a factorial of any integer. Sage X3 provides built-in function ‘fac’ to calculate the same. Fac: It calculates a factorial of any integer value. Syntax: fac(integer) To better understand this, refer the below snippet of code:
There can be occasions when you want to accept date input in an alphanumeric field in grid. As, alphanumeric field does not have calendar control so you need to validate the entry section by writing our own code. Here we are describing how to achieve same via code. Below is the code we have written after… Read More »
Every company has to make a series of payments to its Suppliers / Vendors. Nowadays, payments made using ACH are preferred by maximum companies because it not only saves time and money but is also easier and quicker to make payments/get paid with increased security while preventing the possibility of frauds. Many of the Sage… Read More »
You may come across a scenario where you want to set the allocation and issue rules on product categories. Sage X3 has standard feature where you can set the allocation rule. Create the allocation and issue rules on below path. Navigate: Setup>Stock>Allocation and issue rules Assign the above created allocation rule on product category. Now… Read More »
In Sage X3, we may come across the situation where we may be having some variable name declared in the code file and the same variable in table. Sage X3 has special keyword to make differentiation between local variable and the table variable as there can be same name used while declaring the local variable… Read More »
In Sage X3, we may come across a situation where we need to know whether the path or a particular directory exists or not. We can know this using following function: Syntax: filinfo(path_fil, arg_ent) Parameters: path_fil: Char type expression for the file path to be tested Arg_ent: Integer expression specifying the property to be found.… Read More »
Here, we are going to look for the standard Sage X3 error handling process. It helps to trace error and passes error message to the end-user. Also it will helps to avoid interruption. In other word, it states the error and allow us to continue with the error messages. In Sage X3 when a number… Read More »
In a Sales order, while dealing with pricing we may want to round off net price to the nearest decimal. Sage X3 provides a parameter where we can set whether we want to round off the price or not. SALRND parameter is helpful when the pricing value is in decimals. This parameter stipulates whether a… Read More »
Sales invoice is a bill issued by the seller and is proof the selling process has already happened. The setup of the invoice footers is used to define the numbered codes which are calculated upon valuation of the invoice footer. Based on the setup, this valuation can be performed starting from: The value defined when… Read More »
