Before :-
<tbody>
</tbody>
After :-
<tbody>
</tbody>
If remaining quantity > 0, new line has to be created in the Excel along with Remaining Quantity.
How to achieve to my desired outcome ? Please do the needful.
Regards,
RAM
Item Number | Qty to Produce | Quanity Produced | Remainng Quantity | Date | |
A | 1000 | 400 | 600 | 28/09/2014 | |
B | 5200 | 3400 | 1800 | 28/09/2014 | |
C | 12000 | 7500 | 4500 | 28/09/2014 | |
D | 500 | 275 | 225 | 28/09/2014 | |
E | 8000 | 8000 | 0 | 28/09/2014 | |
F | 12000 | 9000 | 3000 | 28/09/2014 |
<tbody>
</tbody>
After :-
Item Number | Qty to Produce | Quanity Produced | Remainng Quantity | Date | |
A | 1000 | 400 | 600 | 28/09/2014 | |
A | 600 | 29/09/2014 | |||
B | 5200 | 3400 | 1800 | 28/09/2014 | |
B | 1800 | 29/09/2014 | |||
C | 12000 | 7500 | 4500 | 28/09/2014 | |
C | 4500 | 29/08/2014 | |||
D | 500 | 275 | 225 | 28/09/2014 | |
D | 225 | 29/08/2014 | |||
E | 8000 | 8000 | 0 | 28/09/2014 | |
F | 12000 | 9000 | 3000 | 28/09/2014 | |
F | 3000 | 29/08/2014 |
<tbody>
</tbody>
If remaining quantity > 0, new line has to be created in the Excel along with Remaining Quantity.
How to achieve to my desired outcome ? Please do the needful.
Regards,
RAM
Last edited: