Author Archives: Greytrix

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 »

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 make parameter visible on Parameter value screen in Sage X3

In custom Sage X3 development, we frequently use parameters for the use of constant values.  Here we have an option to control the visibility of parameter on Parameter Value screen. Navigate to : Development>Data and parameters>Development setup>Parameter definitions Check the Changeable checkbox and click on save button. Now navigate to : Setup > General parameters… Read More »

How to call web service in Sage X3 Version 9 (PU9) using .NET applications

In Sage X3 Version 9 there are some changes with respect to authenticating process of web service while connecting form third party application like .NET. From PU9 onwards it’s mandatory to pre-authorize the connection with the username and password. Let’s see in details with .NET code snippets. Inherit the Sage X3 class ‘CAdxWeServiceXmlCCServiceBasicAuth’ which helps… Read More »