Tag Archives: Sage X3 technical blogs

How to update a header field through workflow

Sometimes we may come under a situation where we need to update a field in the same time when the workflow gets triggered. To update field on running workflow firstly we need to select a workflow rule. i.e at what action you need to update the field (For eg: on Validation, rejection, notification, cancellation etc).… Read More »

How to add the Dashboard in Sage X3 Version 12

In some requirement, user may wants to see some reports when they login to the Sage X3, or for the management people thy need to see the any sets of records like Open Sales Order, Open Invoice, outstanding and many more on the login of the Sage X3. We can achieve this by following the… Read More »

How to enable Accounts mapping section under Accounting Code in Sage X3

In Sage X3, when a new folder is created we may come across a scenario where we don’t see a column to map accounts in Accounting code lines. Below screen capture depicts the navigation to enable the column: Navigate to Setup–>Financial –>Accounting interface–>Accounting Code Step 1: Navigate to Setup –>General Parameters–>Parameter Values. Step 2: From… Read More »

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 X3

In Sage X3, 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 X3. <<Code snippet>>Local decimal DLocal… Read More »

How to display customized field in Inquiry screen in Sage X3

In Sage X3, 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 the… 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 »