Coil Finder

Modified on Thu, 22 Jul 2021 08:40 by J Denniston — Categorized as: Item Control

Table of Contents [Hide/Show]

   General Information
   Filters Tab
      Filters/Fields
   Results

General Information¶

Default Menu Location Transaction >> Item Control >> Coil Finder

Screen Name FINDCOIL

FunctionThe Coil Finder allows you to search current and past coil inventory using all data fields related to a coil.

Filters Tab¶

The Filters Tab provides multiple fields to search by to find coils location and status

The scroll box on the bottom left allows the user to narrow which warehouses to search in

When relevant fields are filled in press the Find button and it will jump to the Results tab with the matching coil lines

Filters/Fields¶

The following is a list of fields used to locate inventories:

Coil #: Coil number

Item: Item Code

Description: Item Description

PO#: Purchase Order number

Mill Coil#: Mill coil number

Mill Name: The name of mill

Processor Name: The name of processor

Proc Coil#: The processor's coil number

Heat#: The coil's heat number

Country of Origin: The coil's country of origin, set on the PO receipt screen.

Orig Coil#: Original coil number (if coil was processed)

Show On Hand = 0 Displays coils with a current on hand quantity of zero

Show On Hand < 0 Displays coils with a current on hand quantity less than zero

On-Hand: On hand quantity only

WIP: Work In Progress only

Shipped: Shipped coils only

All: Include all of the above

Results ¶

Sort By: Option to arrange columns on the "Coil Finder - Results" tab

History: After selecting a "coil#" from the "Coil Finder - Results" tab, click on the "History" button. A window, "Item:COIL/ Coil", pops up to display detail information about the selected "coil#".

Last Used: This column indicates the last time a coil was shipped out on a sales order or used in production (assigned to a PWO).

Coil Finder- Results Screen