How to flow data in a column of Inquiry Screens

By | September 30, 2021

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.