PT Sterling Tulus Cemerlang
www.sterling-team.com

Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

400+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

Create Validation using Transaction Notification

SAP Business One Tips Create Validation Using Transaction Notification
SHARE ON


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.

  1. please open SQL Server Management Studio and then log in using your database username and password.
  2. After login, at the left panel find your database name > click the drop-down menu on Programmability > click the drop-down menu on Stored Procedures.

    SAP Business One Tips - Create Validation using Transaction Notification

    SAP Business One Tips – Create Validation using Transaction Notification

  3. Then please find SBO_SP_PostTransactionNotice > right-click on it then choose Modify.

    SAP Business One Tips - Create Validation using Transaction Notification

    SAP Business One Tips – Create Validation using Transaction Notification

  4. Now we can write the query to check if the foreign name field has been filled. We also can set the error message that appears in sap business one.

    SAP Business One Tips - Create Validation using Transaction Notification

    SAP Business One Tips – Create Validation using Transaction Notification

  5. Now we have the validation in screen Business Partner Master Data when create or update the data.

    SAP Business One Tips - Create Validation using Transaction Notification

    SAP Business One Tips – Create Validation using Transaction Notification

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , , , , , ,