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