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 »
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 »
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 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 »
Navigate to: Setup –> Parameter Value –> AAS – FAS – PRVSITUPD Set PRVSITUPD=”Yes “After setting this parameter to “Yes “this will allow the user to enter accumulated depreciable value under the Deprec.total (Refer below image). If an asset was purchased in 1st Jan 2013 and it’s deprecation start date was also same. Asset purchase… Read More »
Errp returns the name of the script where an error occurred. It can be used in the error handling routine set by Onerrgo. Syntax : errp Examples : # Let’s trigger an error (division by zero) Funprog DIV_BY_ZERO Local Integer ZERO, ONE, RESULT Local Char ERROR_MESSAGE(250) ONE=1 : ZERO=0 Onerrgo ERR_HANDLE RESULT = ONE… Read More »
In Sage ERP X3, there is a feature where you can check whether the component used in a product is non-usable or not while creating a work order. This can be achieved by following below steps:- Navigate to Setup → General Parameters → Parameters values Under Module → GPA Manufacturing and Group → Work Order… Read More »