Hi
I had two views one is instinward view 2 nd instoutward view in that multiple drugs multiple institutes r entry stock sum(bqty) ,recptdate group by drugcode,rcptdate this and outward view sales sum(oqty),odate group by odate,drugcode what i want in grid view one column first entry date drugcode ,sum(qty) second column outward for that stock is cooming ti same date column sum(oqty) third columns batchqty-oqty sales time different dates they are entered in this total qty 100 after that date sales 20 100-20 =80
next sales date oqty 20 80-20=60 like that values need to come next row bqty need comes ones only
not understand see this bellow type of report i want
| Sl |
Drugname |
Date |
Received Qty |
Issued Qty |
Balance Qty |
| 1 |
Dextrose|Injection|5%|1x500ml- 26.2.1 |
01/11/2020 |
100 |
|
100 |
| |
|
05/11/2020 |
|
20 |
80 |
| |
|
06/11/2020 |
|
10 |
70 |
| 2 |
Albendazole|Tablet|400mg|1x10x10- 6.3.2 |
03/11/2020 |
|
6 |
15 |
| |
|
05/11/2020 |
|
1 |
14 |
| |
|
08/11/2020 |
20 |
|
34 |