Physical Evaluation Variance Report by Unit Variance

Purpose: Use this report to analyze the results of the physical inventory for the batch without updating the Item Location table with the new on-hand quantities.

How to print: Select Physical Inventory Evaluation Variance Report at the Physical Inventory Evaluation Report Screen.

RF physical inventory: This report does not include counts being entered in RF Physical Inventory (records in the Physical Inventory Upload New table). In order to include counts done in RF Physical Inventory, you must first accept the count to upload the records from the Physical Inventory Upload New table to the Physical Inventory table.

For more information: See the sample report in PDF format.

Note: This report is also available as a .csv (comma-separated value) file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in CSV (Spreadsheet) Format for more information.

Contents: The Sort by setting on the Physical Inventory Evaluation Report Screen determines the variance calculation or other means used to sort the report. Item locations or LPNs appear in descending order by units, cost dollars, percent of units, percent of cost dollars or item location.

• Control #: Physical inventory control number and whether the report is for a complete physical or a partial physical.

• Warehouse: Warehouse code and description.

• Item: A code for the item that is part of the physical.

• SKU: The SKU code for the item.

• Location: The location code.

• LPN: LPN number and LPN details (details display only if the Display LPN details field was selected).

• If the item location changed for an LPN due to the physical inventory, WHS/LOC CHANGED FROM 100/A010101 displays, where 100/A010101 is the warehouse and location where the LPN used to reside.

• If the LPN did not exist in the License Plate table prior to the physical inventory, NEW LPN displays.

• 1st, 2nd, Final Count: The first, second, and third count quantities entered to date; the evaluation count is indicated with an asterisk (*).

• Eval Count: The count quantity used to evaluate variance (Evaluation count).

• O/H Qty: The on-hand quantity on record before the physical inventory (On-hand quantity); if the report includes LPN details, the total for the item location will appear in addition to the total for each LPN.

• Unit Var: The unit variance, calculated by subtracting the Evaluation count from the On-hand quantity for the item location.

• Unit % Var: The unit percentage variance, calculated by dividing the Unit variance by the on-hand quantity (a unit percentage variance greater than 999.99 will not print).

• Cost: The item cost (from the Item/SKU table).

• Cost Var: The cost variance, calculated by multiplying the unit variance by the cost.

• Cost % Var: The cost percentage variance, which is the same as the unit percentage variance unless the cost is zero.

Note: The three cost fields, above, are not on the report if you use FIFO costing. See FIFO Costing.

• Batch #: The batch control number.

• 1st, 2nd, Final Ticket #: The first, second, and final ticket numbers if you use tickets.