Author Archives: Greytrix

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 »

ERP – CRM Integration: Co-relation between Real time metrics & Business Value

Scenario of business with management systems Do your business representatives still manually enter processed Orders from the CRM system to ERP? Are they tied to their office desktops to access any vital customer data? Are sales forecasting and generating reports becoming a tedious task and creating a roadblock for seamless business operations? It’s time –… 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 Beautify Web-service Output in Sage X3 PU9

In Sage X3 version 9 when your run web service through ‘Classic SOAP Web services’ the output appears in unreadable format as shown in below screen. To retrieve the output in readable XML or JSON format. Enter the below input in “Request Configuration”  field. For Output in XML format : “adxwss.optreturn=XML&adxwss.beautify=true” For Output in JSON… Read More »