Skip to Content
Former Member
Mar 10, 2013 at 05:41 PM

Daily Stock and Sales Report


Hello.I need to develop a stock and sales report in R/3. The columns in the output are:

SKU Code, Opening stock qty (as on 1st day of the month), Closing stock qty (as of end of transaction date), Sales Qty, Sales Qty value, Unit of Measure, Date.

While I have an idea how to go about the opening stock and sales details, I need help with the closing stock quantity calculation. Which tables do I access, fields, etc. .. any suggestions?

Thanks in advance.