How to flow data in a column of Inquiry Screens

In Sage X3, we have Inquiry screens which display all the information from tables based on a certain filter criteria. We recently had a requirement to add Description 2 and Description 3 fields in the Inquiry Screens. In this blog we will see how we can manually display Description 2 and Description 3 of a product from ITMMASTER table.

To add the customized fields in the Inquiry Screen refer the blog: How to display customized field in Inquiry screen in Sage X3.

To flow the data of Description 2 and Description 3 into the inquiry screen we will use the standard script of the Inquiry screen.

Here let’s take the inquiry screen of Stock by Product from Stock module, here we have added Description 2 and Description 3 fields.

New Stuff: How to default Validity date to certain days from Date of creation for Sales Quote module

[Product Stock (Stock by Product)]
[Product Stock (Stock by Product)]

To flow the Description 2 and Description 3 of a product from ITMMASTER table to the screen we will have to write a script. We will use the Standard Script of Product Stock product, CNSSARSTD.

To get the Standard Script go to Development ->Script Editor. Type the Standard Script code and select the X3 folder. Copy the code and paste it to your end.

[CNSSARSTD Script of X3 Folder]
[CNSSARSTD Script of X3 Folder]

In the Standard Script CNSSARSTD look for LECTURE, and add the code at the end of LECTURE section.

[Script of product flow at the end of LECTURE]
[Script of product flow at the end of LECTURE]

Now change the folder to the folder where you added the Description Fields and paste the code in that script of the folder. For Example, here our folder is IIPL1 so we will place the code here.

[Script in the main folder]
[Script in the main folder]

Now, when you go to the Stock by Product screen and search based on the filter you will get the Description 2 and Description 3 fields based on the product from the ITMMASTER table.

[Stock by Product Output.]
[Stock by Product Output.]

In this way you can add customized fields in the Inquiry Screen and Flow data from the LECTURE in the Standard Script.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation competence. 

Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide. Greytrix Sales Commission App for Sage X3 simplifies commission calculations and postings on sales transactions.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com, We would like to hear from you.