Tag Archives: greytrix blogs

How to Know Number of Fields Defined in a Screen?

In Sage X3, if you come across a scenario where you want to know count of fields defined in a particular screen, Sage X3 provides an inbuilt function to know number of fields defined within a particular screen. You can use this function if and only if the screen is open. Syntax: masknbf(<class|num_exp>) Where, class… Read More »

Get Year in a Date for Sage X3 version 7

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 »

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 »

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 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 »