User Restrictions on Purchase Inquiry Screen

In Sage X3, Users can check all the purchase related data using inquiry screens. But there is one drawback of this functionality that any user can check the data of all the other users also using inquiry screens. To overcome from this drawback, we did customization on Purchase Inquiry screens. By doing which users can check only those POs and GRNs in Inquiry screen which have been created by them. Users will be restricted to fetch other user’s data.

But there can be some users in the system who needs to see all the user’s data.

For this purpose, we have added “Full User” checkbox in the user master screen as shown in the below screenshot:

New Stuff: How to create and add formula on inquiry screen

[User Master]

If the Full User checkbox is ticked, then that particular user will have full rights to check the all user’s purchase related data and if it is not ticked then user can check only those entries which are created by him. As you can see in the above screenshot, full user checkbox is ticked for “ADMIN” user and not ticked for “ABHI” user in the user setup. So there can be two scenarios that either the user is a FULL USER who will have access to check other user’s Purchase entries or he is not a FULL USER who will be restricted and can check only Purchase entries which are created by him.

After that, we have added “My PO” and “None” radio buttons on Order Lines Inquiry Screen and “MY GRN” and “None” radio buttons on Receipt Lines Inquiry screen. Now, we will check how the functionality will work for both the Scenarios.

First scenario: Admin user is logged in. (FULL USER)

[Order Lines Inquiry screen – ADMIN User (My PO Option)]

As you can see, when admin user has selected “My PO” option in inquiry screen, only POs created by him are getting displayed but when he has selected “None” option in the below screenshot, he is able to see all the POs which are created by other users also.

[Order Lines Inquiry screen – ADMIN User (None option)]

Second scenario: ABHI user is logged in. (not a FULL USER)

[Order Lines Inquiry screen – ABHI User (My PO option)]

In the above screenshot, when ABHI user has selected “My PO” option in inquiry screen, only POs created by him are getting displayed and even when he has selected “None” option as shown in the below screenshot, same data is getting displayed i.e. POs which are created by him. He doesn’t have rights to check other user’s POs because he is not a FULL User as per the user master settings saved in the User setup.

[Order Lines Inquiry screen – ABHI User (None option)]

Also we have added “My Department” and My Sub-Department” radio buttons on both the screens. If department of the users is same and he has selected my department option then he can see POs created by him and other users as well who are having same department saved in user master. Same functionality will work for Sub-Department option.

Hence with the help of this customization, User will get restricted as per the given rights. And he will not get access to check other user’s Purchase related data.

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 X3, Sage Intacct, Sage 100, Sage 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 Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage 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.