Skip to Content
Sep 07, 2017 at 01:19 PM

SQL query for Inventory valuation

223 Views Last edit Sep 12, 2017 at 07:12 PM 2 rev

Hello SAP community,

Please can someone help, I’m trying to script a query using the query generator in SAP B1 v9.1, the result being a stock valuation which matches back to the trial balance.

The values should be summed across all warehouses

This is what I would like to see:

Item code, description, inventory qty, qty on sales order, free stock, inventory valuation (GBP)

Thanks in advance