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.
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 CRM, Salesforce.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 email@example.com, We would like to hear from you.