Cycle Count Query

Exploring

This program lets you view a summarized version of cycle counts.

Things you can do in this program include:

  • View the stock codes that have been counted per cycle count.
  • Compare the original with the counted quantities.

This program is accessed from the Program List of the SYSPRO menu:

  • Program List > Inventory > Cycle Counting System

This refers to an inventory auditing procedure whereby a small subset of inventory items (or specific locations) are designated to be counted on a specified cycle.

The information derived from the cycle count can be used to determine the accuracy of stock levels within the entire warehouse (e.g. if discrepancies are found between actual and system stock levels, similar variances may be expected in other areas of the warehouse).

Topics

Cycle Count

Starting

You can restrict operator access to programs by assigning them to groups and applying access control against the group (configured using the Operator Groups program).

The following configuration options in SYSPRO may affect processing within this program or feature, including whether certain fields and options are accessible.

The Setup Options program lets you configure how SYSPRO behaves across all modules. These settings can affect processing within this program.

Setup Options > Configuration > Distribution > Inventory

  • Fixed bins
  • Multiple bins
  • Associate serials by bin
  • Show Warehouses (hyperlink)
    • Accounting for shortages

Solving

Why don't you drop us a line with some useful information we can add here?

* product-authoring@syspro.com

Using

  • Columns in a listview are sometimes hidden by default. You can reinstate them using the Field Chooser option from the context-sensitive menu (displayed by right-clicking a header column header in the listview). Select and drag the required column to a position in the listview header.
  • Press Ctrl+F1 within a listview or form to view a complete list of functions available.

Referencing

The following information is displayed in the listview:

  • Cycle count
  • Capture date
  • Warehouse
  • Warehouse description
  • Stock code
  • Stock code description
  • Reference
  • Unit of measure
  • Bin
  • Captured lots and serials
  • Captured quantity
  • Original quantity

This pane lets you specify which cycle counts you want to view.

This refreshes the information for the pane.

These options let you indicate how you want to save the selections made in the pane.

This sets all selections as they were when you last ran the program.

This saves your selections in the pane as your default preferences for all companies

This saves your selections in the pane as your default preferences for the current company only

If you've saved form values for the company (or as the default) then you can remove these settings and restore them to the form's default preference selections.

This lets you indicate whether you want to only include confirmed cycle counts.

This lets you filter cycle count capture information according to a selection of cycle counts.

This lets you specify the capture dates for which you want to view cycle counts.

This lets you filter cycle count capture information according to a selection of warehouses.

This lets you filter cycle count capture information according to a selection of stock codes.

This lets you filter cycle count capture information according to a selection of bins.

This lets you specify the operator who captured and processed the cycle count data.

This window is displayed when you select the View Lots hyperlink in the Captured Lots and Serials column and indicates the following information:

  • Cycle count
  • Lot
  • Original quantity
  • Captured quantity
  • Reference
  • Version
  • Release
  • Lot expiry date
  • Bin
  • Stock code
  • Warehouse

This window is displayed when you select the View Batch Serials or View Manual Serials hyperlink in the Captured Lots and Serials column and indicates the following information:

  • Cycle count
  • Serial
  • Original quantity
  • Captured quantity
  • Reference
  • Version
  • Release
  • Bin
  • Stock code
  • Warehouse