{"id":26614,"date":"2023-05-30T09:18:21","date_gmt":"2023-05-30T09:18:21","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=26614"},"modified":"2024-11-26T10:35:16","modified_gmt":"2024-11-26T10:35:16","slug":"how-to-increase-or-decrease-the-number-of-lines-in-grid-of-any-inquiry-screen","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2023\/05\/30\/how-to-increase-or-decrease-the-number-of-lines-in-grid-of-any-inquiry-screen\/","title":{"rendered":"How to increase or decrease the number of lines in grid of any Inquiry screen"},"content":{"rendered":"\n

In each module of Sage X3<\/a>, it has its own set of inquiries that allows to search and filter predefined data collections using a variety of prebuilt parameters.<\/p>\n\n\n\n

For example, in the sales module we have created a number of Orders, so to check Order data we can use the list of orders inquiry screens of the sales module like List of Orders, Order lines, Orders by period etc.<\/p>\n\n\n\n

There was a requirement from one of our client to display 200 lines at a time in List of Orders inquiry screen in Sales module as it was displaying only 50 records on grid as per standard screen<\/p>\n\n\n\n

New Stuff:<\/strong> Tracking Restriction and Creation on the basis of Stock Availability<\/a><\/p>\n\n\n\n

\"Order<\/a><\/center>\n
Order Lines Inquiry screen<\/center><\/font>\n\n\n\n

As you can see in the above screenshot, only 50 lines are visible in the grid and user wants to display 200 lines at a time in this screen. To achieve this task follow the below steps :<\/p>\n\n\n\n

Step 1 :
\u2013Find the Inquiry screen code for Order Line Inquiry screen
\u2013All -> Development -> Script dictionary -> Window -> FCNSCSP<\/p>\n\n\n\n

\"\nOrder<\/a><\/center>\n
\nOrder lines Inquiry window<\/center><\/font>\n\n\n\n

Step 2 :
\u2013All -> Setup -> General parameters -> Inquiry Screens
\u2013Find the CSP inquiry code
\u2013Enter 200 in Number of Lines field (in all the transaction types : All, Std etc)<\/p>\n\n\n\n

\"Number<\/a><\/center>\n
Number of lines in Inquiry screen<\/center><\/font>\n\n\n\n

\u2013Save and validate the Inquiry screen.<\/p>\n\n\n\n

\"Output\"<\/a><\/center>\n
Output<\/center><\/font>\n\n\n\n

After completing all the mentioned steps properly, you can see 200 lines are getting displayed in the Grid.<\/p>\n\n\n\n

Similarly we can decrease the number of lines in Inquiry screen. In this way, by just following 2 simple steps we can increase or decrease the number of lines to be displayed in the grid of Inquiry screens.<\/p>\n","protected":false},"excerpt":{"rendered":"

In each module of Sage X3, it has its own set of inquiries that allows to search and filter predefined data collections using a variety of prebuilt parameters. For example, in the sales module we have created a number of Orders, so to check Order data we can use the list of orders inquiry screens\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":[1073,3011,3744,3018,1822],"class_list":["post-26614","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-integration","tag-inquiry","tag-inquiry-screen","tag-list-of-orders","tag-order-lines","tag-sage-x3"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/26614","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=26614"}],"version-history":[{"count":8,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/26614\/revisions"}],"predecessor-version":[{"id":30262,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/26614\/revisions\/30262"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=26614"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=26614"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=26614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}