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.