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 »
We may come across a situation where we want to validate multiple stock entry transactions at a time. This can be achieved in Sage X3 by “Validate Stock transactions”Screen. Navigate: Setup -Stock -Entry Transactions – Validate Stock transactions Step 1: Select Stock Transaction Type Step 2: Select Entry Transaction Type Step 3: Click on OK… Read More »
In Sage X3, we can enter the Postal code on the addresses of entities as Company, Site and all the BP entities (BP, Prospect, Customer, Supplier, Carrier and Sales rep). In Sage X3, we can manage the entered postal code by verifying with existing postal code. Kindly follow the below steps to enable this validation.… Read More »
We may come across a scenario where we want to lock the folder in Sage X3. Sage X3 have a special feature to achieve this functionality. Follow below steps to achieve this feature: Click on Welcome Panel. Select Sage X3 folder (Refer below screenshot). Now navigate to Development > Utilities > Folders > Folder lock… Read More »
One of the date function which will return the number of days passed between 1/1/1600 and the parameter date. Syntax : nday(date_exp) Parameters: date_exp – date expression Example : X = nday(date$) Description : The nday function allows us to go from a date to a number of days. We may replace nday(DATE) with DATE… Read More »
We may come across scenarios where we want to issue a Supplier Intercompany Invoice. This functionality can be achieved by the following step: Navigate to A/P-A/R accounting>Invoicing>Supplier Intercompany Invoice. When Supplier Intercompany Invoice screen open it will show below error message: To overcome this error message navigate to Set up>General Parameters>Parameter values>TRS Business partner>Folder>INV Group(Invoicing… Read More »
In order to automatically allocate work order. Sage X3 provides a feature to automatically allocate work order in a global or detailed manner. To successfully bring this functionality follow below steps Navigate to: Set up >> Manufacturing >> Entry transactions>>work orders Select Allocation method in the parameters tab. About Us Greytrix – a globally recognized… Read More »
