Query for financial transactions
Under this category, all banking related issues are included. There are fewer financial transactions related query requests than other queries. This is probably because:
- System provides more financial reports than other reports
- The need for such reports is less
- It is too difficult to produce a proper report
No matter how many queries can be built, we should still go through some of the queries so that we can find more information related to business operations.
Case 4-F1: Top five customers
Sales ranking is discussed in the previous section. However, there are many questions with some different requests. One example is top N customers during any period.
Since this query only deals with the Journal Entry table, I have ...
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.