Skip to Content

SQL query for Inventory valuation

Sep 07, 2017 at 01:19 PM


avatar image
Former Member

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


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers