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