Tag Archives: Sage X3 Technical

How to Use a not-usable Component in Work Order

In Sage ERP X3, there is a feature where you can check whether the component used in a product is non-usable or not while creating a work order. This can be achieved by following below steps:- Navigate to Setup → General Parameters → Parameters values Under Module → GPA Manufacturing and Group → Work Order… Read More »

How to define base quantity of Finished goods in Production BOM

Navigate: Common data>>BOMs>> Production BOM Select a Parent product Enter the mandatory fields’ details. Select the entry unit. The base quantity will get updated as per the selected unit. In this example, the COM005 & COM006 will be used to produce Quantity of DIS013 Therefore in a Work order, the FG will be produced on… Read More »

How to set default import parameters in Sage X3

In Sage X3, you may come across a scenario where you may need to set the fixed path for archival and error directories of import files. Generally, in Sage X3, data is imported using template functionality. It behaves in below two ways: If you import proper data file, then it will move to Final directory… Read More »

Folder Validation Using Batch Process

You may have come accross a situation where Folder Validation gets interrupted due to user/browser timeout. For achieving uninterrupted folder validation, batch process can be used. Example: Let us assume that a Folder named “SEED” needs to be validated. Now, to validate the folder using batch process, follow the following Steps: Go to Usage>Batch Server.… Read More »

How to find out any special character is used in a text

You may come across the situation where you have to find out whatever any special character is used in a text or not, parse allows you to analyze an expression contained in a character string syntactically. Parse, returns zero (0) when the expression analyzed is syntactically correct – or, otherwise, a non-null value that corresponds… Read More »

How to find current user in Sage ERP X3

In Sage X3, you may come across a scenario where you want to find the logged-in details of a current user. In that case, Sage X3 has the function called “Adxusr” through which users can achieve this feature. Description: “Adxusr” contains the connection user. Syntax: [S]Adxusr(12) Char Kindly refer to the below snippet of code… Read More »

How to print “Stock Valuation Report” in Sage X3

We may come across a scenario where we want a stock Valuation report by different Valuation methods (Such as Average, FIFO, LIFO etc). This can be achieved by using the “Stock Valuation report”. To achieve this functionality, Navigate:- Inventory >  Periodic processing >  Valuation >  Stock valuation report Depending on the selected Costing mode respective values… Read More »

How to determine the characters of the user entry types in sage ERP X3?

Adxtuc determines the characters of the user entry types. You may define types of entry that will be added to – or even substituted by –  standard types within an Adonix application. These extra types are described by one letter: their “code.” Syntax: [S]adxtuc (33) (32) Char Example: Output: Description : You may parameterize 32… Read More »

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 »