Category Archives: Sage ERP X3

How to Concatenate Two Strings

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 »

Automatic Remittance Generation through Batch

In the business process we may need a process wherein the Remittance will be created automatically on daily basis. In Sage X3 we can do this in simple way by using the Batch process. Refer to below steps for the same. Step 1: Create the task follow the below steps for the same: Navigate to… Read More »

How to Create Contract Purchase Order in Sage X3?

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 »

How to Find the Number of Fields Defined in a Screen?

We may come across a situation where we would like to know the number of fields in a Screen if it is open.  Sage X3 has a special feature of getting number of fields in a screen with the help of “masknbf” keyword which will return the value in integer. Syntax:    masknbf(<class | num_exp>) Parameter:  … Read More »

How to Increase the Address Lines for a Customer?

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 »

How to Create a Stock Count in Sage X3?

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 »

How to create the Pre-commitment on Purchase Request?

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 »

How to Setup commitments for a Particular Ledger?

If you come across a scenario where you want to setup automatic generation of commitments then Sage X3 provides a functionality “Commitments” in the Ledger. To set up this functionality: Step 1: Navigation: Set up – Organizational Structure – Ledger Step 2: Check the Commitments in the Type of accounting of ledger.   Now whenever… Read More »

How to assign a default Lot number in Receipt as supplier Lot or Document number?

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 »