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 »
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 »
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 »
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 »
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 »
We may come across scenarios where we want to delete Supplier Intercompany Invoice. To achieve this functionality follow below steps: Navigate to General Parameter>Parameter values>TC Common Data>Folder>INV Group>SIVSUP parameter. You will see that parameter value of SIVSUP is set as No, change it to yes. Now navigate to A/P-A/R Accounting>Invoicing>Supplier Intercompany Invoices. In above screenshot,… Read More »
You may come across the situation where you have to find out whatever any special character is used in a text or not, parse allows you to analyze an expression contained in a character string syntactically. Parse, returns zero (0) when the expression analyzed is syntactically correct – or, otherwise, a non-null value that corresponds… Read More »
In Sage X3, you may come across a scenario where you want to find the logged-in details of a current user. In that case, Sage X3 has the function called “Adxusr” through which users can achieve this feature. Description: “Adxusr” contains the connection user. Syntax: [S]Adxusr(12) Char Kindly refer to the below snippet of code… Read More »
We may come across a scenario where we want a stock Valuation report by different Valuation methods (Such as Average, FIFO, LIFO etc). This can be achieved by using the “Stock Valuation report”. To achieve this functionality, Navigate:- Inventory > Periodic processing > Valuation > Stock valuation report Depending on the selected Costing mode respective values… Read More »
