Author Archives: Greytrix

How to skip entry transaction pop-up and select a default entry transaction?

You might have come across a situation where you might have to open a window via code. Here, if there are multiple entry transactions for the window, then the Entry Transaction Dialog will pop-up and would require the user to manually select the Entry transaction before the opening of the desired window. This can be… Read More »

How to hold a Payment of particular Supplier in Sage Enterprise Management (formerly Sage X3)

We may come across a scenario where we want to hold a payment of particular supplier. Navigate to the supplier for which you want to hold the payment. Follow below steps to do the same: Go to: Common Data > Bps > Suppliers > Management tab. Tick the checkbox ‘Payment Hold’ and click on save button.… Read More »

How to set report destination by user in Sage Enterprise Management (formerly Sage X3)

You may come across the situation where you need to set different report destinations for different users. To set the destination user go to Set up >>Destination by user Select a user for which you want to set a destination, report name, and destination. About Us Greytrix is a one-stop solution provider for Sage ERP… Read More »

How to Know Current User Code in Sage X3

In Sage X3, there exist some standard global variables which provide information regarding current functional processing. For eg., current function, current user, a name of current user etc. The global variable GUSER provides a code of a user which is currently logged into Sage X3 applications. You can easily use this global variable into your… Read More »

How to get the message for numeric error code when an error occurs

errmes$ returns the message associated with a numeric error code available when an error occurs. It is frequently used when the error code errn is used, in the error handling routine set by Onerrgo. Syntax : errmes$(INT_EXPR) where INT_EXPR is an expression returning an integer value Example: Let’s trigger an error (division by zero). Description… Read More »

How to get Log File name generated using openlog in Sage X3

We can generate logs using openlog. Also, it is possible to get the name of the log file generated using getlogname() function.  Syntax: LOG_FILE = getlogname() This function returns the file name of the last Sage ERP X3 engine log. When the log mode is activated, a file located in the ‘TMP’ subfolder of the folder… Read More »

How to generate simulated accounting entries in Sage X3 Version 11

In Sage X3 we come across issues related to accounting effects not getting posted correctly. Issues such as account missing and unbalanced journals. To rectify such issues we need to find the accounting effects which are getting triggered during the posting of any journal. To debug this Sage X3 provides an inbuilt functionality “Simulated Entry… Read More »

How to find Exponential in Sage Enterprise Management (formerly Sage X3)

You may come across the situation where you would like to know the exponential of the value. exp function returns its parameter’s exponential. Description and Comments This function returns the parameter’s exponential (power of e). exp is the inverse of the In function. The result type is Double. Syntax exp(num_exp) Element – num_exp Description – Numeric Expression Restrictions… Read More »

How to fetch Folder Language using Global variable in Sage X3?

In our earlier blog, you may have to fetch the Language using the variable “messname”. There is another way to fetch the folder language is using the Global variable “GLANGUE”. The variable will return “CHAR” type value. Please refer below screenshot for the syntax. Hope this blog helps! About Us Greytrix is a one-stop solution… Read More »

How to find Total Payslip Count (Sage X3 People)

In our recent blog “Headings, Variables and Totals (Sage X3 People)”  we have discussed Headings, Variables, and Totals. Now we are going to see about Payslip Count.  PAYSLIP:- It is a piece of paper received by an employee showing how much salary they have been paid in the current pay month. “Generally Payslip are being created… Read More »