Tag Archives: Sage X3 Technical

Fetch the ADC print destination value in coding

While printing the report through code you may need to print the report or label in the printer defined on the ADC destination .The below mentioned global variable are available in x3 in which the label destination and Document destination are stored GVTETI : This global variable is used to store the  Label destination GVTDOC… Read More »

Enable Warehouse Selection in Customer Return Management Screen

If we come across a scenario where we want to enable warehouse selection field in Customer return Management screen then Sage x3 provides a standard functionality to enable the field. Navigate to Sales ->Returns ->Customer returns Steps to enable this functionality: Navigate to Setup ->Organisational Structures->Sites Enable Warehouse Management checkbox under Warehouse Tab Create Warehouses… Read More »

Split Functionality in Purchase Order

We may have situation where we need to split one order line into many order lines as per business requirement. Sage ERP – X3 provides a feature in which you can split a line based on Rec site, Address, Quantity and Expected Receipt Date.                 To achieve this functionality, Navigate to Purchasing → Orders →… Read More »

How to assign Parameters for Open Sequential File

Iomode is used to assign for each open sequential file, the following parameters: Adxirs, Adxifs, Adxium. Syntax: Iomode ( Adxirs | Adxifs | Adxium ) Expression [using abbrev] where abbrev  describing the open file. Examples: # Read of the first 10 words in the line in sequential files # the fields are separated by ‘ … Read More »

Line Duplication Functionality in Sage ERP – X3

Sage X3 provides a feature where we can create a duplicate copy of the line in Purchase Order. This features can be achieved through Line Duplication functionality in Purchase Order. Below are the steps:- Navigate to: – Purchasing → Orders → Orders Create a purchase order. Click on the action button at the Line Level… Read More »

Issue the Prepayment in Bulk

There might be situation where you want to issue the prepayment in bulk.  Sage x3 provide a feature in which we can issue the prepayment in bulk. To achieve this feature, Navigate To:Sales>invoices>Issue Prepayments The issue of prepayments is made, in mass, simply by selecting a planned issue deadline. You can also print them if… Read More »

How to import customized tab fields using Import Template in Sage X3

In Sage ERP – X3, most of the time, we come across a scenario where we want to import the customized tab fields. For e.g., if you have added a new tab on the Customer Master screen and you want to import these tab fields using import template. By simply adding the fields in Customer… Read More »

How to Find the DAY of the Week

This function is one of the date function which will return the DAY number of the week from which we will be able to perform the other functionality. Function dayn(Date): The “dayn” function excepts one parameter which we need to pass the date for which we need to find the weekday number. Example: Output: These… Read More »

How to Sort Array in Ascending and Descending Order

Sorta-is used to sort arrays of single-dimensioned variables. Sorta, sorts the array in ascending order by default, to sort the array in descending we need to use Desc keyword. Syntax – Where, Sorta – Number Array List Number – number is length of an array or up to which number we want to sort Array… Read More »

Mass Generation of Purchase Order

You may come across a situation where you want to create Purchase order for many suppliers and products. Sage X3 provides a feature in which mass generation of Purchase Order can be done at once. To achieve this functionality, navigate to Purchasing → Orders → Buyers plan. Follow the below steps:- STEP 1 – STEP 2 –… Read More »