Inventory Turns Report (ICR725)

Using Reports

Use this program to obtain an Inventory Turns Report based on the last 12 periods usage and the average beginning on hand quantities.

Turns equals total cost (usage times (x) average cost) for 12 periods divided (./.) by average value (average beginning on hand value) for 12 periods.

Report information includes:

warehouse	costing unit of measure
item number	total cost
description	average on hand
rank range information	average value
seasonality code	inventory turns
total usage	warehouse totals
stocking unit of measure	report totals
average cost	total number of items listed

An asterisk (*) indicates that there is insufficient data to calculate turns and those items are not included in the totals.

A Rank range can be set at the company level, alone, or, it can also be set at a warehouse level. When the rank is set at the company level, the rank information is displayed in the header of the report (and indicates what the type is, either ‘Percentage’ or ‘Hit Count’) and the range that makes up each of the 5 possible entries (A – E). When the warehouse level is set, the warehouse level rank over-rides the company level rank with its own rank values and type of hit count. The Warehouse Rank value only prints on the report when a rank range is specified at the warehouse level.

To access this program, choose Inventory Control-->Reports & Prints -->Inventory Turns Report.

Use the following fields to print an Inventory Turns Report:

1. Order

Enter whether to print in Item, Alpha, Vendor, Rank or Item Class order. Press Enter (CR) to default to Item.

2. Beginning [Order Choice]

Press Enter (CR) to default to the FIRST record on file, or you can enter specific information to narrow the focus of your report.

3. Ending [Order Choice]

Press Enter (CR) to default to the LAST record on file, or you can enter specific information to narrow the focus of your report.

4. Vendor/Item Class

Enter the vendor or item class to print. Press F1 to default to ALL.

5. Item Description

Enter whether to print item description 1, 2, or Both from Item F/M. Press Enter (CR) to default to 1.

6. Warehouse

Enter up to 20 two-character warehouse codes side by side to print. Press Enter (CR) to default to the warehouse assigned to the terminal. Press F3 to default to ALL.

Inventory Turns Report (ICR725)

Using Reports

Report information includes:

Use the following fields to print an Inventory Turns Report:

See Also

Using Reports