Surplus Stock Report (ICR715)

Using Reports

Use this program to obtain a report of all items whose available quantities are at or above their maximum stocking levels. The available quantity is defined as the on hand minus committed quantity. The surplus for order point/line point is defined as the available less order quantity plus line point. It represents the number of months you should expect to go before you sold all surplus stock.

Report information includes:

  • warehouse
  •  stocking unit of measure
  • item number
  •  cost
  • description
  • costing unit of measure  
  • rank range information
  • extended cost 
  • trend type
  • warehouse totals 
  • order quantity plus line point
  •  report totals
  • surplus
  •  total number of items listed
  • available stock

     


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 -->Surplus Status Report.

Use the following fields to print a Surplus Stock 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. Smallest/Stocking

Enter whether you want to print items in the smallest unit of measure or in the default stocking. Due to precision, the count won’t include rounding when you print in the smallest unit of measure.

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

8. Restocking Type

Enter whether to print restocking type Order/line point and/or Min/Max. Press F1 to default to ALL.

9. Include Cost

Indicate whether to include cost information in the report. Press Enter (CR) to default to selected.

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