We have a scenario where we need to copy all the values from screen one to screen two for display. To execute this functionality we have two option as follow: [M:xxx]=[M:yyy] Transmask[M:xxx] to [M:yyy] In this blog we will be detailising on Transmask where it copies the all the field from source mask to destination… Read More »
You may have come across a situation where a Question box needs to be displayed to user and depending upon the response; a block of code needs to be executed. Syntax: Qstbox “[Message that needs to be displayed]” Using [L] Rep Where REP is a local libelle Example: Consider an example where a dialog box… Read More »
In Sage X3 while performing deferred deletion we may get the below error message.”Deferred deletion is not active for this object”. Navigate to: Development > Utilities > Miscellaneous > Deletions To avoid this message navigate to Development > Processing dictionary > Objects Checked the Deferred validation checkbox. Save and validate the object. Hope this blog… Read More »
You may come across the situation, where you may want to give user-level access to fields present on Screen. In this case first create access code by navigating to below given path. Setup → users → access code Now assign this access code on required fields as shown below. Now this fields are accessible to… 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 »
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 »
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 »
