Create Validation using Transaction Notification

In SAP Business One (SAP B1) either you are using SAP Hana or Microsoft SQL Database, we can add simple validation using store procedure in the database. For example, when users create a new Business Partner Master Data (vendor or customer), we want to have validation in the Business Partner Master Data screen that users have to fill in the Foreign Name field. please open SQL Server Management Studio and then log in using your database username and password. After login, at the left panel find your database name > click the drop-down menu on Programmability > click the drop-down menu on Stored