Tag Archives: Sage X3 Technical

Sales Price Inquiry on the Sales Order Screen

You may have come across a situation where you would like to know from where the price is coming on sales order. Sage X3 has standard functionality where user can do the price inquiry by using the “sales price inquiry” (Refer the below screen shot) Navigate To: Sales>Sales>Orders>Lines tab Note: The Sales price inquiry screen can… Read More »

How to Execute Recurring Batch Task Only Once

Sage X3 provides the recurring batch task functionality to execute a particular task after certain time period. Like if a user wants to schedule a task to be executed weekly or monthly, user can schedule his task. A user can define properties of recurring task such as starting time and ending time, frequency etc. It… Read More »

How to Do Entry Transaction Validation of Inquiry Screens

In Sage X3, you may come across a scenario where you have to do customization on any inquiry screen. For screen level changes, we simply need to make the changes and validate the corresponding screen. But, it will not reflect the changes unless we do entry transaction validation of that Inquiry screen. This validation is… 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 »

Finalize the journal entries in bulk

You may come across a scenario where you want to do the journal validation in bulk. Sage X3 has feature where you can Finalize or validate the journal entries in bulk. Navigate To: Financial>Current processing>Final validation (Refer the below screenshot)   In this process you can select the different criteria. This function changes the journal… Read More »

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 »