Running the Rebuild of the Stock Summary if a stock count is uploaded after the period end.
Understand how to manage stock summaries efficiently by learning how to rebuild them when a stock count is uploaded post period end.
So the stock summary (period end) is normally built at midnight at the end of a period to take the stock records as the stand and write them away.
The OData Stock Summary Rebuild Utility can be run by Ten-25 for you to update the month end figures to account if a stock count was counted before the period end, but not uploaded until after the period end.
When we do the period end rebuild it takes the stock as it is today and uses all the physical stock movements to work back to what the stock would have been at the period end, based on today's figures.
So following a timeline of events for one product at one depot as an example:
- System shows there are 8 buckets in stock on 25th April
- A count is done on 26th April for 12 buckets, but not uploaded
- In the days from stocktake to month end 3 are purchased and received, and 4 are sold and supplied.
- At midnight of 31st April the system writes away a period end stock summary of 7 buckets (8 stock + 3 in - 4 out)
- In the week after the 31st 10 more are purchased and 3 more are sold. So the stock on 5th May shows as 14 buckets (7 buckets + 10 in - 3 out)
- The stock count is uploaded on 5th May
- The system calculates from 14 buckets today back to 26th April that 14 buckets less all the movements the stock was 8 buckets, but the count was for 12.
- It either puts in an adjustment in for 4 buckets, or zeroises 8 buckets and puts in a count of 12 buckets.
- So the stock on 6th May will now show as 18 buckets (14 + count adjustment of 4 historically)
- When we then run the OData Period End Rebuild, that takes the 18 buckets now in stock, reverses the May movements (- 10 out and +3 in) and writes away that the stock would have been 11 buckets at the end of April.
So with that example, you should now have a count record for 26th April for 12 buckets, a movements report that says 3 came in and 4 went out between 27th and 31st April, and a period end stock summary that says you had 11 buckets at the end of April (the year).
If you don't run the rebuild the Stock Summary report shows that you had 7 buckets at year end rather than 11.