Physical Evaluation Variance Report by Unit Variance | Contents | SCVs | Search | Glossary | Reports | XML | Index | Compare Physical Inventory Counts by Batch Report |
Physical Evaluation Variance Report by Item Warehouse
How to print: Enter 1 at the Physical Inventory Evaluation Report Screen. The system generates this version of the report only if you use FIFO costing; see Part M: FIFO Costing.
CWDirect Rel 3.5 Physical Evaluation Variance Report EKAPLAN INR1292 1/08/99 5:19:41 Page 1 By Item Warehouse Level - Unit Variance EZK Mail Order Control #: 1 Partial physical Warehouse 2 MAIN WAREHOUSE Eval Unit Eval O/H Var Cost Unit Item SKU Count O/H Qty Var Ext Cost Ext Cost Ext Cost % Var % Var PEN 220 100 120 220.0000 100.0000 120.0000 120.00 120.00 BRUSH GREN LRGE 0 0 0 .0000 .0000 .0000 100.00 100.00 A 0 93 93- .0000 .0000 .0000 100.00 100.00- CONTROL #: 1 220 193 27 220.0000 100.0000 120.0000 |
Contents:
• physical inventory control number
• whether the report is for a complete physical or a partial physical
• warehouse code and description
• item
• SKU
• the count quantity used to evaluate variance (Evaluation count) for all warehouse locations included in the physical inventory
• on-hand quantity on record before the physical inventory (On-hand quantity) for all warehouse locations included in the physical inventory
• unit variance, calculated by subtracting the Evaluation count from the on-hand quantity for the item location
• evaluation extended cost, calculated by adding the extended cost derived from all FIFO layers selected by the standard hierarchy
• on-hand extended cost, calculated by adding the extended cost from all FIFO layers for the SKU within the warehouse
• extended cost variance, calculated by comparing the evaluation extended cost with the on-hand extended cost
• cost percentage variance, calculated by dividing the variance extended cost by the on-hand extended cost
• unit percentage variance, calculated by dividing the Unit variance by the on-hand quantity
• batch control number
Physical Evaluation Variance Report by Unit Variance | Contents | SCVs | Search | Glossary | Reports | XML | Index | Compare Physical Inventory Counts by Batch Report |
WH01_07r CWDirect 18.0 August 2015 OTN