I have a database with lot No and quantity as below. I have to use first in first out concept (FIFO) to issue these materials
If requested quantity is 1 the i have to decrease quantity of lotNo 1 by 1 if the requested quantity is more than the quantity available in that lot i have to remove from lotNo 1 then 2 till i get the required quanty.
eg if requested quantity is 8, i have to remove 2 from lot 1 4 from lot 2 and remining 4 from lot 3.
I'm using classic asp as programming language
I dont have any Idea on how to do this
LOTNO | Quantity |
---|---|
1 | 2 |
2 | 4 |
3 | 13 |
eg if requested quantity is 8, i have to remove 2 from lot 1 4 from lot 2 and remining 4 from lot 3.
I'm using classic asp as programming language
I dont have any Idea on how to do this