Category Archives: Configuration

How to get template name through coding while using Import/Export Template

We might come across the scenario to find template name through the mask. We can also access using standard table name(AOBJEXTD) with abbrevation[AOD] and field name EXT. Refer to the screenshot below: Write code below in specific script ‘YPEIMPBIS’ of import/export template. Example: $Action Case Action When “IMP_OUVRE”:infbox “Script Name:”+num$([F:AOD]EXT) EndCase return The result is:… Read More »

Timestamp$ function in Sage Enterprise Management

In Sage Enterprise Management, We have function timestamp$ which returns a string value containing a time stamp, which is the number of milliseconds elapsed since the first of January 1970, at 00:00:00 time GMT. timestamp$ returns a timestamp in ASCII format. Below is the snippet of example code provided by standard Sage Enterprise Management. <<Code snippet>> Local… Read More »

How to create Arrival document formula (Enterprise Management HR)

In Enterprise Management HR, we may come across a condition where we may need to create Arrival document formula. This can be achieved with the below steps:- Navigate to Personnel Administration –> Administrative Documents –> Document formula Code:- Create the code for the formula. Title:- Specify the Title Type:- The type will be Employee as… Read More »

Enable the menu button in Sage Enterprise Management

In Sage Enterprise Management, when we add the menu button and its lines in any window it is disabled by default. Perform the following to enable this menu buttons. Here, CHMEN is the keyword to enable the menu button. And “Z6” and “Z5” are the button code. Hope this blog helps! About Us Greytrix – a… Read More »

To fetch current line value from Grid in Sage Enterprise Management

Sometime, we need a particular value from a line in order to calculate, copy or for some other use. We can just fetch that value using nolign-1  nolign-1 fetches the current value of the field form the grid. For example: If we want to know the item description of any selected product, perform the following.… Read More »

How to assign the Sequence counter as per specific Document type

Earlier, we have one way of assigning the sequence counter to the transaction through the General Parameter → Sequence Number Definition → Assignment. We have an additional option, where we can assign the sequence counter to the transaction type through the Document Type. Navigate through Parameters → Sales/Purchase → Document Type → Transaction Hope this helps! About Us… Read More »

How to call Third Party REST service from Sage Enterprise Management

We have come across the requirement where you need to call Third Party REST services from Sage Enterprise Management. This can be achieved with the below steps. Create a REST API inside Sage X3 with the using the REST URL and the authentication credentials under Administration | Administration | Rest Web Services. Here, Name is the… Read More »

Extracting a variable length amount from a file line

There might be a situation where we would need to read a file and extract a variable length amount from a line. So, consider an example string/file line- “abcdef1122,52pqr”. Here the amount which we need to extract is “1122,52”. Refer the below code snippet- Here, First, we find the position of “,” and store it… Read More »

How to enable application menus in folder after installation

In post versions of Sage X3 when we complete the installation, all the applications menus can be seen directly after login but EM 12 the process is bit different. When you create a solution and create an endpoint for the first time you can access the folder but to enable the menus in the application… Read More »

Free product set-up on Sales Order in Sage Enterprise Management

We may come across a scenario where we want to give a free product on a particular product. We can achieve this feature by doing the below configuration. Let’s say ‘FIN014’ is a parent product and on this parent product user want to give the same product for free if the criteria match with the… Read More »