Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Table of Contents
minLevel1
maxLevel7
excludeTable of Contents
Iframe
allowfullscreentrue
srchttps://player.vimeo.com/video/941698871
width500
height500

Accessing the Tool

Within the Clubessential Office Product:

  1. Choose Items the select Inventory Count Wizard.

  2. The Inventory Count Wizard will launch.

Screen Overview

Listed below are the options and settings for the Inventory Count Wizard:

  1. Process Count for Area - For Multi-Inventory Clubs, designates specific area to Inventory.  Use lookup button to assist with area selection.

  2. Item Category - This is a list of all Item Categories that are associated with Items that are marked as an Inventoried Item.

  3. Total Items - This is the total number of Items that are marked as Inventoried Items and associated with the Item Category Listed.

  4. Locked on Hand - This is current total count (quantity on hand per item) of all Items associated with the Item Category listed.

  5. Counts Entered - This column will reflect the total Item count for the Item Category listed once item counts have been entered.

  6. Locked On - This column displays the date the Item Category counts were locked.

  7. Lock Selected - This button is used to lock the count in the Lock on Hand column to be used as a reference point in regard to the Counts Entered.

  8. Unlock Selected - This button is used to Unlock Selected counts allowing the user to start over.

  9. Reset Selected - This button allows the user to reset the Counts Entered column back to 0 after counts have been saved for that Item Category.

  10. Lock Date – This is the date at which point the lock feature takes place.

  11. Lock Type – This specifies whether the lock should look at posted or unposted batches.  The cleanest and best process uses On Hand numbers and looks at posted batches.  Available provides an option for Users to include quantities impacted by unposted batches.

  12. Print Count Sheets – This button allows the user to print count sheets.

  13. For Category – choose All, Selected or a specific Item Category

  14. Show Locked Count on Count Sheet – if checked the locked count will print on the count sheet.

  15. Start New Page On Count Sheet For Each Item Category – if checked the system will page break after each Item Category. (regardless of length)

  16. Exclude Items with Zero Variance - if checked the system will only display records with variances; counted (physical) quantities do not match expected (book) quantities

  17. Enter Count Sheets – This button is used to enter the item counts.

  18. Final Review of Counts – This screen gives you an overview of everything that’s been done to that point, and allows you to complete the inventory count process.

Prepare for Inventory

Post Prior Batches

  1. Prior to beginning the Inventory Count, ensure all open batches impacting current On-Hand Inventory are posted.  The following Warning message will appear, and will serve as a reminder to handle these items.

  2. Click, “OK” to proceed.

Select Area (For Clubs Using Multi-Inventory System)

  1. For Clubs utilizing the Multi-Inventory System (Multiple Areas with Inventory), select area to be inventoried.  Start typing or Utilize Look-Up Button for assistance.You need to be sure that accounting has posted all sales up to current day before you.

Select Categories

  1. Select Categories for inclusion into Physical Inventory.  Select with Mouse (for Range), or Control Select (hold CTRL and click with Mouse), for singular selections.  

Lock Selected

  1. Once Categories are selected, click the Lock Selected button.  This will provide a snapshot in time of system (book) quantities.

  2. Once Locked, the “LockedOn” quantity column will populate with the Lock Date.  This may take a few minutes to appear.

Print Count Sheets

  1. To assist with the Physical Count Process, select,  “Print Count Sheets.”  Note that Printing options exist to Show All Locked Categories or a Selection, Show/Hide Locked Count on Count Sheet, and/or Paginate based on Category.  The “Exclude Items with Zero Variance” will apply only after initial counts have been entered.

  2. Example of Count Sheet

  3. Once printed, physically count the Inventory (either by hand, or with a Scanning device).

Enter Counts

  1. When physical counting is finished, click “Enter Count Sheets” to enter counts.  Counts may be entered manually, or with the assistance of a *.csv file generated from a Scanning Device.

Enter Manual Counts

To enter manual counts, type the physically counted quantities in the “Counted Quantity” column.

(Or) Enter Counts via *.CSV File

Instructions for converting the TXT file built by the inventory scanner into a CSV for upload are here

  1. Export data from scanning device to a .csv file.  Then, import data into system by clicking, “Import Counts from Scanning Device (*.csv).”

  2. Next, select (count) *.csv file, and click, “Open.”

  3. Counted Quantity” column will populate with data from CSV file.

Save Counts

  1. Once finished, click “Save Counts.”

Review Variance Report

  1. After clicking “Save Counts,” message will appear and will prompt user to review a variance report (Count Sheet Summary).

  2. Click “Yes,” to launch Variance Report and view Differences between System Quantities (Book), and Physically Counted Quantities (Physical).

Adjust Counts

  1.  After revisiting the Variance report, differences may be investigated.  Additional inventory may be found and/or counts verified again may yield a different result.  To change quantities previously counted, click, “Enter Counts Sheets” again.

  2. Note that a “Previous Count” column now exists.  New counts may be entered in the “Counted Quantity Column.

  3. “Total” column will reflect “Previous Count” + “Counted Quantity” Columns.  

    • Example: To decrease previously counted quantity from 60 to 59, enter “-1” in the “Counted Quantity” column.  Total will reflect new balance of 59. To increase previously counted quantity from 60 to 65, enter “5” in the “Counted Quantity” column.  Total will reflect new balance of 65.

  4. Once new counts are entered, click “Save Counts”.

Adjusting/entering counts may occur as many times as necessary.

Finalize Counts

  1. Once counts are reviewed and are deemed final, click the “Final Review of Counts” button.

  2. Final Variance “Diff” (difference/differential) will be shown.

  3. Click “Print Summary” to capture details associated with the finalization of this inventory.

  4. Print or Save the finalized Count Summary.

Generate Inventory Adjustment Batch

  1. To finalize the Physical Inventory process, click the “Create Inventory Adjustment Batch,” to have system auto-generate the Inventory Adjustment that will be posted in conjunction with the variances identified within the Physical Inventory process.

  2. After clicking to create the batch, a warning will appear asking for confirmation of the finalization process.  Click “Yes” to continue.

  3. System will generate batch and will appear for review.  Click “Post Batch” to post to G/L.

Reporting - Inventory On Hand

  1. To generate an On-Hand Inventory Report, navigate to Interactive Reports.

  2. Expand Inventory Option, and choose “Inventory On Hand”.

  3. Designate appropriate Area, and “View Report.”