Tag Archives: Sage X3 Technical

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 »

How to call a subroutine or methods in Sage X3 using instance

Like any other programming language, Sage X3 also supports functions/methods/subroutines. Though the syntax for defining these functions are different in all languages, the purpose is similar to perform actions and return (or not to return) any result. But, there are certain subroutines which do not return any value as a result. In Sage X3, these… Read More »

How to Close Open Table faster in Version 7 and above?

Sage X3 version 7 has a new Keyword/ function “LogicClose” which closes the open table/file faster than the close instruction of Sage ERP X3 which we used earlier in programming. LogicClose: This function closes a table logically. It releases the [F] buffer and any filters in a way that makes a further Local File execution much faster… Read More »

Setup Multiple Sites for Company when there is One Dedicated Storage Site and Rest are Financial Sites Part- 2 (Contd…)

In some industries where the Company has only one Site which actually store and deliver goods and other sites are only financial sites which manage the payments. i.e the financial sites can be stores and the Storage site is a warehouse where goods are stored. E.g. Car showrooms can be financial sites in different part… Read More »

Mass Deletion of Records in Sage X3

If we want to delete the current record in Sage X3, simply press the Delete button. This deletion is possible only if the “referential integrity” constraints as defined in the data dictionary, are adhered to, depending on the situation. These controls can take a relatively long time to perform, and they are carried out immediately… Read More »