>Hi,
> I am developing POS (Point od Sales) system. My client request to have feature that able to view the stock balance at the particular period such as 2 months ago or may be 2 days ago.
> How could I retrieve the stock qty at certain period? Should I re-calculate the total purchase, total return, total sales of items in order to get these stocks balance?? What do you do for these?
>
>Thank you
I think that, indeed, the best alternative is to re-calculate all data that affects the stock balance. And that is exactly what I do, in a similar system.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)