Skip to Content
avatar image
Former Member

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


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers