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 inventory transactions

Inventory transactions and inventory status are the second hot topics for SAP Business One users. Here within the book, inventory will cover production too because they are closely related.

Case 4-I1: Adding stock total to the query

The first example is a simple one: to have an overview of total stock in all warehouses sorted on items group with the total amount per item group and total amount of units.

The user tried a report by XL Reporter for the goal. However, the result from that report is different from the standard stock report in SAP Business One. So it is not useful.

System report, however, is not sorted on item group; that could not meet their needs either. The user only needs the total on hand for item ...

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