SQL query for Inventory valuation

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

Ash