I believe I said basically the same thing. However, backorders are 100% irrelevant to this calculation. Backorders are outstanding until they are filled once stock has been replensihed. Once backorders are filled, they are no longer backorders, stock levels have been adjusted, and, therefore, a non-factor when doing this calculation.

You don't need a time stamp to do this, either. All you need is for the user to enter a date at which to get the stock levels. Of course all you can provide is the count at either the beginning or end of that date.

And yes, we get it. This type of calculation is not rocket science and is very do-able. This is still just like a checking account where I can calculate what my balance was at the end of the day on this date last year if I had access to my bank's database.

>in general I agree with you, but "Backorders should already be reflected in the current balance" only if they are not outstanding, and that’s just something else to calculate
>
>and like I said, don't you see that the qty will never be 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!!!
>
>and yes I am a inventory programmer (5 years with full training from MEI Philly PA.) I have a inventory program that has over 10,000 items and over 300,000 transactions a year over a WAN over 300 Miles wide and I think that the process over a length of time would be very slow. Sorry but I am a perfectionist and if I can't be 100% sure about a figure I will not make that data available and this is something that can't be 100% unless you bring time of transaction into play and I thing thats a bit overboard.
>
>but once again thats my opinion and I can be wrong
>
>
>
>
>>Backorders should already be reflected in the current balance and do not need backing out. Supplier backorders are product you have not received from your supplier. Backorders to the customers are product not yet delivered to the customer. The system I developed does not decrement the current balance until backorders or filled. Nor does it increment the current balance until backorders are received from the supplier. I would think this is how all inventory systems work [or should, IMHO].
>>
>>By adjustments I take it you mean losses due to shoplifting, theft, etc., and balancing gains and losses due to accidental substituting of a product for another [wrong item pulled to fill an order so on-hand for one item is short 1 and the other is over 1].
>>
>>>and adjustments and backorders
>>>
>>>>>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
>>>>
>>>>Think of it as a checkbook. From the current Quantity [balance], you have to subtract any product orders received by the client from their suppliers [deposits]. You have to add the net quantity sold to the customers [withdrawals]. This means you have to have a way of tracking, by date, the orders the client places and receives that restock his inventory as well as track all sales and returns by the customers.