Tag Archives: Sage ERP X3

How to get Folder Path in Sage X3

You may come across the situation where you need to access the physical folder path in Sage X3. It could be easily achieved with the help of the keyword ‘filpath’. filpath: Filpath creates the access path to a file on a Sage ERP X3 application server. Syntax: Current_Folder_PATH=filpath(“”, “”, “”) Specific_Folder_PATH =filpath(“”,””,””,”Folder_Name”,””)             Parameter Details: Folder_Name:… Read More »

How to Replace Component on work order – Method 1

When it is necessary to substitute components or material on a Work Order BOM, Sage X3 allows the replacement of components on a Work Order if the Product’s Routing allows it. Following are the two methods for replacing a component with a substitution product Method 1: Remove the original component Method 2: Replace a component.… Read More »

How to Allocate the Bulk Work Order

We came into circumstance where one of the Client asked to allocate the bulk work order. Sage X3 provide feature to mass allocation processing of the materials linked to the production for a given site, a given period and a selection of a work orders. This processing can allocate material in a global or detailed… Read More »

Restrict deliveries for Customer’s non-working days in Sage X3

The Customer working day’s logic works on the Delivery date. Therefore if a particular work day is unchecked in the Customer – Ship to tab then the Delivery date cannot be chosen on the unchecked work days. However working day’s logic does not affect the Shipment date. Navigate: All -> Common data -> BPs ->… 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 »

How to 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 ERP – 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… 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 »

How to Find the Last Date of Any Month

You may come across the situation where you have to find the last date of any month whether it is 30, 31, 28 or 29. To do so we can take help of EOMONTH function. Syntax: eomonth(DATE_EXPR) DATE_EXPR is an expression returning a date value. Consider following example where we have to find out the… Read More »