Tag Archives: Sage X3

How to Delete Element from an Array?

Dela – Dela is used to delete elements from single-sized arrays, from a given index. Dela deletes the given index element and adds blank value or zero to the end, we need to know the index to use Dela Syntax – Dela Start Array List where, Start : Index element  & Array list :  list… Read More »

How to Create Manual Transaction Number for Purchase Order and Purchase Receipt?

In Sage X3, we may come across a scenario where we want to create transactions with any ID of any choice. By default, every time we create a new transaction, Sage X3 itself generates the next sequence number and assign it to the newly created transaction. But, it is difficult to remember this auto generated… Read More »

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 »

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

Determine the Length of Data Type, Whose Internal Type is Alphanumeric

It’s Very obvious to declare the variables while developing any kind of application. These variables contains a value for particular field. While declaring this variable, we have to set the length of the variable. Two obvious way to set length and corresponding disadvantages: Check with the length of the field data type of that field.… Read More »

Determine PO line Closing Method using Delivery Tolerance %

You may come across a scenario where we want to set closing criteria for a purchase order taking into account the quantity that you receive. To set the closing criteria, go to Product → supply tab → purchasing. There is a field “Delivery Tolerance %” which is used during the receipt of goods. It is… Read More »

How to know a Mask Variable is Initialized or not?

In Sage X3, sometimes you may have to check for the initialization of a particular mask variable. Sage X3 provides an inbuilt function to do the same. Below function is used to know whether a mask variable is initialized or not. varinit ( zone_name [, exp_index ] ) Where, Zone_name :     [ class ] name_of_variable.… Read More »

Integrate Salesforce with Sage X3 using GUMU™ Connector

Every organization in order to achieve continuous growth should engage itself in integrating its business software solutions. When the focus is on achieving immediate revenue targets, planning and integrating functional software tools and applications with ERP solution often takes a backseat. As a result of these disconnected software solutions inefficiencies creep in, manual data entry… Read More »

How to Restrict Purchase Order for the Product having Expiry Date?

If you come across a scenario where you want to restrict purchase order for the product which has an expiry date then Sage X3 provides a standard functionality called “Product end-of-life date”. Product end-of-life date: when this date is exceeded, it is not possible to enter orders to the supplier. To set up this functionality:… Read More »