Skip to content

IM0201 Inventory Management Location Control File Maintenance

Location Control File Maintenance

Application Overview 

Elliotts's Inventory Management package allows you to keep track of inventory, which is stocked at more than one location, including the quantity of the item on‑hand, allocated and on‑order at each location.

 When you first enter a new inventory item, part of the data entered is the quantity on‑hand, quantity allocated, quantity on‑order and other such data for the item's main stocking location.  The Location Control File allows you to define additional stocking locations for the inventory item.  There are two ways to enter this information.  The first is via the add mode and the second is to create a range of inventory items at a location via the create mode.  Please note that the locations must be entered in the Location File Maintenance application on the I/M Maintenance window.  The create mode will take the beginning and ending items specified and create records at the new location.  The new location's items will have quantities of zero and blank picking sequence and cycle count code fields.  You will need to access them via change mode and edit these fields to match the availability at that location.

 

Run Instructions

 Select Location Control File from the pull down I/M Maintenance window.  The following screen will then be displayed:

 

 

Location Control File Entry Screen

 

The following options are available:
    • Select the desired mode from the Location Control File menu bar
    • Enter the data requested on the screen

     To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.

     

    Entry Field Descriptions

     

    Name

    Type and Description

    1.      Item No

    15 alphanumeric characters.

    Enter the number you want to have represent the item.  This number can contain alphanumeric characters as well as purely numeric digits.  You may also press F7 or F8 to use the Search option.

    Location

    2 alphanumeric characters.

    Enter the Location code for the item entered.   

    Press the F7 key to search for location.

    2.      Quantity On‑Hand

    A standard quantity format with optional minus sign.

    Enter the current quantity on‑hand of the item at the above location.

    3.      Quantity Allocated

    A standard quantity format with optional minus sign.

    Enter the quantity of the item, which has been allocated.

    4.      Quantity Backordered

    A standard quantity format with optional minus sign.

    Enter the quantity of the item, which has been backordered.

    5.      Quantity On‑Order

    A standard quantity format with optional minus sign.

    Enter the quantity of the item that is on order.

    6.      Reorder Level

    A standard quantity format.

    Enter the quantity on‑hand of this item, which will determine when to order more of it.

    7.      Order Up To Level

    A standard quantity format.

    Enter the amount of this item (the level) up to which your order amount should take you when added to the quantity on‑hand.  For instance, if your order‑up‑to‑level is 100 and you have 20 on hand, you would need to order 80 to meet this order‑up‑to level.

    8.      Bin No/Pick Seq

    8 alphanumeric characters.

    Enter the bin number where this item can be found.

    9.      Cycle Count Code

    1 alphanumeric character.

    Enter the Cycle Count code for the item.  For a full explanation of this entry, refer to the  for Item File Maintenance.

    10.    Date Last Counted

    A standard date format.

    Enter the date when the item was last counted.

    11.    Date Last Sold

    A standard date format.

    Enter the date when the item was last sold.  Defaults to system date.

    12.    Qty Last Sold

    A standard quantity accumulator format with an optional minus sign.

    Enter the quantity of the item sold in last sale.

     

    Location Control List

     

    Name

    Type and Description

    Starting Item

    15 alphanumeric characters.

    Enter the starting item number for the range of items to be printed.  Press the F7 key for item search by number or the F8 key for item search by description.  Defaults to All.

    Ending Item

    15 alphanumeric characters.

    Enter the ending item number for the above range.  Press the F7 key for item search by number or the F8 key for item search by description.  Defaults to the starting number.

     

    Starting Location

    2 alphanumeric characters.

    Enter the starting location for the range of locations within the above item range to be printed.  Press the F7 key to search for location codes.  Defaults to All.

    Ending Location

    2 alphanumeric characters.

    Enter the ending location for the above range.  Press the F7 key to search for location codes.  Defaults to the starting location.

     


    Create/Delete Inventory Locations

     

    Name

    Type and Description

    Create Or Delete Locations

    1 alphanumeric character.

    Enter C for Create new items at a location or D for deleting these items at a location.

    Starting Item

    15 alphanumeric characters.

    Enter the starting item number for the range of items to have locations created or deleted.

    Press the F7 key to search by item number.  Press the F8 key to search by item description.

    Ending Item

    15 alphanumeric characters.

    Enter the ending item number for the above range.

    Press the F7 key to search by item number.  Press the F8 key to search by item description.

    Location

    2 alphanumeric characters.

    Enter the location for the above item range.

    Press the F7 key to search for location codes.


     

     

     

    Date filled out ______by _______    ADD     CHANGE      DELETE

                   INVENTORY LOCATION CONTROL FILE LOAD SHEET

          1)   Item Number              _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

                Location                 _ _

          2)   Quantity On-Hand         _ _ _, _ _ _, _ _ _. _ _ _

          3)   Quantity Allocated       _ _ _, _ _ _, _ _ _. _ _ _

          4)   Quantity Backordered     _ _ _, _ _ _, _ _ _. _ _ _

          5)   Quantity On-Order        _ _ _, _ _ _, _ _ _. _ _ _

          6)   Reorder Level            _ _ _, _ _ _, _ _ _. _ _ _

          7)   Order Up To Level        _ _ _, _ _ _, _ _ _. _ _ _

          8)   Picking Sequence         _ _ _ _ _ _ _ _

          9)   Cycle Count Code         _

          10)  Date Last Counted        _ _/ _ _/ _ _  

         11)  Date Last Sold           _ _/ _ _/ _ _

          12)  Quantity Last Sold       _ _ _, _ _ _, _ _ _. _ _ _

     

     

      

     

    Screens

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    ScreensREPORTS

     

     

     

     

    Feedback and Knowledge Base