How to add selection screen on field action

By | November 30, 2020
0 Comment

In Sage X3 , selection screen on a particular field helps users to search easily and select as per the requirement.

In Sage x3, If user want search selection should be there on any field, then it is easy if we are directly using custom data type for the same, but if we have used data type as “A(alphanumeric)”, and we are expecting that selection search screen should be there so that we can easily select the data for the field as per our need. In that case this blog is very helpful for you.

For example, On the screen , user wants search selection screen on “From Journal Number” field, and user is expecting journal no and description should be displayed on that screen to fulfil the requirement follow below steps to add selection search screen on field action:

Step 1:
Go to India pack module -> GL Voucher
As shown in the below screenshot, field “From Journal Number” is already added on screen and we need to add selection search screen on tab of “From Journal Number” field.

New Stuff: Division Wise Product Restriction on Sales Order

Print Screen
Print Screen

Step 2:
Go to Development -> 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 Development -> Script
add code into the “SPEZGL” script.

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

REQUEST(0) =”Select 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
Break
Endif
Next

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

Output
Output

In this way , we can add selection search screen on any custom field, when user tabs on “From Journal no” field the above selection screen gets open for searching as shown in the screenshot.

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.