O'Reilly logo

Mastering SQL Queries for SAP Business One by Gordon Du

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

User query for alert

One of the important usages of SQL query in SAP Business One is for alert. SAP Business One provides a few standard alert messages after you first install. However, the numbers of built-in alerts are far from enough.

The good news is, the system provides you with the power to have your own alert by SQL query. You will find some examples here first. With the following queries, and with the ones you can create yourself, you will be able to have the right alert messages to meet your business needs at the right time with the right person. That is a great help to increase your system efficiency.

Case 4-A1: Creating a right alert without duplicated lines

Here is a rather interesting and complex scenario: a company has two physical ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required