Cycle Count History Query

Exploring

This program lets you view details of completed cycle counts that have not yet been purged.

Things you can do in this program include:

  • View the date and time when cycle count quantities were captured.

  • View the cycle count verdict as well as when and how often stock quantities were recaptured.
  • View the captured bins, lots and serials.

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.
  • Fields on a pane are sometimes removed by default. You can reinstate them using the Field Selector option from the context-sensitive menu (displayed by right-clicking any field in the pane). Select and drag the required fields onto the pane.The captions for fields are also sometimes hidden. You can select the Show Captions option from the context-sensitive menu to see a list of them. Click on the relevant caption to reinstate it to the form. If the Show Captions option is grayed out, it means no captions are hidden for that form.
  • Press Ctrl+F1 within a listview or form to view a complete list of functions available.

Referencing

The information displayed in the listview is obtained from the InvCycleCountCapt table:

  • Cycle count
  • Capture date
  • Capture time
  • Warehouse
  • Warehouse description
  • Captured quantity
  • Operator
  • Confirmed date
  • Reference (captured against the cycle count detail line in the Cycle Count Capture program).
  • Verdict (Recount indicates the item was recounted and recaptured. Otherwise blank).
  • Stock code
  • Stock code description
  • Bin
  • Lot
  • Serial

This pane lets you filter the cycle count information 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.