Inventory Management IM0201 Help - Elliott Business Software



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

 

 

                                        I N V E N T O R Y   L O C A T I O N   L I S T

 

Ranges: All Items

        All Locations

 

Item‑No          Description                   Loc  Qty On Hand  Qty On Order      Reorder  Pick‑Seq    Last   ‑‑‑‑‑‑Last‑Sale‑‑‑‑‑

                                                      Qty Alloc   Order Up To  Backordered Cycle‑Count Counted   Date         Qty

 

16SX‑1           Personal Computer 386SX        LA         .000          .000         .000            00/00/00 11/14/92       4.000

                 Kit No1                                  2.000          .000         .000

 

 

16SX‑2           Personal Computer 386SX        LA         .000          .000         .000            00/00/00 03/03/92       8.000

                 Kit No2                                   .000          .000         .000

 

 

16SX‑3           Personal Computer 386SX        LA         .000          .000         .000            00/00/00 04/01/92       6.000

                                                           .000          .000         .000

 

 

BOX‑386‑1        Basic SM Box w/7 Exp 6‑16 1‑8  LA      731.000          .000         .000            00/00/00 00/00/00        .000

                                                         20.000          .000         .000

 

 

BOX‑386‑2        Adv Box HDps 8 Exp 32 5‑16 2‑8 LA      421.000          .000         .000            00/00/00 00/00/00        .000

                                                          3.000          .000         .000

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ScreensREPORTS

 

 

 

 



Elliott Business Software
| Add-ons | Services
3rd Party Solutions | News & Events
Technical Support | Company Profile