Variance Report

The Variance Report provides information for you to review based on your count input. Once it is "accepted," those changes are then adjusted against the individuals SKUs. The following basic information is provided:

You can choose to export or print the report for all SKUs or just those that have variances. Click the Back link to return to the Count screen.
The quantity difference is cited here.
The cost associated with the variance is cited here.
The retail value associated with the variance is cited here.

NOTE: The Oversells column tracks inventory that has been assigned a reason code of either POS Oversale and Create Inventory for Transfer.

Variance Acceptance for Reserved Inventory

When a variance is accepted, and there is impact against orders with reserved SKUs, the system functions as follows.

The system maintains reservations on a FIFO (first in first out) basis up to the amount of available inventory.
Once a variance has been accepted, any orders that have SKUs with a reserved inventory status but inventory is no longer available, those SKUs will fall into backorder status once automation (fulfillment) cycle occurs.
The Backorder Report under the Reporting tab (listed in middle drop-down) can be used to identify any orders that have a backorder status.
Website orders are also managed as backorders once the order is submitted. The system does not track each individual web session to determine what is in each cart regarding reserved inventory not being available.

Variance Report Column Definitions

Column	Definition
Product ID	System assigned product ID.
Style Locator	A six-digit numeric value that is auto-assigned to products upon creation. It provides a unique identifier to be assigned that can be added to product labels to allow tracking and/or placement identification within a retail store floor setting.
Style/Model Number	A unique identifier that represents user assigned part numbers.
Unit Retail	Retail price of product.
Sublocation	Location within warehouse: row, rack, shelf, bin.
SKU/Item ID	A numeric identifier that the CORESense database assigns to each SKU record.
SKU Description	A description of the SKU, between 15 and 100 characters.
Unit Cost	Default wholesale cost of the SKU.
Vendor	Default vendor of the SKU.
Current On Hand	Value = Stock + Reserved + Held + Assigned SKUs that are in shipment status of "New". It doesn't include assigned SKUs that are in shipments with status = Picking, Packing.
Count-Time On Hand	On hand count when user created count project. Data is the same for any subsequent counts on the same project.
Oversells	Quantity of units sold when no stock was available and driven by correction count reason codes.
Net On Hand	Value = Count-Time On Hand + Oversells.
Physical Count	Actual count quantity as input into count project.
Variance	Value = Physical Count - Net On Hand
Abs Variance	Absolute change variance value either (+) or (-).
Variance@ Cost	Value = Unit Cost x Variance
Abs Variance@ Cost	Absolute change cost value either (+) or (-).
Variance@ Retail	Value = Unit Retail x Variance
Abs Variance@ Retail	Absolute change retail value either (+) or (-).
Qty In Since Count	Inventory transaction adjustments back into inventory: returns, transfer in, purchase receiving, any positive increase adjustments with reason code defined as a correction.
Qty Out Since Count	Inventory transaction adjustments out of inventory: sales (take now and add to shipping box, transfer out, any negative adjustments with reason code defined as a correction.
Net Change	Value = Qty in - Qty out
Net Change/ Variance	Repeat data of Net Change and Variance.
Abs Net Change/ Abs Variance	Repeat data of Abs Net Change and Abs Variance.
Missing	This represents a count input that was not entered. This message assists in identifying any SKUs that should be accounted for per your project filter options. These SKUs need to have a value entered, or the system will zero-out the inventory. It is recommended that you not accept the variance and perform another count to capture those SKUs.