You may come across a situation, where you need alternate to the “like” keyword of SQL, that is to search for sub-strings 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 expression… Read More: Alternate to “like” Keyword of SQL »
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: How to Know the Eclipse Port Number in Sage X3… »
In Sage X3 users are allowed to add the line text while creating the purchase request, this text can be a short message related to the product or supplier .If user wants the same text in the purchase order created against that request, Sage X3 allows handling the flow of text from purchase request to… Read More: How to allow text from a purchase request line to… »
Standard function FUNAUTDLV (Order deliveries) is used for bulk shipment creation. There are several filter criteria’s available on this function. But, what if you want to add any additional filter criteria for the orders being passed for shipment creation? Using an Entry transaction we can easily add the additional criteria, follow the below steps for the same.… Read More: How to add additional filter criteria to automatic shipment creation… »
