How to add selection screen on field action

In Sage X3 , selection screen on a selected field helps customers to search simply and choose as per the requirement.

In Sage x3, If consumer need search selection must be there on any field, then it’s simple if we’re straight utilizing customized information sort for a similar, but when we have now used information sort as “A(alphanumeric)”, and we expect that selection search screen must be there in order that we are able to simply choose the information for the field as per our want. In that case this weblog may be very useful for you.

For instance, On the screen , consumer needs search selection screen on “From Journal Quantity” field, and consumer is anticipating journal no and outline must be displayed on that screen to fulfil the requirement observe beneath steps to add selection search screen on field action:

Step 1:
Go to India pack module -> GL Voucher
As proven within the beneath screenshot, field “From Journal Quantity” is already added on screen and we’d like to add selection search screen on tab of “From Journal Quantity” field.

New Stuff: Division Wise Product Restriction on Sales Order

Print Screen

Print Screen

Step 2:
Go to Improvement -> Script Dictionary -> Action
create action “ZGL”.

Action Dictionary

GUMU Integration App

Add this action on field action as “ZGL”.

Screen Dictionary

Screen Dictionary

Step 3:
Go to Improvement -> Script
add code into the “SPEZGL” script.

TIT(1) = ‘Journal Entry No.’ : #N
TIT(2) = ‘Description’ : #N

REQUEST(0) =”Choose DISTINCT NUM_0,DESVCR_0 from “+nomap+”.GACCENTRY “
FOR (CHAR NUM_0 (250), CHAR DESVCR_0 (250)) FROM “5” Sql REQUEST As [YCHD]

I += 1
TEX(I) = num$([YCHD]NUM_0 )
TEXTE(I,1) = num$([YCHD]NUM_0 )
TEXTE(I,2) = num$([YCHD]DESVCR_0 )
If I = 10000

Step 4:
Go to India pack Module -> GL Voucher
Now we are able to see on the tab of field, one selection screen shows.



On this approach , we are able to add selection search screen on any customized field, when consumer tabs on “From Journal no” field the above selection screen will get open for looking as proven within the screenshot.

About Us

Greytrix – a globally acknowledged and one of many oldest Sage Improvement Associate is a one-stop answer supplier for Sage ERP and Sage CRM organizational wants. Being acknowledged and rewarded for multi-man years of expertise, we deliver full end-to-end help on your technical consultations, product customizations, information migration, system integrations, third-party add-on improvement and implementation competence.

Greytrix caters to a variety of Sage X3, a Sage Enterprise Cloud Answer, choices. Our distinctive GUMU™ integrations embody Sage X3 for Sage, Dynamics 365 CRM and Magento eCommerce together with Implementation and Technical Assist worldwide for Sage X3. At the moment we’re Sage X3 Implementation Associate in East Africa, Center East, Australia, Asia, US, UK. We additionally provide best-in-class Sage X3 customization and development services, built-in purposes comparable to POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons comparable to Catch – Weight  and Letter of Credit and India Laws for Sage X3 to Sage enterprise companions, finish customers and Sage PSG worldwide.

Greytrix is a acknowledged Sage champion ISV Associate for GUMU™ Sage X3 – Sage CRM integration additionally 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 extra info on Sage X3 Integration and Providers, please contact us at, We are going to like to hear from you.

Related posts

Leave a Comment