Versions Compared

Key

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

Office Help Home

...

The Inventory Count Wizard enables Users to perform a Book to Physical Reconciliation within the Office Product, and post the associated Inventory Adjustments related to the process.  The tool has Count Sheets to assist with Physical counting, and online reconciliations to help finalize Inventory Adjustments. Managers at Clubs will want to perform physical counts of their inventory , and book the related adjustments (overages/shortages) to ensure financial statements are properly stated, and to determine that financial controls and processes are effective.  

...

Note: Sections of the videos have been referenced below with corresponding times in the video for ease of access

Total Video (Length)7:31   


Prepare for Inventory0:00 
Adjust Counts4:21
Print Count Sheets2:26 
Finalize Counts5:13
Enter Counts2:43 
Generate Inventory Adjustment Batch6:10
Save Counts & Review Variances3:48 
Reporting - Inventory On-Hand6:55


  

Widget Connector
width900
urlhttps://www.youtube.com/watch?v=KIPKPZ2LE_I
height600

Content

Table of Contents
maxLevel3
minLevel2

...

    1. Choose Items

    2. Inventory Count Wizard

...


Screen Overview

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

...

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

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

...

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.

 


Example of Count Sheet


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

...

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

 


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

...

 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.

 


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

...

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

 


Print, or Save the finalized Count Summary.

...

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

 


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


Designate appropriate Area, and “View Report.”


 

FAQs

Q. Can I still ring in sales while doing my inventory process?

...

A. Once Reset Selected button is pressed, all counts are removed and must be re-entered.

 


Q. I clicked on the Unlock Selected button by accident. How do I get it back?

A. Once Unlock Selected has been clicked, the inventory process has been undone, and must be started again.

...


Downloadable Guide

Inventory Count Wizard