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 »
Have you came across a scenario where you want to create the pre-commitment on purchase request after declaration of budget sage ERP? Sage X3 has a standard feature where we can create the pre-commitment in sage x3. Follow the below steps 1. Navigate To: Set up>Parameters>Parameters values>ACH purchase Set the parameter CMM(Budget control)>PURCMM=”Yes” 2. Navigate… 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 »
Sage X3 provides a way to change the posting date of the transaction later after creation. Function: FUNIPTD (Posting date modification) Navigation: Inventory > Utilities > Valuation > Posting date modification Description: Function allow user to changes the posting date of the truncation created in Sage X3. Kindly refer to the below steps: Step 1:… Read More »
If you come across a scenario where you want to restrict sales order for the product which has a service start date then Sage X3 provides a standard functionality “Product start-of-life date”. Product start-of-life date: it is not possible to enter sales orders for this product before its start-of-life date. To set up this functionality:… 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 »
