Physical count transactions may be performed periodically to keep your warehouse stocks accurate. There are couple ways to do it in Calem: a) Use Barcode module in Calem Mobile to perform physical count transaction; b) Use the Ajax Web Client; and c) Use excel template to perform bulk physical counting.
Option c) is discussed in this blog. Stock BIN report in Calem is used as a starting excel file. Next, the file is morphed into a format that can be uploaded to Calem.
Step 1. Select Stocks for Physical Counting
Go to Inventory | Report | Bin Level List to launch the stock report. This list shows all the stock bins and quantities.
Next, you may 1) click "Search Row" to show the filter row in the list view; and 2) filter by site, store or bin to narrow down the stocks to do physical count. You may skip 1) and 2) if you are doing full physical counting for your stocks. Finally, export (3) the list of items to an excel file.
2. Prepare Excel for Physical Count Import
The exported excel file includes columns not applicable for physical count, go ahead deleting them, and update column headings as below.
- "Item" to "Item (item_no)"
- "Store" to "Store (store)"
- "Bin" to "Bin (locator)"
- "Qty at Bin" to "Qty at Bin (qty)"
Next, perform physical counting and update "Qty at Bin". Save the file so it is ready for import into Calem.
3. Import Physical Counts
Go to Inventory | Transaction | Import Physical Count to launch physical count import form.
Click the green "+" button to start a new physical count file upload. Select the excel file prepared above, click "Save" in the upload screen to complete physical count transactions.