Duplicate PAN Number Validation on Customer Master in Sage X3

By | October 29, 2021

Sage X3 has master screens like Product master, Supplier master, Customer master etc.. where we can save information about object, means in product master we can save data about product, in supplier master we can save information about supplier like wise.

So as per the client’s requirement, we have added PAN No field at customer master where user can enter Customer PAN no and same has to be shown at the report level. Along with this, client also wanted to add validation in such a way that there should be Unique PAN number for each customer. So even if user tried to enter PAN number which is already been used for other customer then system should give error or pop up saying PAN number is already used, please enter correct PAN number. This will also help users to avoid mistake by entering duplicate PAN number.

So for this requirement we have added “After Change(AM_XXX)” action on PAN number field on Customer master screen and written a script for duplicate PAN no validation. Programmatically we have checked the BPCUSTOMER table and searched whether the same PAN number is already been used or not. You need to make sure, the validation should work while adding new customer as well as modifying the existing customer.

New stuff: How to solve “404-cannot find module” error on Node.js V12

PAN No Field with duplicate value
PAN No Field with duplicate value

As you can see we have entered Duplicate PAN No in the customer master. So as per functionality error message will be generated as shown in the below screenshot:

ERROR generated for duplicate PAN No
ERROR generated for duplicate PAN No

In this way, we can add validation on any field to check duplication for the entered value in Sage X3.

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 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.