Hi,
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.
| | | DISTRIBUTE TO |
BRANCH | PRODUCT | EXCESS_QTY | BR2 | BR3 | BR4 |
BR1 | PRD1 | 80 | 40 | 20 | 10 |
Can anybody help please.
Regards,
Ajith