Sample Inventory On Hand Report

Purpose

A sample Inventory On Hand 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.68 Sample Inventory On Hand Report

Inv On Hand for 3/6/200X

Focus Cafe

created at 3/6/200X 1:44:57 PM

Page 1 of 1

Chicken White Meat

3/3/200X

Case

23.00

8.00

20.65

10.35 Case(s)

Chicken Wings

3/3/200X

Case

5.00

1.00

4.50

1.50 Case(s)

Chicken Dark Meat

3/3/200X

Case

6.00

3.00

8.04

0.96 Case(s)

Wingers

3/3/200X

Case

10.00

4.00

14.60

-0.60 Case

COKE

2 liter Coke

3/3/200X

Btl

24.00

0.00

3.00

21 Btl(s)

Bottled Water

3/3/200X

Case

5.00

1.00

4.50

0.5 Case(s)

Figure 8.69 Inventory On Hand Report Fields

Field

Description

Item

The name of the Inventory Item.

Vendor Name	The name of the Vendor if the Sort option is set to Vendor.
Subgroup	The name of the Subgroup if the Sort option is set to Subgroup.

Beg Date

The date that a physical count was last taken for the item. If a physical count has not been performed for an item, a “--------“will display in this field.

Stock Unit

The stock unit defined for the item.

Begin Inv

The starting count of goods.

Purchases

The invoices entered into the system which occurred AFTER “Beg Date” and before or on the user specified end date. Only purchases from posted Invoices are accumulated.

Qty Sold

Sales that occurred after Beg Date and before or on the user specified end date.

Expected On Hand

Begin Inv plus Purchases minus Qty Sold.

Figure 8.69.1 Inventory On Hand Report Setup Options

Sort	Vendors
Vendors	Tyson, Coke

Related Topics (none)