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 If there folder is multi-legislation, one needs to define legislation wise formula – refer SEED folder In few cases one needs to even define Document type as per formula – Refer below Image Now one can run Accounting Interface without error.
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 »
Sage X3 V7 have a new feature where we can assign an icon to any of the module. We have created a customized module ‘Test’ and assigned an Icon to it. Please refer below screenshot. To assign the module icon we need to follow following steps: Your icon image should be in ‘.png’ format. Icon… Read More »
You may come across the situation, where you may want to give selection window for customer contact. In Sage X3, we can add selection (F12 functionality) and filter the selection records as per our requirement. Follow below steps to add F12 selection functionality for Customer contact: 1. Add the Button field action on field and… Read More »
You may come across the situation, where you need alternate to “like” keyword of SQL, that is to search for sub-string in columns of the table. The one way to achieve it to use instr() function, instr() function takes 3 parameters in account . Syntax : instr( rank, string, sub_string ) rank : Integer type… Read More »
The port number defines the TCP/IP port in which connection server expects connection requests from folder. For development in X3 version 7, while creating new X3 project in eclipse, we have to define following parameters: Hostname Port Folder Here, Hostname: System IP address. Port number: To be known Folder: SEED\X3 We can find out port… Read More »