Physical Count Inventory

If you would like to watch a recorded webinar of Physical
Count, click here.

 

Preparing for inventory:

1. Make sure ALL: Tickets, receivers, RTVs, transfers and inventory adjustments are POSTED
   1. Run an edit list in each of areas, make sure they are empty
      1. POINT OF SALE → TICKETS → EDIT LIST
      2. INVENTORY → ADJUSTMENTS → EDIT LIST
      3. PURCHASING → RECEIVING → EDIT LIST
      4. INVENTORY → TRANSFERS → TRANSFER IN → EDIT LIST
      5. INVENTORY → TRANSFERS → TRANSFER OUT → EDIT LIST
2. Run an inventory valuation report. Print the last page INVENTORY → REPORTS → VALUATION
3. Print an Inventory Analysis by category
   1. INVENTORY → REPORTS → INVENTORY ANALYSIS, select by Category (Summary)
      Select ALL items, Select your location
4. Make sure you have a current back up of your database
5. Remove any old physical count records that may have been created (INVENTORY → PHYSICAL COUNT → REMOVE)
6. Print your Count Area Check sheet
7. Test Cipher (load lookup if applicable)
8. Label your sections
9. Create your physical count (INVENTORY → PHYSICAL COUNT → CREATE)
   1. Choose the location to create a physical count for
   2. Filter by category, vendor, etc for cycle counts
10. Print Worksheet if desired

Counting

If using Cipher:

1. Scan your section
2. On the Cipher:
   1. Press ESC, twice to return to the main menu.
   2. Select UPLOAD, the screen will say “Connecting…” place in dock
3. On the Computer:
   1. Select Shortcut to READ DATA on desktop
   2. Once the upload is complete, answer YES to “Do you wish to view imported records”
   3. Review the list to see if anything looks unusual, you should see item number, followed by qty, followed by price
   4. Select FILE → SAVE AS
   5. Enter the name for the file (section) Example: A1
   6. Mark off on your area checklist
   7. Close the read data window
4. On the Cipher
   1. Delete Data? Select ALL DATA
   2. Are you sure? Select YES
   3. Press ESC to return to the main menu, select Collect
5. Repeat for all sections

If using worksheet

1. Print worksheets for desired areas (you can filter by category, sub category, vendor, etc)
2. Enter your counts on the worksheet
3. Select INVENTORY → PHYSICAL COUNT → ENTER
4. Enter the item number
5. Enter the quantity
6. SAVE the record
7. Repeat for all items on your worksheet

Quick Tip:

You can do a combination of importing and hand entering for your non-scannable items.

Importing

1. Select INVENTORY → PHYSICAL COUNT → IMPORT
2. Click the … next to file name
3. Choose the file (Section) to import (Example A1.txt)

4. VERIFY the location is correct
5. In the Item box, type a 1
6. In the Quantity box, type a 2
   1. Tip: Enter the counter and section for count user and count notes
7. Select VERIFY (mark on Count area checklist)
   1. If no errors in the results move to step 8
   2. If errors exist, find the items that are shown as errors from that section, add item in INVENTORY → ITEM if not on file, or find correct barcode
8. Select IMPORT (MARK ON COUNT AREA CHECKLIST)
9. Repeat for all sections

Quick Tip:

You can do a combination of importing and hand entering for your non-scannable items

Quick Tip:

Make sure to only import each file only once or you will double your counts.

Edit List

1. Select INVENTORY → PHYSICAL COUNT → EDIT LIST
2. To view ALL items, select:
   Frozen, Actual counts, variance and check the boxes for Include uncounted items and print variances for uncounted items

To only view items with a variance, also select Print non zero variances only:

3. OPTIONAL: Select Group by Category to view your report by category
   OPTIONAL: Enter a Quantity to hide when the variance is less than (Ex only show items where the variance is greater than 5)
4. Review your edit list. Recount and ENTER new quantities for anything you find that is incorrect, review your edit list as much as you need to until you are satisfied.

Posting

After you are satisfied with your edit list, you will need to post your physical count

1. Select INVENTORY → PHYSICAL COUNT → POST

1. For uncounted items, select “Assume quantity counted is zero”
2. Click POST
   This will take some time depending on the number of items you have. When you are done, the physical count journal will be displayed. Print the last page for your variance.
3. Run an inventory valuation report. Print the last page
   1. INVENTORY → REPORTS → VALUATION
4. Print an Inventory Analysis by category
   1. INVENTORY → REPORTS → INVENTORY ANALYSIS, SELECT BY CATEGORY (SUMMARY)

Quick Tip:

Anything that was on your edit list that showed **uncounted** will be set to 0.

Quick Tip:

The variance report will be the difference between the Valuation and Inventory Analysis before inventory and after inventory.