Physical Inventory Count???

Question

Please verify that my process of counting the physical count is correct or not.

I open a count sheet for a specific supplier in physical inventory(SO Manager). Then I go to stock room and physically scan the barcodes of those items belonging to that supplier. In the meanwhile regular sale transactions, Transfers, returns are not stopped and carried through SO Manager and POS. One thing I take care of is that whenever an item is going out for selling, I scan it and then let it go. Any returns from customers are taken in through POS and is not taken into my Data Collector device. Similar case with transfers etc.

After collecting data in data collector device I import the file onto system. Add the date plus the current time as third column into the file. then import this prapared file into the count sheet and then press calculate. Whatever the differences may appear, I reconcile those items by examining the physical stock again. And then Finally commit after reconciliations.

Please tell me is this process good enough, any improvements/suggestions>?

Doug Pic-N-Pac · Accepted Answer

That sounds kinda like we do it Asad but we do it by departments. We pull a report for the cost of that department then go thru and count. We then compare the two totals after the count. We know that we can not stop sells or returns but we just know that it should take us very long with two count scanners going at a time. At the end of the year we count each entire store after the store is closed so then we know for sure how much we made that year. If you find a better way of doing it or have anyother ideas on it email I am always looking for better ways. doug"Asad" wrote:

Asad · Answer

Thanks alot for replying. I totally agree with your comment that selection of items should be further narrowed down to department level. We have decided to count our physical stocks on the basis of department and even categories with huge item quantities.

I have tested my practice and it works fine for me. Hopefully others may benefit from my practice of stockcounting and make their process efficient and accurate.

Just repeating the practice: Open a count sheet on the basis of department or category or supplier with counts=0. Save the count sheet by pressing Ok and let the SO Manager and POS be used for regular transactions. In the meanwhile, start scanning those items for which you have opened that count sheet. You should be careful about those physical stocks going out for sale. If it has not been scanned/counted yet, scan it and then let it go. When you are done with your data collection, add a third column with date and time. There is very important point to explicitly note. The date and time should be exactly same when you first opened the count sheet or some where in between the opening datetime and time of first ever transaction of those freezed items. Now use the "import file" button to import the data in this final prepared file.

This will update the item quantities > That sounds kinda like we do it Asad but we do it by departments. We pull a

Physical Inventory Count???

Join the Discussion

Didn't find your answer?