I need to create a report regarding material consumption / production. I have material stock from one table, production orders from another and sales orders from another.
Now I need to put everything to one table and maintain time order and calculate predicted stock. For example:
Date
Element type
Qty
Stock
Today
Actual Stock
10
10
Next day
Production order
5
15
Next day
Sales order
-12
3
Next day
Production order
7
10
Another difficulty is that I need to have stock always in the first row.
Any hints on how to achieve this? Will be very grateful.
Hi Tomasz, your question is very broad, the short answer is to please post somo sample qvw with some data and we might be able to help you through the transformation process.
