Summary
In this chapter, you learned two important topics for SQL query usage in SAP Business One. First, how the security can be set to query users. The other is query used for approval procedures. All these topics are discussed in detail with many examples and multiple screenshots.
When you follow the suggestion from this book for user query security, you will be able to reduce potential problems in query usage. This will enable the users to get just the query they need without any additional risk to the system.
For the approval procedure, you can follow the examples to build your own. Because user query for approval is so flexible, you will be able to build more approval procedures to meet your specific business needs.
In the next chapter, we ...
Get Mastering SQL Queries for SAP Business One now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
