You may come across a situation, where you want to run a particular process using code. You can use the run command for the same, Run allows you to execute a process. Syntax: Run prc_nam # Example: Execution of the “READ” process Run LECTURE The Run instruction executes a process. The process is searched for… Read More »
If you come across a scenario where you want to create a loan order and system is generating the below error after entering a loan customer on delivery address in sales order then. Go to Customer master. Common Data – BPS – Customers – Ship to Customer. Set Shipment Site and Loan location for the… Read More »
checkpath is a function that allows you to verify if a file path is in the white list of the engine and can be accessed. Syntax: checkpath(FILE_PATH,ACCESS_MODE) Parameters: FILE_PATH is the path of a file or a directory which accessibility must be checked. The files do not need to exist, the only check that is done… Read More »
In Sage X3, we may come across a scenario where you may need to set a particular dimension type as a default dimension for Sage X3 users. For example, we have created a new dimension type X and we want to set it as a default dimension type for users then we can easily do… Read More »
In Sage X3, we may come across a scenario where we may need to set a default destination for a particular report. Let’s assume that we have created a new report XYZ and by default, it’s getting printed in EXCEL format. But, we want to print the report in PDF format then we can easily… Read More »
Sage X3 provides a special function Writeb to write into a table. It works similar to Write function but it allows us to optimize the performances when several insertions of database lines must be done. Syntax: Writeb Writeb[CLASS] where, CLASS: a classidentifier that corresponds to the abbreviation used to open a database table. Writeb allows… Read More »
You may come across the situation where we have to generate a sequence number manually, consider the following example. Where sale order number is ALLSONAO0110005, we want next sales order number to be generated is ALLSONAO0110008 to do so we have to go to the sequence number values screen. Add the seq counter, give next… Read More »
Sage X3 version 7 has a new function Flush the Write buffer, which is filled by the Writeb instruction. Flush: The Flush instruction sends to the database the lines that have not already flushed when the Writeb syntax is used to create lines in the database. Syntax: Flush[Class] Parameter Details: CLASS is the abbreviation of the table in which the flush is… Read More »
Sage X3 provides a functionality to restrict certain products to be sold on the Sales Order, when the products cannot be sold to the customer unless the customer is authorized to buy such products. e.g. liquor products, medicine products etc. Follow below steps to create a restricted pricelist. Navigate: Setup -> Sales -> Pricelists ->… Read More »
The Sage X3 function holds the function which calculates the square root of the given number. Below is the syntax to calculate the same. Syntax: sqr(numeric value) Example: The return type of function (i.e sqr()) is double if we will assign a value to integer data type it will parse the value to the integer. This… Read More »
