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: Executing an SQL Query Using 4GL Language »
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: Dimensions check for the Ledgers in Sage X3 »
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: How to filter Local Menu in Sage X3 »
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: Set Customer Credit Limit Level »
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: Modify Data of Tables in Sage X3 »
In Sage X3 standard functionality, we are not allowed to add a ‘not-managed’ product in the Work Order. We can only add Managed Products in Work orders. In one of our development, we face the same scenario. While creating a Work Order through Production BOM we added ‘TEST1’ as our Parent Product and ‘TEST2’, ’TEST3’… Read More: Including ‘Non Managed’ Products in Work Orders »
There may be a situation when sometimes user needs to change the computer name for the server where Sage X3 is already configured, but as soon as the server name is changed the Sage ERP X3 solution will no longer work. In this blog, we will see how to reconfigure the Sage X3 solution again… Read More: How to Reconfigure Sage X3 Solution After Changing the Computer… »
The Inter-site transfers function is used to intervene on a stock line or a group of stock lines so as to transfer stock from one site to another for one or several companies. The Inter-site transfers function is used to intervene on a stock line or a group of stock lines so as to transfer stock from… Read More: How to perform an Inter-Site Transfers in Sage X3 »
In Sage X3, we have different invoicing elements like Freight Charges, Discount %, Discount $ etc. that are used for applying the discount/charges on the orders/shipment lines (Refer below screenshot). Now if we are updating these freight elements from third party system via integration we use modes like web services and for this we need… Read More: Determine Position of Invoicing Element »
Sage X3 provides the feature of Re-opening the Closed Purchase order to add an additional line or edit the existing one. The function which provides this feature is “Close and Re-Open orders”. To navigate through this screen we need to go to Purchasing > Orders > Close and Re-Open Orders (Process name is FUNCLEAR). You… Read More: Re-Open Closed Purchase Orders in Sage X3 »
