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 »
Sage X3 has a function, which helps us to extract a substring from the leftmost end of a string. The function used to extract the substring is Left$(). Syntax: Left$(String, nb_string) Refer the following example for the same: In the above exmaple we use left$() for the extraction from the string, upto 16 characters.
Earlier we have explained how to enable the dimension on header and line level and also explained how to populate it with default value. Now here we are explaining how to enable the new added dimension. See below example- Navigate to entry transaction and add enter new dimension. Navigate to Setup >Organizational structure>Default dimension types. And… Read More »
Go to Set up →General Parameters →Formulas Expand Automatic Journal Search “SKG” and cross check if formula for SKG has been defined or not, if formula is not present, kindly copy the same from SEED Folder and paste the same. <imgtarget=”_blank” rel=”noopener noreferrer”></imgtarget=”_blank”> If there folder is multi-legislation, one needs to define legislation wise formula –… 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:
We may come across the situation, where we want to enable or disable NEW button in window. Sage X3 has a special function to enable or disable new button in window. To enable new button, use the below syntax. Syntax: Enable GSTACRE Parameter details: Enable: Enable is the function that is used to enable the… Read More »
You may come across a situation where you want to attach the Technical sheet to every operation of work order? Sage x3 has standard feature where you can attach the technical sheet. Follow the below steps to attach the technical sheet entry Navigate: Manufacturing ->Planning->Work order->Operations tab In management tab attach the technical sheet.
We may come across a scenario where we want to display message in new line, X3 has a function to achieve this.”chr$” function converts a numerical value in an ascii character, syntax as below. Syntax: chr$( exp_ent ). “chr$” returns a character whose ascii code corresponds to the argument (if there is a corresponding ascii… Read More »
As we all know that Sage X3 can have more than one folder/application. So the question is how we will get to know current folder/application name while accessing Sage X3 ERP. Here X3 provide special “nomap” variable, which complete your requirement. nomap is a variable that is only accessible in read mode and which determines… Read More »
Pre requisites for Multi-Level MRP Processing are same as the planning or normal MRP (Refer blog on Set Ups and Flow on MRP Process), except you needs to Define Multi Level BOM and Routing. Now the Multi-Level Planning can be achieved either by going directly to Manufacturing→Planning→Multi Level Planning OR It can also be done… Read More »
