Processing an Inventory Cycle Count

The following are the procedures to be followed when you perform a cycle or partial count of the inventory items in a single warehouse. 

1.  Determine the items to be processed.  When a partial inventory count is performed, the system allows you to select the items to be counted in the selected location using a Bin (physical warehouse location), Item Number, or Item Description range.  You should determine the range of items to be counted and note this range as it will be used throughout the count process.  The normal procedure is to process a cycle count using a defined bin (warehouse physical location) range.

2.  Halt all invoicing, receiving, and inventory transfer operations.  Halt all activity that will affect inventory on hand quantities in the location to be processed.

3.  Prevent the addition of any new items to the Inventory Master file.  It is recommended that no new inventory items be created in the location being processed until all of the steps in the count procedure have been completed.  This is due to the fact that the addition of new items can slow down the data entry process and create confusion among the personnel performing the count (if items in the range being counted are not printed on the count sheets and are found during the physical count, they should be noted separately and handled as a separate step).

4.  Optional but recommended.  Record the value of the inventory in the location to be processed.  An inventory valuation report may be run to record the value of the inventory at the beginning of the count process.  This report can be used to verify the changes that will be made to the inventory subledger as a result of the count process and to substantiate the entries which will need to be made to the general ledger at the end of the count process.  This step is somewhat optional as the system will provide you with reports that list the actual changes made to the inventory quantities and values, but it can be performed quite easily and it provides additional printed backup for the count process and resulting financial effects.  The valuation report can be produced at the beginning of the count process or just prior to the update which is done at the end of the count process depending on whether or not  other transactions are being processed during the count process.

5.  Verify the Bin Reconciliation programs do not show any bin errors for the location and items to be processed.  The Bin reconciliation programs (FV096R06 and FV096r07) are used to compare the inventory on hand quantity for each item to the bin quantities for the item, and to compare the committed quantity in each bin to the open pick and pull tickets for each bin.  Both of these reports should be run and checked for errors (and the errors should be corrected), before a count is processed in the location.  See the Bin Management section of this document for more information about Bin reconciliation and adjustment.

6.  Select the Prepare Inventory Count program from the menu

•      Highlight the warehouse location to be processed from the list displayed by the program and press the ENTER key to  select the location.

•      Select the appropriate  Bin, Item Number, or Item Description range and note this information for use later on in the count process.  If you are performing a cycle count, you should select the bin, item, or item description range that you are actually counting.  All of the selected items should be counted during the count process.

•      Enter a Y in the Create count records with a 0 quantity selection to force the entry of the actual quantity found for each bin/item.  If a N is entered for this selection, the count records will be created with the current on hand quantity for each bin/item.

•      Select the output option for the report produced by the program.  The Prepare Inventory Count program will produce a list of any errors it encounters during processing.  If the report shows errors, the errors should be fixed and the Prepare Inventory Count program should be re-run until it is error free.

•      If the selections are correct, accept the Y which defaults into the Selections OK - Begin Processing selection and press the ENTER key to begin processing.  If you need to make changes to the selections displayed on the screen, input an N in the Selections OK - Begin Processing selection.  This will allow you to re-enter the selections to be used by the program. Once you have entered the appropriate selections and have entered a Y into the Begin Processing selection,  the Prepare Inventory Location for Physical Count program does the following.

•      Clears the Inventory Count file of all count records for the selected location.  Clearing the Inventory Count file ensures that the Count file does not contain any records from prior counts for the location being processed

•      Creates a count record for each bin/item combination in the range being counted.

•      Moves the on hand quantity for each inventory item and bin to pre-count quantity fields in the bin and item records.

7.  Check the Count records created by the system.  Once the Prepare Inventory Count program has finished processing, you should be able to view the count records created by the program in the Count Management program.  If the records in the count file look incorrect (too many or too few), you may use the Prepare Inventory Count program to clear out and re-load the file.

8.  Print Inventory Counting Worksheet.  The StreamII Count Worksheet or Bin Contents report (FV096R05) allows you to select an Inventory location and a bin range to be counted.  You may also generate other count worksheets or tickets, based on the location and item or bin range being processed.  The standard report outputs in Bin then Item sequence, and it allows you to print or suppress the printing of the quantity for each bin.  The report also allows you to select only items with values over a specified dollar amount (this selection is normally not used since the Prepare count program does not include the same option).

9.  Count the Inventory.  Count the inventory and record the actual quantities found on either the count sheets printed in the previous step or using the automated data collection device. 

10. Input the Counted Quantities.  Select the Count Management program from the menu.

•      Verify or change the location shown in the top of the program (the location can be changed by usingthe F10 or menu key to access the Change Location option shown under the Options submenu.

•      Select the display sequence to be used for entering the count information.  This will normally be bin sequence if you are performing a cycle count and are using the standard worksheet.

•      Find the count record for the item and enter the counted quantity.  The Prepare count program creates count records  for each bin and item combination in the location and range being counted.  You should find and edit the count record to input the counted quantity.  You may also enter a short note and a ticket number into each count record.

•      If you do not have a count record for a bin/item combination that is “found” during the count (and the bin/item is in the proper range being counted), you should add a count record (and a bin record if required) for the item.  This can be done using the insert key.  When you press insert, the count program prompts you for the item that the count record should be created for.  Once you select an item, the system displays the existing bins for the item.  You may press the insert key in the bin list to create a new bin for the item (this is normally required) and once you have created and selected the bin, the system will create a count record for the bin and item combination.

Note:  If you delete a count record, the system will not process the bin/item combination (bin/item combinations are not adjusted unless count records are present for them).  The delete option is normally disabled in the Count Management program. 

Note:  You may only create one count record for each loc/item/bin combination in each warehouse.  The system compares the count qty for each bin to the pre-count quantity for the bin, and it expects only one record for each loc/bin/item being counted. 

11. Print the Cycle Count Variance report  The Cycle Count Variance report outputs in bin order.  It lists the quantity variances for each bin/item combination in the count file.  The report also outputs the other bins that are present in the warehouse for each item that has a variance (in case the item quantity is not short, and the error is only due to the bin quantities being off – this can be important when only some of the bins that the item is stored in are being counted).  The variance report also checks to make sure none of the bins being processed have activity (that the quantity in the bin has not moved during the count).  If movement occurs, the count is invalid.

12. Recheck any items with large variances and adjust the count quantities as required.  The Cycle Count Variance report can be re-run until you are sure that the variances shown on the report are correct.

13. Run the Costed Variance Report.  This report also prints in bin sequence and it shows the variance for each bin/item in units and in dollars (based on the unitcost of the item).  This report previews the inventory adjustments and the accounting adjustment that will be made when the count is applied.

14. Optional but recommened. Back up the files which will be affected by the adjustment process.  Backing up the Inventory Master file (File 70), Bin file (96) and the Inventory Activity file (File 91) is an optional but highly recommended precaution.  Performing this step requires that the actual count update process be performed after hours, or on a weekend, when no other inventory activity is taking place, but it allows you to recover easily if the update process is interrupted by a hardware or power problem, or if the update produces unexpected results.

15. Run the Apply Inventory Count program.  The Apply Inventory Count program actually adjusts the bins and item records based on any variances found during the inventory count.  The program can be run in both preview only and live mode.  You should run the program once in preview mode and review the report output by the program.  This report will show the actual changes to be made by the count programs and the value of these changes.  The value change shown on the report should agree with the amount shown on the Costed Count Variance report. 

16. Once you are satisfied with the information shown on the final variance reports and have previewed the count adjustment, you should re-run the program and select Y to Update file. When you select Y to update, the system will display the amount of the proposed changes, and it will prompt you to re-input  the adjustment amount.  Once the adjustment amount is confirmed, the system will apply the count information to the system.  The Apply Count program will adjust any bin and item quantities as required, write inventory and bin activity records to record the changes, and post these changes to the GL.

More:

Processing a Complete Inventory Count