{"id":30173,"date":"2024-10-29T12:26:41","date_gmt":"2024-10-29T12:26:41","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=30173"},"modified":"2024-12-03T05:26:03","modified_gmt":"2024-12-03T05:26:03","slug":"how-to-view-multiple-lines-when-running-an-inquiry-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/10\/29\/how-to-view-multiple-lines-when-running-an-inquiry-in-sage-x3\/","title":{"rendered":"How to View Multiple Lines When Running an Inquiry in Sage X3"},"content":{"rendered":"\n

Sage X3<\/a> is enterprise resource planning (ERP) product which help organization to manage all the operation of organization and database into a single software solution. Sage X3 contains list of modules like sales, purchase, inventory, project, financial and many more.<\/p>\n\n\n\n

New Stuff: <\/a>Miscellaneous Data Searches in Sage X3<\/a><\/p>\n\n\n\n

In this example, we are using the Account Balances Inquiry function with the ID ‘CONSBAL.’<\/p>\n\n\n\n

\"Fig<\/a><\/center>\n
Fig 1 -Path<\/center><\/font>\n\n\n\n

<\/p>\n\n\n\n

You can View Multiple Lines When Running an Inquiry in Sage X3 by following the steps below :<\/p>\n\n\n\n

Step 1: Navigate to Setup > General Parameters > Inquiry Screens<\/p>\n\n\n\n

In this example, we are using the Account Balances Inquiry function, where the last three characters of the function ID ‘CONSBAL’ represent the Inquiry Code ‘BAL,’ as shown in the image below.<\/p>\n\n\n\n

\"Fig<\/a><\/center>\n
Fig 2 – Inquiry screen<\/center><\/font>\n\n\n\n

Expand the Inquiry from the left-hand list. You may have different screens set up for the specific inquiry. In this example, I will use the STD screen<\/p>\n\n\n\n

Step 2: Increase the ‘Number of Lines’ value. We recommend a maximum of 5,000 lines, as exceeding this limit may lead to performance issues, as shown in the image below<\/p>\n\n\n\n

\"Fig<\/a><\/center>\n
Fig 3 – Inquiry screen 1<\/center><\/font>\n\n\n\n

Save the modifications and validate the transaction inquiry screen.<\/p>\n\n\n\n

Step 3: Go to the Account Balance Inquiry screen. Click on the ‘Criteria’ button in the upper-right corner of the screen, and enter ‘STD’ in the screen code field, as shown in the picture below<\/p>\n\n\n\n

\"Fig<\/a><\/center>\n
Fig 4 – Account balance inquiry<\/center><\/font>\n\n\n\n

By following the above steps, you can View Multiple Lines When Running an Inquiry in Sage X3<\/p>\n\n\n[about_us_blog_common]\n","protected":false},"excerpt":{"rendered":"

Sage X3 is enterprise resource planning (ERP) product which help organization to manage all the operation of organization and database into a single software solution. Sage X3 contains list of modules like sales, purchase, inventory, project, financial and many more. New Stuff: Miscellaneous Data Searches in Sage X3 In this example, we are using the\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,13],"tags":[2879,4316,3265,3649],"class_list":["post-30173","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-integration","tag-account-balance","tag-number-of-lines","tag-sagex3","tag-screen-code"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30173","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=30173"}],"version-history":[{"count":4,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30173\/revisions"}],"predecessor-version":[{"id":30187,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30173\/revisions\/30187"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=30173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=30173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=30173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}