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 »
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 »
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 »
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 »
You may come across the situation, where you may want to export report in particular file format. This can be done through coding using FITCHIER action. FITCHIER action is called before the display of the selection window for the export format, when the user wants to export the print to a file. This action is… Read More »
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 »
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 »
While working around the complex functionality, it’s very obvious that you may have to deal with the Multiple source files. Multiple file may define the function with same name but with different set of instruction on the same event or the action and you may want call same function from particular file based on some… Read More »
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 »
