In the previous chapter, you learned about Query Manager and the most commonly-used statements and functions. That gave you a necessary tool to create any SQL queries within SAP Business One system freely. However, it may not be that easy to create a query to meet your specific needs.
This chapter will show you the following:
- The most widely used query examples to give you more powers to build your own queries. These include:
- Query variables
- Date selection
- Drill-down arrows
- Subtotals
- Detailed solution examples give all readers an idea about how business intelligence works within SAP Business One and breaks it down into three primary categories:
- Marketing documents
- Inventory transactions
- Financial transactions
- Alert query examples and miscellaneous query examples for better use of on demand information.
You will find the questions or some queries that do not fully satisfy what is required first. Then, the right queries to solve these problems. Finally, there will...