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)]

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]

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]

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]

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.]

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 Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, 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 has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3, Sage Intacct, Sage 100, Sage 500, and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.