I have to develop a report, which involves finished good stock as on date. the report format is as below:
| Date |
Item No |
Opening Balance TON |
Daily Production TON |
Net TON |
Sale TON |
Total TON |
| 10.1.2013 |
1012 |
1000 |
50 |
1050 |
100 |
950 |
| 11.1.2013 |
1012 |
950 |
70 |
1020 |
50 |
970 |
| 12.1.2013 |
1012 |
970 |
100 |
1070 |
70 |
100 |
|
|
|
|
|
|
|
any sql view/query from which I can get opening balance at any specified date of any item. I have query to get daily production, and sale of any specified date. I'll be very very thankfull if somebody guide me to build this type of query.
*This post is locked for comments
I have the same question (0)
