Tag Archives: Sage X3 Technical

How to solve “At least one runtime must have a max queries number defined” issue in Sage X3 Ver 11

We may come across a scenario where we get “At least one runtime must have a max queries number defined” error while creation/start up of Batch Server. The problem can be solved by using below steps: In below screenshot we have faced an error while creation/start up of Batch Server. This error has occurred because… Read More »

How to add analytical dimension in report parameter

In Sage X3 we have come across a situation where we need to add analytical dimension in report parameter. Example: Let us consider adding analytical dimension Cost Center for report parameters. In Report Dictionary –>Parameters we will add the Parameter filed Cost Center with its respective type i.e. CCE. Now in Object/dependency parameter we will… Read More »

Auditing Connections in Sage ERP X3

Sage ERP X3 has come up with an interesting feature through which users can now easily monitor or Audit connections in Sage X3. These can be done whenever the AUDIT activity code is activated, the sage software is able to trace all the connections/disconnections to the current folder. These data stored in the ALOGIN table,… Read More »

How to find out the Local menu number of any message

You may come across the situation where you get any error message, and you need to find out the local menu of that message. You can go to the >>Transaction>>text search Hope this helps!   About Us Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance… Read More »

How to force the display of the fields in a mask

Envzo forces the display of the fields in a mask. Example : # in record deletion # the’OBJect controls the links with the table dictionary # each analysed table is displayed in this window $VERF For [A_TZ]LIEN(2) Where LIEN=FICANU & ANNUL=1 FICHIER = [F:A_TZ]CODFIC Read [A_TB]CODFIC = FICHIER If !GSERVEUR & !GIMPORT If [M:VLC]NUMERO=”” [M:VLC]TEX… Read More »

How to Prohibit Zero lines in Invoice

We came across the requirement where client wants to disallow the user from entering Zero Amount in line level in Invoice. In Sage X3 we have setup in Parameters values where we can stop the user to enter zero values in line level. Goto–> Setup–> General Parameter– Parameter Values -TC Commondata- We need to enter… Read More »

Inactive/active setup for assets import

In Sage X3, we may come across a scenario where we want to import fixed assets by using an import template. As imported asset is automatically considered as “Inactive”, Sage X3 has a functionality where we can set the imported parameter to”Active”. Navigate To: Set UP>General parameter>Parameter values>AAS Fixed assets Fixed Assets Parameter Set-up Screen-1… Read More »

How to extract a left sub-string from a given string in Sage Enterprise Management?

In Sage X3, we may come across various scenarios where you need to get sub-string from an existing string. We can derive sub-string from both the ends i.e. From the Left and from the right or start from a particular position of a given string. This blog will help us to extract the leftmost sub-string… Read More »

Sage Enterprise Management (Sage X3) Version 11 – What’s in it for your business?

What brings an update for Sage X3? Sage Enterprise Management – ERP is the next generation business management system that accelerates your core business processes by integrating them and adapting to meet your enterprise requirements. It is a fully established business management system encompassing financial management, manufacturing process management, customer relationship management, project management, sales… Read More »

How to find number of Variables defined in a Class

In this blog, we will look how to find the number of variables defined in a class. Sage X3 has the solution to know with the help of keyword “clanbs”’ along condition. Clanbs return the number of variables existing in a class or the number of symbols allocated to a variable class. Syntax: clanbs(<Class/ num_exp>,symb_exp)… Read More »