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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.