Inventory Management IM0201 Help - Elliott Business Software

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