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.
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.
In the Standard Script CNSSARSTD look for LECTURE, and add the code at the end of LECTURE section.
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.
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.
In this way you can add customized fields in the Inquiry Screen and Flow data from the LECTURE in the Standard Script.