Author Archives: Greytrix

Greytrix Sage CRM – Sage Enterprise Management Integration – All info about Trial, versions supported, migration et al

When you think of business systems to handle your front office and back office operations, you might think of a number of pitfalls such as data redundancy, manual data entry, investing time, struggling to have a complete view of your customer information, lack of data visibility, inflexibility to access real-time data. This new year 2018,… Read More »

How to validate multiple Entry Transactions in Sage X3

You may have come across a situation where you need to validate multiple Entry Transactions. Instead of validating each Entry Transaction individually, there is an option in Sage X3 to validate multiple Entry Transactions at the same time. Follow the below steps to achieve the same. Browse to Development>>Utilities>>Dictionary>>Transaction Generation Refer the following screenshot where… Read More »

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 Solve “Record already exist error” while creation of Transaction and Masters

We may come across a scenario where we get “record already exist’ error while creation of transactions and masters. The problem can be solved by using below steps: In below screenshot, we have faced an error while creating a product. This error occurs because the product of sequence number BMS089 already exists in the X3 for… 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 modify sales return quantity in Sage X3

You may come across a scenario where you want to modify the customer return quantity after the creation of customer return.Sage X3 have a special feature to achieve this functionality.Follow below steps to achieve this feature: Navigate to Sales -> Returns -> Customer returns (select a delivery from left list and create a customer return… Read More »

How to define filter criterion on database query in Sage X3

In Sage X3 latest versions, we are provided with new feature to define filter criterion on the database. This function defines a filtering condition on a database query. The condition is expressed in Sdata where syntax. This function is only valid inside a Where clause of a database instruction (For, Filter, File, Link). Syntax: Where evaluesdata(EXPRESSION,… Read More »