Stock Qty shows as per Material Issue Slip [MIS]

Question

Hi,

 

I have two tables called Stock Table and MIS table. In stock tables fields are Stk_ItmNo, Stk_Qty, Stk_Location

MIS tables columns are Mis_No, Mis_Date, Mis_ItmNo, Mis_Qty

 

What i'm looking for is suppose

 

Stk_ItmNo	Stk_Qty	Stk_Location
111	4	A
222	6	B
333	8	A

 

if Suppose 2-Dec-2016 is i made MIS for following items

 

Mis_No	Mis_Date	Mis_ItmNo	Mis_Qty
MIS-0001	2-Dec-2016	111	2
MIS-0002	2-Dec-2016	222	1

 

then after issue MIS stock table will below

 

Stk_ItmNo	Stk_Qty	Stk_Location
111	2	A
222	5	B
333	8	A

 

what i want is when i'm checking stock report dated 1-dec-2016 then stock will be shown as below

 

Stk_ItmNo	Stk_Qty	Stk_Location
111	4	A
222	6	B
333	8	A

 

 

How to do this.

 

Thanks

Basit.