Hi John

Not quite understand ?
what in mind :-

Current Qty = 13

stockout :-
5/09/2001 Inv 001231 qty = 5
5/09/2001 Inv 001230 qty = 3
4/09/2001 Inv 001999 qty = 2
3/09/2001 Inv 001800 qty = 10

Stockin :-
5/09/2001 qty = 10
4/09/2001 qty = 3
3/09/2001 qty = 10

openning qty on 3/09/2001 / closing stock on 2/09/2001
= current qty(13)+ stockout(5+3+2+10) - stockin (10+3+10)
= 10

Smile :)

Patrick

>HI,
>How could I calculate weighted average of item for a given date? I found that, >I couldn't get the actual qty of items while stock in becoz invoice doesn't >contain time field. Therefore, while I am doing backdated to get the qty of >given date. The qty i get may not the same with the qty while stock in becoz >it may be sold, transfered and etc after that. The weighted average will be >diffierent with the actual.
>How could I solve it?

>Thank you