O'Reilly logo

Mastering SQL Queries for SAP Business One by Gordon Du

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required