How to use Choose Function in Sage X3V12?

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-


  Choose class

  •    [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-

Screenshot 1


After entering the purchase order number, it will open a selection box as shown in below Screenshot 2

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.

About Us-

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. 


Cloud ERP Consultation In India


Leave a Reply

Your email address will not be published. Required fields are marked *