Standsheets displays a breakdown of count-in variances and sales variances by vendor, category, and inventory item. Count-in variance is the difference between expected count-in and actual quantity in. Sales variance is the difference between inventory sales (expected sold) and POS sales.
This report is most often used to review standsheet variances at end-of-day or after an event. Specific events can be chosen from the filters provided.
Options
- Start Date/Time (Date Opened): inventory date opened from
- End Date/Time (Date Opened): inventory date opened until
- Group Time By
- Summary
- Detail
- Variance Type
- Sales Variance
- Count In Variance
Filters
- Inventory Reports ID
- Event Type
- Event Name
- Primary Category
- Item Description
- Vendor Name
- Vendor Group
Measures
- Expected Count In
- Quantity In
- Count in Variance: quantity in (minus) expected count in
- Count in Variance ($): Count in Variance (times) item price
- Expected Sold
- Inventory Sales ($): expected sold (times) item price
- POS Sales
- POS Sales ($): POS sales (times) item price
- Sales Variance: POS Sales (minus) expected sold
- Sales Variance ($): sales variance (times) item price
- Transfers In
- Transfers Out
- Transfers During: transfers in (minus) transfers out