Tag Archives: Sage X3 technical blogs

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 display customized field in Inquiry screen in Sage Enterprise Management

In Sage Enterprise Management, we can add a customized field in existing inquiry screens. To reflect the changes we perform entry transaction validation of respective Inquiry code. However, sometimes, it may happen in spite of validating it the changes do not reflect. In such cases, you need to check whether you have set order for… Read More »

How to disable delete and insert button in line level of grid

While we add a grid in the screen, it automatically takes option as KARID refer Fig 1.1 because of which insert and delete button get enables in the grid refer Fig 1.2. Details of KARID refer to the previous blog: We might come across the situation where we have to disable the insert and delete… Read More »

Writing Standard Function Error into Log

In Sage Enterprise Management, there might be a situation where we would need to write a standard function’s error box message into your log. For example, consider the COPCLI function. So refer the below code snippet- Hope this blog helps! About Us Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution… 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 »

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 »