Author Archives: Greytrix

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: How to determine the characters of the user entry types… »

How to Open a Word Document from an Adonix Process

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: How to Open a Word Document from an Adonix Process »

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: Sales Price Inquiry on the Sales Order Screen »

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 Execute Recurring Batch Task Only Once »

How to Delete a Record in Sage X3 by using Table Index (Key)

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: How to Delete a Record in Sage X3 by using… »

How to Disconnect the User when you get BADGE issue

You may come across the situation where you are getting the badge issue while Logging in Sage X3. It may be due to some user session is not disconnected. Here you can disconnect the user from the web client session. Navigate to: Administration -> Session management -> Web client session After disconnecting the user you have… Read More: How to Disconnect the User when you get BADGE issue »

How to add Report in the List of Transaction Print Option

To access a report we need to add the report in respective screen from where we can print it. Following are the steps to achieve the same:- 1)  Create new report dictionary. →After creation of a report, create the report dictionary. Navigate to: Development – Script dictionary – Reports Enter all the details, make sure… Read More: How to add Report in the List of Transaction Print… »