Purpose
A sample Inventory
Detail Report and description of the fields are listed below.
Note: The sample
report may differ from the actual report. The options used to configure
the report will determine the actual output of the report.
Figure
8.149 Sample Inventory Detail Report
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Inventory Detail 3/1/200X
|
|
|
Focus Cafe
|
created
at 3/8/200X 10:30:22 AM
|
Page 1
of 1
|
|
Tran
|
|
Units
|
Unit
|
%
|
|
|
|
Item
|
Type
|
Actual
|
Sold
|
Variance
|
Variance
|
Date/Time
|
|
|
Absolut
|
|
|
|
|
|
|
|
|
Absolut
|
SALE
|
|
1.25
|
-1.25
|
0.00
|
03/01/200X 20:13:02
|
|
|
POUR
|
0.89
|
|
-0.36
|
-40.45
|
03/01/200X 20:14:31
|
|
|
Total Absolut
|
|
0.89
|
1.25
|
-0.36
|
-40.45
|
|
|
|
|
|
|
|
|
|
|
|
Absolute Mandarin
|
|
|
|
|
|
|
|
|
POUR
|
1.06
|
|
1.06
|
100.00
|
03/01/200X 20:12:42
|
|
|
Total Absolute Mandarin
|
|
1.06
|
0.00
|
1.06
|
100.00
|
|
|
|
|
|
|
|
|
|
|
|
Crown Royal
|
|
|
|
|
|
|
|
|
POUR
|
0.87
|
|
0.87
|
100.00
|
03/01/200X 20:02:29
|
|
|
Crown Royal
|
SALE
|
|
1.25
|
-0.38
|
-43.68
|
03/01/200X 20:07:28
|
|
|
POUR
|
2.04
|
|
1.66
|
57.04
|
03/01/200X 20:08:36
|
|
|
Total Crown Royal
|
|
2.91
|
1.25
|
1.66
|
57.04
|
|
|
|
|
|
|
|
|
|
|
|
Malibu Coconut
|
|
|
|
|
|
|
|
|
POUR
|
1.32
|
|
1.32
|
100.00
|
03/01/200X 20:10:55
|
|
|
Total Malibu Coconut
|
|
1.32
|
0.00
|
1.32
|
100.00
|
|
|
|
|
|
|
|
|
|
|
|
Stoli Razberi
|
|
|
|
|
|
|
|
|
EMPTY
|
|
|
|
|
03/01/200X 20:11:48
|
|
|
OPEN
|
|
|
|
|
03/01/200X 20:12:42
|
|
|
EMPTY
|
|
|
|
|
03/01/200X 20:13:02
|
|
|
EMPTY
|
|
|
|
|
03/01/200X 20:13:34
|
|
|
OPEN
|
|
|
|
|
03/01/200X 20:13:34
|
|
|
EMPTY
|
|
|
|
|
03/01/200X 20:14:30
|
|
|
OPEN
|
|
|
|
|
03/01/200X 20:14:30
|
|
|
EMPTY
|
|
|
|
|
03/01/200X 20:14:57
|
|
|
Total Stoli Razberi
|
|
0.00
|
0.00
|
0.00
|
100.00
|
|
|
|
|
|
|
|
|
|
|
|
Well Rum
|
|
|
|
|
|
|
|
|
Well Rum
|
SALE
|
|
1.25
|
-1.25
|
0.00
|
03/01/200X 20:09:50
|
|
|
POUR
|
1.68
|
|
0.43
|
25.60
|
03/01/200X 20:12:28
|
|
|
Total Well Rum
|
|
1.68
|
1.25
|
0.43
|
25.60
|
|
|
|
|
|
|
|
|
|
|
|
Well Scotch
|
|
|
|
|
|
|
|
|
EMPTY
|
|
|
|
|
03/01/200X 20:14:02
|
|
|
OPEN
|
|
|
|
|
03/01/200X 20:14:02
|
|
|
Total Well Scotch
|
|
0.00
|
0.00
|
0.00
|
25.60
|
|
|
|
|
|
|
|
|
|
|
|
Well Vodka
|
|
|
|
|
|
|
|
|
POUR
|
1.49
|
|
1.49
|
100.00
|
03/01/200X 20:00:02
|
|
|
Well Vodka
|
SALE
|
|
1.25
|
0.24
|
16.11
|
03/01/200X 20:03:47
|
|
|
POUR
|
1.26
|
|
1.50
|
54.55
|
03/01/200X 20:07:42
|
|
|
Total Well Vodka
|
|
2.75
|
1.25
|
1.50
|
54.55
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Figure
8.150 Inventory Detail Report Fields
|
Field
|
Description
|
|
Item
|
The name of the Inventory Item.
|
|
Tran Type
|
|
Pour
|
A drink Pour
transaction was recorded by the 3rd party liquor control system.
|
|
Sale
|
The drink was ordered through the point of sale.
|
|
Empty
|
An Empty Bottle transaction was recorded by the 3rd
party liquor control system.
|
|
Open
|
An Open Bottle transaction was recorded by the 3rd party
liquor control system.
|
|
|
Actual
|
The Actual amount of liquor poured according to the 3rd
party liquor control system.
|
|
Unit Sold
|
The amount of the Inventory Item used according to the recipe in
Focus Inventory.
|
|
Unit Variance
|
The running Unit Variance (Actual pour minus Unit Sold).
|
|
% Variance
|
The running % Variance for the Inventory Item (Unit Variance divided
by Actual displayed as a percentage).
|
|
Date/Time
|
The
date and time the item was ordered.
|
|
Total
|
|
Actual
|
The
total amount of liquor poured of the inventory item according to the 3rd
party liquor control system.
|
|
Unit Sold
|
The total amount of the
Inventory Item used according to the recipe in Focus Inventory.
|
|
Unit Variance
|
The running Unit Variance (Actual pour minus Unit Sold).
|
|
% Variance
|
The running % Variance for the Inventory Item (Unit Variance
divided by Actual displayed as a percentage).
|
|
Figure
8.150.1 Inventory Detail Report Setup Options
|
Start Time
|
08:00
|
|
End Time
|
23:00
|
|
Summary
|
Selected
|
|
Items
|
All
Items.
|
Related Topics (none)
Sample Inventory Detail Report