Well you tell him thats it is never a exact thing, cause throughout the day the qty might change 10 times, so which time does he want or does he want a range? And if thats the case you must record the date/time for every transaction. Which is really going overboard in my opinion

>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