|
caulson
Starting Member
Malaysia
1 Posts |
 Posted - 06/13/2012 : 01:25:04
|
HI,May i know how to create and caculate Forecast Report in SQL.
As below is my example report layout in SQL
Table 1
Date Item On hand balance Usage
10/6 book 10 3
11/6 book 7 3
12/6 book 4 3
13/6 book 1 3
Table 2
Date Item Receive On hand balance Usage
14/6 book 10 11 3
How to use SQL function to calculate a date ,on hand balance and usage ? if i receive new item how to add in On hand balance ?
thank you |
Edited by - caulson on 06/13/2012 01:45:53
|
|
How to Create and caculate Forecast Report in SQL
