Skip to content

IM0000 Inventory Management Package Overview 4

Startup

 

Setup Procedure

 In order to begin using the Inventory Management system, the following steps must be completed after Company Setup and the Inventory Files have been initialized through the File Utilities application.  For extensive descriptions for each of the following applications, please refer to the specific chapters in the rest of this manual.

 The applications section in this manual may be used to obtain specific information on each application.  The file load sheets contained in each of these sections may assist in accumulating and loading data.

1. The I/M control data must be entered through the I/M Setup application in the Util_setup pull down window.

2. Enter valid inventory locations using Location File Maintenance application.

3. Enter valid product categories using Product Category File Maintenance application.   

4. Enter valid material cost types using Material Cost Type File Maintenance application.

5. Enter valid material cost type/location accounts using Material Cost Type/Loc File Maintenance application.

6. Enter valid buyer/analyst codes using Buyer/Analyst Code File Maintenance application.

7. Enter the valid accounts using I/M Account File Maintenance application.

8. Enter the valid I/M items using Item File Maintenance application.

9. If you have inventory at more than one location you will need to enter this inventory via the Location Control File.

10.  Enter the valid Kit Items with their designated components in Kit File Maintenance application.

11.  Run the Freeze Inventory application to take a snapshot of beginning inventory quantities, costs and value of inventory.

12.  Run Frozen Stock Status Report to generate totals to be posted to G/L for the value of beginning inventory.

13.  If you are using LIFO or FIFO cost method, initialize the layer file using Initialize LIFO/FIFO File application or enter zero quantity on hand when loading inventory items and enter actual layers through receipts in the Inventory Transaction Processing application.

The above steps will load the system with the necessary information to process the past open item and future open item transactions.


ALLOCATING QUANTITIES

 Item quantity amounts are stored in four (4) fields on the Inventory Management Item File and Inventory Location File: quantity on-hand, quantity allocated, quantity on-order, and quantity back-ordered.  The term "quantity allocated" refers to the portion of that item that is promised to (or "allocated" to) customer or shop orders.

Multiple programs throughout the Elliott system update the quantity allocated field.  Those programs will function differently depending on which Elliott modules are installed, and various flag settings in those packages.  The following pages provide examples of how allocations occur under certain settings.


ALLOCATION EXAMPLES

 The table and examples shown below illustrate various combinations of Elliott modules and flag settings, which affect quantity allocations and on-hand amounts.  Use the table to find your corresponding flag settings, and then refer to that numbered example for a detailed description of the process.

 

 

 

 

Is

COP

in

use

 

 

 

Is

BOMP

in

use

 

 

 

Inc

WIP*

 

 

 

Is

SFC

in use

 

 

 

Is

MRP

in

use

 

Process Non-Stocked Parents in BOMP?

Auto- Issue at Count Point? (SFC)

Flags in Item File for Pur/Mfg, Stocked, and Controlled fields. Item numbers (A,B,C,D,E) correspond to items in example numbers shown at left.

 Ex #

 

 

 

 

 

 

 

A

B

C

D

E

1

Y

Y

N

N

N

N

N/A

MNY

PYY

PYY

MNY

PYY

2

Y

Y

Y

N

N

N

N/A

MYY

PYY

PYY

MNY

PYY

3

Y

Y

Y

N

N

N

N/A

MYY

PYY

PYY

MYY

PYY

4

Y

Y

N

N

N

N

N/A

MYY

PYY

PYY

MYY

PYY

5

Y

Y

N

N

N

N

N/A

MYY

PYY

PYY

MNY

PYY

6

Y

Y

N

N

N

Y

N/A

MYY

PYY

PYY

MNY

PYY

7

Y

Y

N

N

N

Y

N/A

MYY

PYY

PYY

MYY

PYY

8

Y

Y

Y

N

N

Y

N/A

MNY

PYY

PYY

MYY

PYY

9

Y

Y

Y

N

N

Y

N/A

MYY

PYY

PYY

MYY

PYY

10

Y

Y

N

N

N

Y

N/A

MNY

PYY

PYY

MYY

PYY

11

Y

Y

Y

N

N

Y

N/A

MYY

PYY

PYY

MNY

PYY

12

Y

Y

Y

N

N

Y

N/A

MNY

PYY

PYY

MNY

PYY

13

Y

Y

N

N

N

Y

N/A

MNY

PYY

PYY

MNY

PYY

14

Y

Y

N

Y

N

N

N

MNY

PYY

PYY

MYY

PYY

15

Y

Y

N

Y

N

N

Y

MNY

PYY

PYY

MYY

PYY

16

Y

Y

N

N

Y

Y

N/A

MYY

PYY

PYY

MYY

PYY

 

    *  "Increase WIP" flag in the BOMP "Print Production Orders" application

Feedback and Knowledge Base