It is easy to get the parameter value when the value is defined at folder level. But what if we need the parameter value by User? Well! This blog will help you to get the parameter value by site with the help of the standard subprogram which is present in SUBAUS.src file. Below is the code… Read More »
To implement the business logic we need to use SQL Query to fetch the required data from the Database. To execute the SQL Query from Sage X3 we need to know the database type. We can fetch the database type as below: The “TYPDBA” column in “ADOSSIER” table holds the value which will help to identify… Read More »
Mass copy of accounts function is used to carry out a mass copy of number of Accounts with a given range from one folder to another. In accounts transfer by giving the range of accounts, the given range account will be copied to another folder. In the following example, the account range from 1010 to… Read More »
You may come across a scenario where we want to set closing criteria for a purchase order taking into account the quantity that you receive. To set the closing criteria, go to Product → supply tab → purchasing. There is a field “Delivery Tolerance %” which is used during the receipt of goods. It is… Read More »
In many manufacturing and distribution companies, it is a top most priority to have user security in place. For e.g. a purchase executive may issue a purchase order on a purchase request but only a purchase manager can approve a purchase order (w.r.t. quantity, price, discount etc.) Sage X3 provides 4 levels of user securities… Read More »
In Sage X3, sometimes you may have to check for the initialization of a particular mask variable. Sage X3 provides an inbuilt function to do the same. Below function is used to know whether a mask variable is initialized or not. varinit ( zone_name [, exp_index ] ) Where, Zone_name : [ class ] name_of_variable.… Read More »
To make the Invoice Printing mandatory before posting, following parameter is available in Sage X3. Parameter: SIVCFM (Mandatory invoice printing) Path: Setup > General Parameter > Chapter (TC) > Group (INV) > SIVCFM This parameter is used to stipulate the validation of invoice in the printed report The list of possible values are: Yes: The… Read More »
If we want to debug the code on version 7 or on any higher version, eclipse will help us in that. We cannot get the window back if we knowingly or unknowingly close the debugging window. Sometimes we may need to uninstall or re-install eclipse, even if we click on debug button. This issue can… Read More »
If you come across a scenario where you want to restrict user from creating a sales order for net price less than minimum price then sage X3 provides a standard functionality Non block ctrl price,profit,qt. Navigation: Setup –> General parameters –> Parameter Values Sales – Authorization — SDACLOK (Non block ctrl price,profit,qt ) Set Non… Read More »
If you come across a scenario where you want to restrict purchase order for the product which has an expiry date then Sage X3 provides a standard functionality called “Product end-of-life date”. Product end-of-life date: when this date is exceeded, it is not possible to enter orders to the supplier. To set up this functionality:… Read More »