RKL eSolutions Blog Trends and Insights

How to View Multiple Lines When Running an Inquiry in Sage X3

When running inquiries in Sage X3, they are generally defaulted to load 10 to 50 lines. Using the steps below, you can modify the screen to increase the amount of lines displayed for each inquiry you run.


Setting Up the Line Inquiry

    1. Hover your mouse over the function to obtain the function ID
      • In this example the Account Balances Inquiry function ID is “CONSBAL”
        Hover over function ID -1
    2. Go to Setup > General Parameters > Inquiry Screens
      • The last 3 characters of the function ID should be the Inquiry Code
      • Example: CONSBAL = BAL
    3. Expand the Inquiry in the left list
      • You may have different screens setup for the specific inquiry. In this example, I'll use the STD screen.
        Inquiry List -2
    4. Increase the 'Number of Lines' value. (We recommend a maximum amount of 5,000 lines. You may notice some performance issues if you chose to have your line inquiry any larger.)
      Inquiry screens number of lines -3
    5. Click on 'Validation'
    6. Click on the 'Criteria' button in the upper right hand corner of the screen
    7. Enter "STD" in the screen code field
Account Balance Inquiry screen code -4


Have any questions? Don't hesitate to reach out, it's what we're here for!

Tags: Sage X3, How-To
LeeAnn Segan

Written by LeeAnn Segan

LeeAnn Segan is an ERP Support Specialist with RKL eSolutions LLP. She supports Sage 500 ERP and Sage X3. LeeAnn specializes in the financial and distribution modules. Her background includes managing distribution and warehousing for ecommerce based companies. When not working, LeeAnn enjoys working out, volunteering with groups that support special needs, and spending time at the beach with family and friends.