{"id":29411,"date":"2024-06-28T07:16:34","date_gmt":"2024-06-28T07:16:34","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=29411"},"modified":"2024-06-28T07:16:34","modified_gmt":"2024-06-28T07:16:34","slug":"how-can-we-add-new-fields-to-the-inquiries-screen-without-using-standard-lecture-code","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/06\/28\/how-can-we-add-new-fields-to-the-inquiries-screen-without-using-standard-lecture-code\/","title":{"rendered":"How can we add new fields to the Inquiries screen without using standard lecture code"},"content":{"rendered":"\n

In Sage X3, the inquiries screen refers to a user interface where users can view and analyze data stored in the system. This screen typically provides a way for users to query and retrieve information about various aspects of the business, such as sales orders, purchase orders, inventory levels, customer information, supplier information, and financial data. The inquiries screen often includes search filters, customizable columns, and options to drill down into details for deeper analysis. It serves as a central hub for accessing critical business data and gaining insights into different operations within the organization.<\/p>\n\n\n\n

Here’s a step-by-step description of how we can add new fields to the Inquiries screens, such as Stock by site, Stock by product, Stock by lot, Detailed stock, Obsolete stock, Available stock, Dedicated location, Stock to count, etc., without using standard lecture code in Sage X3 :<\/p>\n\n\n\n

STEP-1<\/strong><\/p>\n\n\n\n

As shown in the screenshot below, we have added the field ‘Description 4’ on the stock to count inquiry screen. First, we need to add the field on the stock to count screen. Go to Development >> Screen >> Enter new field >> Save >> Validate the screen. Refer to the screenshot below as Fig. 1.<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Fig1. Screen dictionary<\/strong><\/p>\n\n\n\n

STEP-2<\/strong><\/p>\n\n\n\n

As shown in the screenshot below, open the window management screen of stock to count and jump to the Inquiry screen. Go to Development —>> Window —>> Jump to the Inquiry. Refer to the screenshot below as Fig. 2. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u00a0 Fig2. Window management<\/strong><\/p>\n\n\n\n

STEP-3<\/strong><\/p>\n\n\n\n

As shown in the screenshot below, The inquiries screen is open . We need to jum to the defauly screen code, its a standard screen . Refer to the screenshot below as Fig. 3.
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u00a0 Fig3. Inquiries screen<\/strong><\/p>\n\n\n\n

STEP-4<\/strong><\/p>\n\n\n\n

As shown in the screenshot below, we need to set the sequence number of description 4 filed. We set the order number where we want to be set on the stock to count screen. Here we set the order number of description 4 field . Refer to the screenshot below as Fig. 4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Fig4. Default STD Screen<\/strong><\/p>\n\n\n\n

When all the process is completed. Validate the inquiries screen, Defualt screen, and stock to count window.<\/p>\n\n\n\n

STEP-5<\/strong><\/p>\n\n\n\n

As shown in the screenshot below. After that we follow the all the steps are step by step , the successfully added the new fields Description 4 on the stock to count inquiry screen .<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

Fig5.Field added<\/strong><\/p>\n\n\n\n

STEP-6<\/strong><\/p>\n\n\n\n

As shown in the screenshot below, open the stock to count inquiries script file, such as ‘CNSSIISPE’, which is a standard script file. We need to write the code to display the product description 4 on the screen when the user selects the product site, from product, to product, and clicks on the search button. All the data regarding the product with the newly added Description 4 field will be displayed. We need to use the AV_AFFICHE action to display the data on the newly added field. Refer to the screenshots below as Fig. 6. The AV_AFFICHE action is used to display the data on the newly added field.<\/p>\n\n\n\n

The data display code is written in the inquiry script file such as ‘CNSSIISPE’, which is the stock to count inquiry script file name.<\/p>\n\n\n\n

<<——————————————————————————->><\/p>\n\n\n\n

$ACTION<\/p>\n\n\n\n

 Case ACTION<\/p>\n\n\n\n

  When “AV_AFFICHE” :Gosub AV_AFFICHE<\/p>\n\n\n\n

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

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

$AV_AFFICHE<\/p>\n\n\n\n

##Here  we can write the code to display Product Description 4 on the grid.<\/p>\n\n\n\n

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

<<——————————————————————————->><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u00a0Fig6. Stock to count<\/strong><\/p>\n\n\n\n

This blog helps us understand how to add the new fileds on the all the inquiries screen such as a Stock by site,stock by product,stock by lot , detailed stock,obsolete stock, available stock.dedicated location , stock to count etc. Sage X3.<\/p>\n\n\n\n

.<\/p>\n","protected":false},"excerpt":{"rendered":"

In Sage X3, the inquiries screen refers to a user interface where users can view and analyze data stored in the system. This screen typically provides a way for users to query and retrieve information about various aspects of the business, such as sales orders, purchase orders, inventory levels, customer information, supplier information, and financial\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":[2,4,5,3162,13,7,8,3642,9,10,2796,11],"tags":[48,4237,4235,1073,1780,1822,1839,2871,1942,1945,2020,4236,2413],"class_list":["post-29411","post","type-post","status-publish","format-standard","hentry","category-configuration","category-faq","category-features","category-greytrix","category-integration","category-miscellaneous-tables","category-sage-erp-x3","category-sage-x3","category-sage-x3-consulting","category-standard","category-technical","category-tips","tag-action","tag-av_affiche","tag-inquiries","tag-inquiry","tag-sage-erp-x3","tag-sage-x3","tag-sage-x3-blogs","tag-sage-x3-functional-blogs","tag-sage-x3-technical-assistance","tag-sage-x3-technical-blogs","tag-screen","tag-stcok-to-count","tag-window"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29411","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=29411"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29411\/revisions"}],"predecessor-version":[{"id":29419,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29411\/revisions\/29419"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=29411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=29411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=29411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}