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

  • movement class code

  • 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.

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, Movement or Item Class order. Press Enter (CR) to default to Item.

2. Beginning [Order Choice]

Press Enter (CR) or image\ex_allft_shg.gif to default to the FIRST record on file, or you can enter specific information to narrow the focus of your report. Press F2 or image\find_shg.gif to search.

3. Ending [Order Choice]

Press image\ex_allrt_shg.gif to default to the LAST record on file, or you can enter specific information to narrow the focus of your report. Press F2 or image\find_shg.gif to search.

4. Vendor/Item Class

Enter the vendor or item class to print. Press F1 or image\all_shg.gif 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 or image\all_shg.gif to default to ALL.

See Also

Selecting existing templates

Creating system templates

Editing the order, range and properties stored in templates

Setting printer properties in templates

Using print options in reports

Setting a default printer using templates topics

Using print options

Using report templates

Viewing reports on screen (using the viewer)

Register formats and procedures

Reports and Prints Menu Options

Using Reports