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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only