Basit Khan

Basit Khan

  • 1.6k
  • 279
  • 60.8k

Stock Qty shows as per Material Issue Slip [MIS]

Dec 8 2016 9:06 AM
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_ItmNoMis_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
2225 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. 
 
 

Answers (1)