Actually i need to make a Re Distribution tool which should tell that Product which is having excess stock in one location can be distributed to other location.
My basic data is like this below.
BRANCH
PRODUCT
REQUIRED_QTY
AVAILABLE_QTY
EXCESS_QTY
SHORT_QTY
BR1
PRD1
100
180
80
0
BR2
PRD1
150
110
0
40
BR3
PRD1
150
130
0
20
BR4
PRD1
80
70
0
10
From this data i need to make a report like this below.
