Physical Inventory Count Detail Report Layout

This section describes the layout of the Physical Inventory Count Detail Report.

Figure 1. Physical Inventory Count Detail Report
Field
Description
Modify TS

.

Request Type

The type of request.

Zone ID

The identifier of the zone.

Location ID

The identifier of the location where the item is placed.

Item ID

The identifier of the item.

Inventory Status

The inventory status of the item.

LPN Type

Container type - Case or Pallet.

LPN No

The identifier of the container.

Quantity

The quantity of the item.

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.

Absolute Variance Value

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

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

Unit Cost

The total value of the item.

Cost Currency

The currency in which the cost of the inventory displays.

Color Code

The unique code for eachcolor.

Size Code

The unique code for each size.

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 Physical Inventory Count Detail Report appears in portrait layout.