How to Set Site-Wise GRN Display in the Left List on the Purchase Invoice Screen During Creation

By | March 31, 2025

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 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’s site-wise in the left list.

To achieve this, we have added some customized script on the invoice screen.

New Stuff: Lot Validation of ‘Closed + Coasted’ and WIP posting

By default all site wise GRN
By default all site wise GRN

Steps to follow :

The first step is to add a single line of code in the standard SUBPIHA code. Refer to the snippet below.

Assign the site for the screen to the standard table
Assign the site for the screen to the standard table

In the above snippet of code, we add one more condition for the standard $FILGAUCHE event: we assigned the purchase invoice screen site code to the standard table in order to filter the site-wise GRN.

Site Wise GRN Display
Site Wise GRN Display

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.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.

Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3Sage IntacctSage 100Sage 500, and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business ManagerSage CRM Project ManagerSage CRM Resource PlannerSage CRM Contract ManagerSage CRM Event ManagerSage CRM Budget PlannerGmail IntegrationSage CRM Mobile Service SignatureSage CRM CTI Framework.

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.