Cycle Count Variance Monthly Report Layout

This section describes the report of the Cycle Count Variance Monthly Report.

Figure 1. Cycle Count Variance Monthly Report
Field
Description
Node

The node for which the report is generated.

Month Begins On

The date on which the count task begins.

Month Ends On

The date on which the month ends along with the count task.

Locations Counted

The number of locations for which the count task was performed.

Locations With Variance

The locations which showed variance.

System Quantity

The quantity defined with the Selling and Fulfillment Foundation.

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 sum of 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 percentage is 100.

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

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

Accuracy

If Count Quantity is zero than Accuracy is 0.

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

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

Variance Value

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

Variance Currency

The currency of Variance Value.

The Cycle Count Variance Monthly Report appears in portrait layout.