In Sage X3, there is a way to run or trigger the customized code for a particular entry transaction, and then here is the code using which you can trigger the code for a specific entry transaction. New Stuff: How to Assign Default Values to Crystal Reports Example: $ACTION Case ACTION When “FIN_LISTE” : Gosub FIN_LISTE… Read More »
On the supplier-product record, it is possible to define a minimum purchase quantity expressed in the supplier purchase unit. This quantity is used upon order management to check that the quantity of an order line is higher or equal to this quantity. New Stuff: Moving a file from a directory The setup POHMINQTY is used to… Read More »
The main entity for any ERP is its Business Partner, and in X3 we have an important feature which provides the information about all the Business Partners at one click. Path to reach: Customer relation → Identify The “Identify” window of the Customer Relation menu provides access to all the functions of the module. Each function… Read More »
Sage X3 has a special feature of getting the list of files from a directory in a list. Sage X3 has a simple function through which we can easily retrieve the file names present in the specified directory. SYSTEME2: This function can be used to get the file names present in the directory. This function… Read More »
Quality Acceptance sampling is a method to measure the quality of the products at a minimum cost. The Acceptance sampling method was originally developed for the manufacturing industries and but other industries like the pharmaceuticals have stretched out their wings to adopt the sampling method as well. In Sage X3, QC Sampling logic supports the… Read More »
There are many a time when we need to get the aggregate or maximum function but 4GL Language does not offer a syntax for the same. But we definitely have an option to use SQL queries in 4GL and this does the most of the job for us. Just go through the statements mentioned below:… Read More »
Ever ran into a situation where you are asked to enter dimensions (get the below screen shot) for a particular ledger account even if no Dimensions are set against the account. And you are not allowed to do the transaction unless you provide the dimensions to that Account To create/perform transactions in Sage X3 without… Read More »
In X3, we developer may come across with the requirement where we need to filter the local menu values for the fields. There are simple techniques available in X3 to filter the local menu values. Follow the below steps to filter the local menu field records: The M data type of local menu is non-modifiable… Read More »
In ERP Sage X3 we can set the credit limit on different level i.e. Folder level or Company level. By default credit limit is set up on the folder level. You can change the credit limit setting through the following steps: Navigate through Setup > General Parameters > Parameter Values. You will get the below… Read More »
Sage X3 has a very interesting and useful functionality which gives the possibility to manipulate the data in any table in the database, without making checks on the data other than that coherency checks introduced by the internal types of the data like date, character string, numeric values etc. This represents a maintenance operation essentially… Read More »
