Cycle Count Variance Daily Report Layout

This section describes the layout of the Cycle Count Variance Daily Report.

Figure 1. Cycle Count Variance Daily Report
Field
Description
Node

The node for which the report is generated.

Date

The date on which the counting task takes place.

Item ID

The identifier of the item.

Item Description

The description of the item.

PC

The product class to which the item belongs.

UOM

The unit of measure for the item.

Location ID

The identifier of the location where the item is placed.

Container Type

The type of container in which the item is placed.

Container No.

The container identifier of the shipment in which the item is placed.

System Quantity

The quantity of the item as recorded in the system.

Count Quantity

The actual quantity counted by the user.

Variance Quantity

The difference between the System Quantity and the Count Quantity.

Absolute Variance Quantity

The absolute of variance quantity.

Even when the Variance Quantity is negative, the Absolute Variance Quantity is considered to be positive.

% Variance

If System Quantity is zero than % Variance is 100.

If System Quantity is not zero than % Variance is calculated as follows:

% Variance = (Absolute Variance Quantity / System Quantity) x 100.

Accuracy

If Count Quantity is zero than Accuracy is zero.

If Count Quantity is not zero than Accuracy is calculated as follows:

Accuracy = (Count Quantity / System Quantity) x 100.

Variance Value

The product of the unit cost of the item and the absolute variance quantity.

Variance Currency

The currency of Variance Value.

Report Totals: The report total displays the summary of Location IDs, System Quantities, Count Quantities, Variance Quantities, and the Variance Values considering all the items.

The Cycle Count Variance Daily Report appears in portrait layout.