{"id":30794,"date":"2025-03-31T12:37:43","date_gmt":"2025-03-31T12:37:43","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=30794"},"modified":"2025-03-31T12:40:22","modified_gmt":"2025-03-31T12:40:22","slug":"how-to-set-site-wise-grn-display-in-the-left-list-on-the-purchase-invoice-screen-during-creation","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2025\/03\/31\/how-to-set-site-wise-grn-display-in-the-left-list-on-the-purchase-invoice-screen-during-creation\/","title":{"rendered":"How to Set Site-Wise GRN Display in the Left List on the Purchase Invoice Screen During Creation"},"content":{"rendered":"\n<p>In <a href=\"https:\/\/www.greytrix.com\/sage-x3-erp\/development-services\/\" target=\"_blank\" data-type=\"link\" data-id=\"https:\/\/www.greytrix.com\/sage-x3-erp\/development-services\/\" rel=\"noreferrer noopener\">Sage X3<\/a>, the left-list is essential for navigating key functions like sales deliveries, sales invoices, purchase receipts, and purchase invoices. These screens allow users to select items from the left-list and proceed with transaction creation seamlessly.<\/p>\n\n\n\n<p>By default, in the purchase invoice screen, when creating a purchase invoice, the first step is to select the site and then click on the left-list GRN selection. This displays all GRNs from different sites as shown in the figure Fig 1. However, many clients have recently requested the ability to display GRNs in a such way that, left list should filter the GRN\u2019s site-wise in the left list.<\/p>\n\n\n\n<p>To achieve this, we have added some customized script on the invoice screen.<\/p>\n\n\n\n<p><strong>New Stuff:<\/strong> <a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2025\/03\/31\/lot-validation-of-closed-coasted-and-wip-posting\/\" target=\"_blank\" data-type=\"link\" data-id=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2025\/03\/31\/lot-validation-of-closed-coasted-and-wip-posting\/\" rel=\"noreferrer noopener\">Lot Validation of \u2018Closed + Coasted\u2019 and WIP posting<\/a><\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2025\/03\/By-default-all-site-wise-GRN-1024x476.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2025\/03\/By-default-all-site-wise-GRN-1024x476.png\" alt=\"By default all site wise GRN\"><\/a><\/center>\n<font size=\"2\"><center>By default all site wise GRN<\/center><\/font>\n\n\n\n<p><strong>Steps to follow :<\/strong><\/p>\n\n\n\n<p><strong>The first step is to add a single line of code in the standard SUBPIHA code. Refer to the snippet below.<\/strong><\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2025\/03\/Assign-the-site-for-the-screen-to-the-standard-table.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2025\/03\/Assign-the-site-for-the-screen-to-the-standard-table.png\" alt=\"Assign the site for the screen to the standard table\"><\/a><\/center>\n<font size=\"2\"><center>Assign the site for the screen to the standard table<\/center><\/font>\n\n\n\n<p>In the above snippet of code, we add one more condition for the standard <strong>$FILGAUCHE<\/strong> event: we assigned the purchase invoice screen site code to the standard table in order to filter the site-wise GRN.<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2025\/03\/Site-Wise-GRN-Display-1024x472.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2025\/03\/Site-Wise-GRN-Display-1024x472.png\" alt=\"Site Wise GRN Display\"><\/a><\/center>\n<font size=\"2\"><center>Site Wise GRN Display<\/center><\/font>\n\n\n\n<p>In conclusion, by following the steps provided, we have successfully implemented the filtering of site-wise GRN on the purchase invoice screen, improving data accuracy and display, as shown in Fig 3.<\/p>\n\n\n[about_us_blog_common]\n","protected":false},"excerpt":{"rendered":"<p>In Sage X3, the left-list is essential for navigating key functions like sales deliveries, sales invoices, purchase receipts, and purchase invoices. These screens allow users to select items from the left-list and proceed with transaction creation seamlessly. By default, in the purchase invoice screen, when creating a purchase invoice, the first step is to select\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2025\/03\/31\/how-to-set-site-wise-grn-display-in-the-left-list-on-the-purchase-invoice-screen-during-creation\/\">Read More &raquo;<\/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":[4353,1564,4354,1822,4355],"class_list":["post-30794","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-integration","tag-grn-selection-left-list","tag-purchase-invoice","tag-purchase-invoice-left-list","tag-sage-x3","tag-site-wise-grn-selection"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30794","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=30794"}],"version-history":[{"count":9,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30794\/revisions"}],"predecessor-version":[{"id":30803,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30794\/revisions\/30803"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=30794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=30794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=30794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}