SageX3 V12 lets X3 developers encounter situations where they need a popup window to let them select a particular data from a list. In Sage Enterprise Management we have a function called CHOOSE. This function allows the SageX3 users to open a window that contains a list of records of predefined data or fields from a particular table. It is basically used for a selection of records that are in grid view.
Refer to the Syntax below for a better understanding-
- [Where Where_exp] [Order by Order_by_exp]
Where_exp:– selection expression of where condition.
Order_by_exp:– Key expression.
Using field list
- [Sized dimension] – Size of the selection box on the screen.
- [Titled box title] – Title of the selection box on the screen.
- [Starting At Start_exp] – Logical expression specifying the record on which the cursor must be positioned.
Let us consider an example of a selection window when we enter the Purchase order number in the purchase order function like shown in Screenshot 1 below-
After entering the purchase order number, it will open a selection box as shown in below Screenshot 2
This blog lets us how to use the Choose function in Sage X3V12. Stay tuned for more informative blogs and quick tips on Sage X3 V12.
GerminIT – Recognized for its X3 implementation and customization the world over, GerminIT is one of the oldest Sage X3 (a Sage Business Cloud Solution) development and implementation enablers and a one-stop solution provider for Sage X3 organizational needs. With a proven track record of X3 development and implementation solutions for clients across the US, UK, Middle East, Australia, Asia, and Africa, we bring complete end-to-end assistance for data migration, system integrations, technical consultations, implementation competence, third-party add-on development, and product customizations.
With GerminIT your business will be supported with the best-in-class Sage X3 customization and development services, integrated applications such as Shipping System | eCommerce | Business Intelligence | POS | WMS | Payment Gateway, and mobile add-ons solutions. GerminIT caters to a wide range of Sage X3 offerings. Currently, we provide end-to-end support with Sage X3 implementation and customization solutions for Sage business partners, Sage PSG, and end-users worldwide.