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. Surplus is any available stock quantity over EOQ point, i.e. (available – line point – EOQ).

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, click Inventory Control>Reports & Prints >Surplus Status Report.

Click Field Descriptions for information on each field.

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