PRBST Stocktake By Bin
<< Click to Display Table of Contents >> PRBST Stocktake By Bin |
![]() ![]() ![]() |
Where Stock Transfers are used to move inventory from one location to another you need to consider the following:
If, at one stock location, the computer stock on hand shows as less than the actual stock on hand this may mean that some other location (transferring location?) is showing computer stock on hand greater than actual stock on hand. Therefore a stock transfer is required, not a stock adjustment. A stock transfer adjusts the computer stock on hand quantity between two stock locations, while a stock adjustment will change the value of the cost of goods sold.
If the computer stock on hand shows greater than the actual stock on hand, this probably means that stock has been taken but not invoiced, or the actual quantity received was less than the stock receipt. Therefore a stock adjustment is required. The cost of goods sold is increased and the computer stock on hand is reduced.
You must have processed all stock receipts prior to the physical stock count.
A stocktake happens in real time, that is you do not have to stop selling because of a stocktake.
When creating a new stocktake, the stocktake is allocated a stocktake period. This stocktake period is important in that the actual stocktake must take place within this stocktake period.
When updating the stock count, the system will force the count date to be within the stocktake period.
Recording the date and time of the actual stock count on the stock sheets is very important. This count date and time is used to obtain the computer stock on hand figures and for the system to be able to compute count differences.
There is no time pressure to have to enter the stock counts into the system.
Stocktake Procedures:
• | Create a stocktake header. Remember, the physical count must be done within the stocktake period selected. |
• | Print stock sheets |
• | Arrange for the stock count to be completed |
• | Write the date and time of the count on the stock sheets |
• | Update the stock count and enter the count date and time from the stock sheets into the system |
• | Print count differences report |
• | Once all stock counts have been entered and count difference reports produced you |
can process stocktake differences (stocktake update)
Batch/Serial# Controlled Stock Locations
The stock sheets list the available batches for each item that is batch controlled. The stock count has to be updated by batch.
Stocktaking All Bins
You need to update all stock counts before processing stocktake differences, because it is possible that some stock items will appear on multiple stocktake sheets. The first stocktake sheet processed, that contains multiple stock sheet entries, will total the stock count from all stock sheets for the item, and update the count differences. The update of the item on the following stock sheet updates will be ignored.
Rolling Stocktake Of Bins
The stock sheet will identify those items that are located in multiple bins. The item count has to be the total of all the bins for the location.
Note that a stocktake update can be undone (reversed) if need be. The point to be aware of here though, is that a stock item for a stocktake can appear on multiple stock sheets, especially when bins are used. When this occurs a line is printed on the count differences report identifying the multiple stock sheets. So when reversing a stocktake that contains items that appear on multiple stock sheets, you must also reverse those other stocktake sheets. You will need to re process the stocktake differences for all reversed stocktake sheets.