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

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.