And does anyone comprehend that it is never exact!!
he wants Jan 1st
well Jan 1st
8:00 - 50
8:30 - 49
8:35 - 45
9:00 - 0
!! 3 hours with out stock !!
12:01 - 150
etc.. etc..


Do you guys get it?? do you give him the beginning of the day, the end or the average???

either way / any way you look at it your giving him false information!!!

unless you also add a time, and personally thats to much data to store and the process would be pretty slow (I believe) after a while.



>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