TAB1

ITEMDESC	TYPE		QTY	VALUE
ITEM1		RECEIPT		100	1000
ITEM1		RECEIPT		100	1100	
ITEM1		ISSUE		 50		
ITEM1		RECEIPT		100	1200	
ITEM1		ISSUE		 50	
ITEM1		ISSUE		 50		

	

HERE WHEN I RECEIVE THE ITEM I CAN RECEIVE WITH VALUE.
WHEN IT HAS TO BE ISSUED IT SHOULD BE CALCULATED BASED ON THE PREVIOUS CLOSING BALANCE.
WHENEVER WE MAKE AN ISSUE QTY AND VALUE SHOULD GET REDUCED AND WHENEVER WE MAKE AN RECEIPT QTY AND VALUE SHOULD GET ADDED

i.e.,
my result table should be as follows

ITEMDESC	TYPE		QTY	VALUE	 RATE 	CLQTY  	CLBAL
ITEM1		RECEIPT		100	1000     10.0	100	1000
ITEM1		RECEIPT		100	1100	 11.0	200	2100 		
ITEM1		ISSUE		 50	 275 	  5.5	150	1825
ITEM1		RECEIPT		100	1200	 12.0 	250	3025
ITEM1		ISSUE		 50	 605	 12.1	200 	2420
ITEM1		ISSUE		 50	 605	 12.1   150	1851


RATE IS CALCULATED BASED ON THE PREVIOUS CLBAL AND CLQTY I.E., CLBAL/CLQTY
AND ISSUE VALUE IS RATE*QTY