Cycle Count History Query

Exploring

Where it fits in?

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.

Navigation

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

Program List > Inventory > Cycle Counting System

Terminology

Cycle count

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).

Related Information

Topics

Cycle Count

Starting

Security

Groups

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).

Configuring

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

Setup Options

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

Inventory Configuration

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?

* Development-Authors@za.syspro.com

Using

Hints and Tips

Columns in a list view 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 list view). Select and drag the required column to a position in the list view 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 list view or form to view a complete list of functions available.

Referencing

Cycle Count History Details

The information displayed in the list view 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

Options

This pane lets you filter the cycle count information you want to view.

Menu and Toolbar

Refresh Cycle Counts

This refreshes the information for the pane.

Autoload Values

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

Load Previous Form Values

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

Save Form Values as Default

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

Save Form Values for this Company

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.

Options

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

Cycle counts

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

Capture dates

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

Warehouses

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

Stock codes

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

Bins

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

Operators

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