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 »
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 »
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 »
In the companies where a user always works on a particular site, Sage X3 provides a functionality wherein a default site can be assigned to a functional profile for all Sage X3 modules respectively. User function profile Navigate: Parameters->Users-> User function profile Go to tab Site Select a Site in a required module to default.… Read More »
We may come across a situation where user needs a “Hierarchical Left List” with tree and node functionality as shown below. In this scenario, you need to do following settings: 1. Creating an Object a. Navigate to :Development->Processing dictionary ->Objects b. Link a Table to the object with Index that should be combination of… Read More »
If we want to open particular word document from an adonix process. We can use “System” command, which makes possible the execution of system commands by recovering where possible the standard exit in an Adonix variable. Syntax: System [ variable ‘=’ ] [ ! | !! ] [ [ server ] @ ] expr_c Where… Read More »
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 »
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 »
There is multiple way of deleting a record in Sage X3. If we do not delete the record using the index the database must read the full table to find the rows to be deleted. That means deleting the row would be fast but finding would be very slow. ‘DeleteByKey’ instruction deletes a record at… Read More »
One of the interesting think in Sage X3 is, how to create the graph in Sage X3? Sage X3 provide the functionality to create the graph in its different version. One can create the different types of graph e.g. Bar, Pie etc. Steps for Setting up the graph are Step 1: Navigate to Development → Script… Read More »
