Overview

CompleteCount provides the tools needed to perform a controlled cycle count in Dynamics GP using stock tags. The stock tag method of conducting a physical count provides for an audit trail of the count, ensures a higher degree of accuracy, and keeps to a minimum the downtime required to conduct the count.

CompleteCount uses the Dynamics GP Inventory Stock Count tables to ensure the cycle count is visible to GP processes such as Inventory Reconcile, however CompleteCount is otherwise not dependent on the Dynamics GP Stock Count functionality.

The steps in the cycle counting process are listed below:

1. Set up Tolerance: CompleteCount supports the use of allowable count variance (Tolerance). If Tolerance is used, and the count for an Item is out of tolerance, the CompleteCount will not allow the count to be submitted. You will need to override the Tolerance (i.e. submit the out-of-tolerance count as-is), or move those items to a new Stock Count for a re-count. This step is done with the Mass Add/Update window, or individually in the CC Item Site Extension window.
2. Assign Value Codes to Items: CompleteCount uses a Value Code, rather than an ABC Code, because CompleteCount can assign codes from A to Z. This step is done in the Value Code Update window.
3. Assign Next Count Date and Cycle Count Interval. This step is done with the Mass Add/Update window, or individually in the GP Item Quantities Stock Count window (click the Stock Count button on Item Quantities Maintenance).
4. Assign Items to a Stock Count. This step is done with the Mass Add/Update window, or by adding items one at a time in the Build Stock Count window.
5. Start the Count and print Tags (or export to Excel)
6. Enter the Stock Tags count (or import from Excel)
7. Submit the Count
8. Post the Count using the Post Stock Count window

The Stock Count process begins with creating a Stock Count in the Build Stock Count window, then STARTING the count. The count can be performed using Stock Tags, which are recorded in CompleteCount, or in Excel. CompleteCount can either print the Tags needed for the count, or export the Stock Count to Excel, which is imported later after the count has been recorded.

If Stock Tags are printed, these are distributed around the warehouse, such as attaching one tag to each bin. Employees count what is immediately in front of the tag. As a second step, an Auditor may spot-check the count on some tags. The completed tags are returned to data entry personnel, who enter the count from the Tags into GP.

Alternatively, CompleteCount can export the Stock Count to one or more Excel spreadsheets. The count is entered into the spreadsheets, which are then imported back into GP. The import process creates virtual tags for the imported count, with one Tag per line in the spreadsheet(s).

CompleteCount has numerous Tag Reports which help identify error conditions that need to be addressed. For example, if the quantity allocated of an item is greater than the quantity counted, the over-allocated quantity needs to be released before submitting the Tags.

When you are ready to post the variance into GP, run the Tag Submission wizard. This process performs several data validation steps (i.e. checking for invalid Item Numbers) and ensures there will not be any allocation errors. The count on all tags is tallied so that if the same item was counted on several tags in different places in the warehouse the system has one total count of the item. The tallied count is “submitted”, which updates the Counted Quantity and Variance Quantity for each line on the Stock Count.

Lastly, the Stock Count is POSTED in the Post Stock Count window. This creates an Inventory Variance transaction for any discrepancies identified through the count.