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 »
lobsize returns the size (in bytes) used for the storage of BLOB or CLOB variable. Syntax: lobsize(BLOB_CLOB) Example: # How much space spent for a clob? Local Clbfile MY_CLOB(0) MY_SIZE=lobsize(MY_CLOB) : # Returns 1016 (stores 508 characters) My_CLOB=string$(50,space$(10))+space$(9) : # Assign a 509 character string MY_SIZE=lobsize(MY_CLOB) : # Returns 66550 (MY_CLOB has been automatically enlarged)… Read More »
This function extracts the Nth character of a CHAR or CLOB variable. This function runs much faster than the usual functions such as mid$or seg$ when managing large CLOB data. Syntax: EXTRACTED_CHARACTER=Xgetchar(CLOB_SOURCE,POSITION) Parameters: CLOB_SOURCE has been declared by using a Clbfile or a Char POSITION has been declared by using an Integer EXTRACTED_CHARACTER has been… Read More »
The growth of industrialization and manufacturing production remains an essential part of Africa’s economic transformation. Manufacturing being among the top three multiplier sectors in terms of value addition, job creation and revenue generation contributes to about 15% of the GDP to the East African regions of Kenya, Tanzania, Rwanda, Ethiopia, and Uganda. Manufacturing sector traditionally… Read More »
You may come across a situation during the optimization processing in update mode, all selected work orders are locked (their situation flag switches to “Understudy”) and processing go wrong ,it may happen that the selected work orders remain locked and therefore cannot be used in any other function, such as scheduling, release or optimization. Sage… Read More »
