You may come across the situation where you want year from particular date. Then you may probably use a format$ keyword function to get the year value. But in Sage x3 version 7 you can use another Keyword i.e. “year”. The type of result is Integer. year: year returns the day number of a valid date, including… Read More »
Sage X3 has a solution which is used to find the number of records in a table with the help of keyword “nbrecord” along condition. In order to know the number of records in the table, perform the below query. The output will be number of the clients available against the corresponding table. About… Read More »
You may come across the situation, where you want to concatenate a char or CLOB value to a char or CLOB variable. Sage X3 has a special Keyword named APPEND to perform the concatenation of two or more string values. From a functional point of view, Append Field1, Field2 is equivalent to Field1+= Field2. if… Read More »
A contract order is a long-term commitment with a supplier concerning one or more products, for a global quantity and value to be delivered. The contract order is further divided in shipment requests that are made as a function of the contract. A contract can also be intercompany or site transfer. These shipment requests are… Read More »
Sage X3 has a feature in which we can increase the address lines for a customer. This feature can be achieved by following below steps:- Navigate to Set up → General parameters → Folders → SEED Under screens tab, there are various activity codes which are used for functional sizing of the screens. To increase… Read More »
We may come across a scenario where you need to copy a BOM which may have same usage with different BOM Code. Sage X3 has a feature in which you can create copy of BOM. Several types of BOM copies are necessary to facilitate the management of the technical data: – First level BOM… Read More »
Stock count is a process of counting inventory on a periodic basis throughout the year. This is a two-step process as explained below- A stock count session is generated to select the products and /or locations to be counted along with other parameters and selection criteria. A Count screen is used to check the count. To… Read More »
Navigate: Common data -> Product -> Product categories Go to Management tab In Lot management section, select Lot management option as Optional lot/Mandatory lot/Lot and sublot. Go to Receipt tab In MANAGEMENT RULES grid, Go to supplier Receipt Select ‘Lot entry’ as Free/New Lot Select ‘Lot by default’ as Supplier Lot/Document number Click on Save… Read More »
While accessing web services in Sage x3 you may get an error message ‘Service Temporarily Unavailable’. This error is related to services- not being started. To overcome this error open Sage X3 Management console and follow the below instructions: – Click on the Web server tab from the left menu. – Select the folder and… Read More »
While creating any transaction in Sage X3, we will often get an error “Product not managed in stock“. Particularly, this error is generated for the products which are not managed in stock. We can overcome this by managing the stock of that particular product. For e.g., We may get this error while creating a miscellaneous receipt.… Read More »
