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