Category Archives: Features

How to use Entry point to set MAXMEM by user in Sage ERP X3

eatures:  maxmem determines the maximum amount of memory that can be used by the application and modifies this parameter Entry Point: INIVAR It defines certain values of the specific/custom user parameters on entering X3 pr in the situation of a user change, during the declaration of global variables. This entry point is used to give… Read More »

How to Calculate Permutation in Sage X3

Sage X3 provides a special function to calculate permutation of any integer value. The function anp() calculates the number of permutations (for example, ordered arrangements) of p objects taken from n. Syntax for the same is : Syntax: anp(N,P) where, N and P are integer expressions. P must be in the [0,N] range. Example: Fig.… Read More »

How to find out creation and modification date and user of any transaction

You may come across the situation where you need to find out creation and modification date and the user who modified and created and transaction To do so go utilities ->> Properties of any transaction shown in below screenshot. About Us Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution… Read More »

How to change Quantity in Purchase Receipt screen

In Sage X3, we may come across a scenario where we want to change the quantity in the purchase receipt screen. This functionality can be achieved by following steps: Navigate to:  Purchase → Receipts → receipts In this screen, when you try to change the quantity of the product, it wouldn’t allow you to change… Read More »

How to validate multiple Entry Transactions in Sage X3

You may have come across a situation where you need to validate multiple Entry Transactions. Instead of validating each Entry Transaction individually, there is an option in Sage X3 to validate multiple Entry Transactions at the same time. Follow the below steps to achieve the same. Browse to Development>>Utilities>>Dictionary>>Transaction Generation Refer the following screenshot where… Read More »

How to modify sales return quantity in Sage X3

You may come across a scenario where you want to modify the customer return quantity after the creation of customer return.Sage X3 have a special feature to achieve this functionality.Follow below steps to achieve this feature: Navigate to Sales -> Returns -> Customer returns (select a delivery from left list and create a customer return… Read More »

How to define filter criterion on database query in Sage X3

In Sage X3 latest versions, we are provided with new feature to define filter criterion on the database. This function defines a filtering condition on a database query. The condition is expressed in Sdata where syntax. This function is only valid inside a Where clause of a database instruction (For, Filter, File, Link). Syntax: Where evaluesdata(EXPRESSION,… Read More »