Hi Everyone,
I want to present the level of stock and order of product units in point of time by day for past and future .
I have the data which has the Order date, receive date and sold date. Attached below and the output desired is as below, the unit is considered on order if the it has been received by the date and not yet been sold, order unit is not yet received.
Thanks in advance.
| Stock No |
Product Code |
Order Date |
Receive Date |
Sale Date |
| 114743 |
A |
01/06/2021 |
10/06/2021 |
14/06/2021 |
| 114748 |
B |
02/06/2021 |
13/06/2021 |
30/06/2021 |
| 114722 |
A |
03/06/2021 |
30/06/2021 |
15/07/2021 |
| 114332 |
B |
04/06/2021 |
10/07/2021 |
30/07/2021 |
| 114728 |
A |
06/06/2021 |
30/07/2021 |
29/08/2021 |
| 114774 |
B |
07/06/2021 |
09/08/2021 |
13/09/2021 |
Output Desired:
| |
|
01/06/2021 |
02/06/2021 |
03/06/2021 |
04/06/2021 |
05/06/2021 |
06/06/2021 |
07/06/2021 |
08/06/2021 |
09/06/2021 |
10/06/2021 |
11/06/2021 |
12/06/2021 |
13/06/2021 |
14/06/2021 |
15/06/2021 |
till to date |
| A |
Stock |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
1 |
1 |
1 |
0 |
|
| Order |
1 |
1 |
2 |
2 |
2 |
3 |
3 |
3 |
3 |
2 |
2 |
2 |
2 |
2 |
2 |
|
| B |
Stock |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
1 |
|
| Order |
0 |
1 |
1 |
2 |
2 |
2 |
3 |
3 |
3 |
3 |
3 |
3 |
2 |
2 |
2 |
|
