Author Archives: Greytrix

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 »

Sage CRM adds more to your business operations tracking; goes beyond sales & customer relationship management

Pressing need for business systems With growing businesses and expanding customer base, enterprises face the distinct challenge of balancing agility against scale, streamlining critical processes, understanding prospects, and managing deeper connections. Business systems have evolved considerably over the years and are now more advanced than before. Today, businesses have invested in the infrastructure and technology… Read More »

How to get the Length of a Character String in Sage X3?

In Sage X3, we may come across various scenarios where we need to get the length of a character string from an existing string. Sage X3 provides “LEN” keyword which returns the length of a character string. Syntax: len(expr_c) Example: # Display the content of the variable DATA with blanks spaces to 25 characters. Output:… Read More »

How to solve “Valuation Method Not Found” error

We may face an error that “Valuation method not found” during the creation of miscellaneous receipt. Follow steps to overcome this error: Below is the screenshot of the error message you may face during the creation of miscellaneous receipt. To solve this error Navigate to Products >Products Site>Cost tab (Refer screenshots). Select Valuation method from… Read More »

Using Index in Sigma Function in Sage X3

In Sage X3, the Adonix system variable “indcum” is the total index used by default in the sigma function. The sigma syntax that uses indcum is quicker in execution than the one that uses a variable. Syntax: [S]indcum Integer When you use the sigma function with the following syntax: sigma(beginning_index,ending_index,expression) The expression is recalculated for indcum… 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 »