Warehouse Management

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

Warehouse Management

Warehouse functional overview

The warehouse functionality in IMS has the following capabilities.

 

Stock management

Purchase Orders, material ordering process

Material Templates

Fast moving material management, e.g. cables, etc.

Full relation of warehouse assets and network assets, should both processes be managed

from within IMS

 

The IMS warehouse functionality is designed with a certain flow in mind as displayed in the below flow

diagram, which is good to keep as reference for the remainder of this chapter

 

clip0456

 

Warehouse functionality

 

Accessing the Warehouse forms

The warehouse forms are in IMS under the Warehouse button on left-hand button bar.

clip0457

The menu bar above the warehouse forms contains the following buttons:

clip0328

From left to right:

All Stock items

displays all stock items irrespective of the stock selected

Stockitems history

menu bar to perform actions on stock items

Stock Item Action

a separate menu bar to perform actions on stock items

Reserve Materials

a form to reserve stock items (see chapter 3.5)

Book in/out Cables

a form for actions on cables (see chapter 3.13.1)

New Material Ticket

a Material Ticket is created when preparing stock items for pick-up

Create Stock Rule

via Stock Rules the minimum and maximum stock levels are defined

Create New Purchase Order

Creating New PO’s for ordering material (see chapter 3.2)

Add material to stock

to manually add material to the stock (see chapter 3.4)

Create New Stock

to create a new stock location (see chapter 4.2)

Delete

to delete a stock location

Close Form

to close the form

 

 

Warehouse dashboard

On the Warehouse Stock form, it is possible to get an overview of the materials per stock.

 

IMS Warehouse menu button and click Stock in the list.

Use the top-left field to search and select the stock of which you want to have an overview of the materials

held within that stock.

 

clip0458

The following fields are shown on the StockLevels tab:

 

Field name

Explanation

MaterialType Name

Name of the material type

MaterialClass

Related class of the material type

Vendor Name

Vendor or manufacturer of the material

MaterialType Description

Description of the material

InStock

Amount of the material in stock

Reserved

Amount of reservations for the material

InOrder

Amount in order for the material

NotInStock

Negative stock for the material

VirtualInStock

Result of amount Instock minus Reserved plus InOrder

AvailableStock

Current available stock, e.g. Instock minus Reserved

OrderAdvise

Amount to be ordered for this material based on the configured rules (minimum and maximum stock values). Should the amount of VirtualInStock become less than the configured maximum stock, then the OrderAdvise will be the amount of maximum stock minus the amount of VirtualInStock

Ordering new material

1.There are two ways of adding material items to a stock. The first and advised way is by following

the ordering process by creating a new Purchase Order, as indicated in step 1 of the diagram of

chapter 2.

 

2.The second method is by directly adding material items to the stock, thus skipping the ordering and

delivery process steps, as indicated in step 2 of the diagram of chapter 2 (see also chapter 3.4)

 

The menu bar above the PO forms contain the following buttons:

clip0330

From left to right:

 

All Purchase Orders

overview of all existing PO’s

Commit Order List

to commit the order list of a PO after verification

Add Logging

to add a log text for the PO

Add Material to PO

to add material to the order list of a PO

Add Invoice

to add Invoice information to the PO

Create New Purchase Order

create a new PO

Delete

to delete a PO

Close Form

to close the form

 

 

Purchase Order

Ad 1.        A purchase order must be created to order new material. It allows for tracking the ordering and

delivery process and can be used to control the budget.

 

Step 1: Create a new PO

Warehouse menu button and click Purchase Orders in the list.

 

On the Purchase Order form click the button “New PO” to create a new purchase order for ordering new material

clip0459

The New PO form contains the following fields:

 

Field name

Explanation

Requirements

InNumber

Select the IN (investement number) from the list or create a new one (explained below in chapter 3.2.2)

Mandatory

Name

Name or number of the PO

Mandatory and unique

Order

Related order number

Optional, but advised

Budget

Budget amount for the PO

Required if prices are used for proper calculation

Requestor

Name of the requestor

Mandatory

Stock

Related stock

Mandatory

Customer

Related customer if the PO is for 1 specific customer

Optional

Vendor

Related vendor if the PO is related to 1 vendor

Optional

Description

Additional details

Optional

Open PurchaseOrder on Save

Checkbox to control automatic opening of the new PO on save

 

Close?

Checkbox to control the closing of the form on save

 

Save button

Button to create the new PO and save it in the IMS warehouse database

 

 

Step 2: Add material for ordering to the new PO

1.With the new PO created navigate to the Add tab on the Purchase Order form. The Add tab list all

    the available material types for ordering.

2.Select one or more material types from the list and click the “Add material to PO” button.

3.On the pop-up window fill in the quantity of the material you want to order and click the save button

    to add the material(s) to the PO.

 

clip0460

Step 3: Review and commit order list

Once all the materials have been added to the PO you can navigate to the Order list tab to review the list of

materials. You can adjust the amount of materials or remove materials from the list.

 

Click the “Commit order list” button when the order list is complete.

This will create the material items in the database which allows them to be reserved even before they have

been delivered.

 

clip0461

IN Number

An investment number (IN) must be created to allow for budget allocation to a PO for ordering material.

An IN is usually created for a whole project or order to control the complete budget and PO’s related.

Multiple PO’s can be related to one IN.

 

Warehouse menu button and click IN Number in the list.

 

The menu bar for IN Number registration contains the following buttons:

clip0334

From left to right:

 

All InNumber

overview of all existing IN numbers

Create New InNumber

create a new IN

Close Form

close the form

 

 

clip0462

The New InNumber form contains the following fields:

 

Field name

Explanation

Requirements

Name

Name or number of the IN

Mandatory and unique

Amount

Budget amount for the IN

Mandatory, but can be 0 is material prices are not used

Currency

Select the appropriate currency used

Mandatory

Customer

Related customer if the IN is for 1 specific customer

Optional

Order

Related order if the IN is for 1 specific order

Optional

ProjectLeader

Name of the project leader

Optional

Remarks

Additional details

Optional

Open InNumber on Save

Checkbox to control automatic opening of the new IN on save

 

Close?

Checkbox to control the closing of the form on save

 

Save button

Button to create the new IN and save it in the IMS warehouse database

 

 

 

Delivery of new material

As indicated in step 2 of the diagram in chapter 2, material items will be delivered after they have been ordered.

This can be done on the Stock form by clicking the “Stock item Action” button.

This opens the stock item action window which allows you to perform actions on the various material items

related to the current stock. For delivery of material items, the “Book In” option is used.

 

1.On the stock item action window select the option “Book In” to list the material items

which can be booked

into the current stock. The list contains material items with the status ordered, out stock, not in stock,

defect and returned to supplier.

 

2.Use the filter row function on the grid to search for the material items which have been delivered,

for example the purchase order or material name.

 

3.Material items for which the serial number is required will have to be updated with the actual serial

number first, this can be done by using the following steps.

 

-Locate the material item in the list and double-click in the SerialNumber field and fill in the

serial number of the material item and press the “V” at the left most side of the row to accept

the change.

 

4.Select the material items that have been delivered and click the update button to update

    the status of these material items to “in stock”.

clip0463

Add material to stock

 

Ad 2.        As mentioned in chapter 3.2, the second method is by directly adding material items to the stock,

thus skipping the ordering and delivery process steps, as indicated in step 2 of the diagram of

chapter 2.

 

1.

This can be done on the Stock form by navigating to the Add tab, this list all the available material types that are deliverable

2.

Select one or more material types from the list and click the “Add material to stock” button

3.

Fill in the required quantity and the order number and click the save button to add the material item(s) irectly to the stock with the status “In Stock”

 

 

clip0464

 

Reserve material

The next step in the process flow of the material items is to reserve materials as shown in the diagram of

chapter 2 at step 3. Material reservations can be made regardless of whether they are in stock,

in order or not in stock at all.

 

The following priority is used in selecting material items for reservation.

1.In stock

2.In order

3.Out stock (negative stock)

 

Reservations are made based on the material type name and not so much the actual material item in the

database. This is useful when for example reservations are made on high volume material items, like SFP’s,

that contain a serial number. The serial number is assigned at a later step in the process.

 

On the stock form click the button “Reserve Materials” to create a new material reservation.

 

clip0465

The reserve material form contains the following fields:

 

Field name

Explanation

Requirements

Name

Name of the material reservation for later reference

Optional

Stock

The stock containing the materials

Mandatory

Material Type

Name of the material type

Mandatory

Order

Order number

Mandatory

Quantity

The amount of material items

Mandatory

Planned Date

 

Optional

Username

 

Optional

Comments

 

Optional

Close?

Checkbox to control the closing of the form on save

 

Save button

Button to create the new material reservation and save it in the IMS warehouse database

 

 

 

Material to layout

This step in the process is to set (reserved) material items to layout, which means that they are ready to

be picked up for installation. This is shown in the diagram of chapter 2 at step 4.

 

For high volume material items containing serial numbers, like SFP’s, it is advised to skip the layout step

and to directly book out these material items as explained in the next chapter.

 

4.On the stock form click the button “Stock item action” to open the stock item action window and

    select the “To layout” option. This lists only material items ‘in stock’.

 

5.Two additional fields appear:

a.Material ticket name

b.Reserved material

 

6.These fields allow the list of material items to be limited to a certain material reservation and/or

    a specific reserved material type.

 

7.Select the required material items from the list and click the update button to update the status

    of the material item(s) to layout.

clip0339

 

Book out material

When material items have been taken from the stock, either through the reservation/layout steps or

directly from stock, the status must be updated to “out stock” by booking out the material item(s).

This is shown in step 5 of the diagram in chapter 2.

 

1.On the stock form click the button “Stock item action” to open the stock item action window and

select the “book out” option. This will list all material items with the status “in stock” and “lay out”.

 

2.Select the material item(s) from the list and select the “update” button to change the status to

“out stock”.

clip0340

 

Defect material

Material items returned to stock can be set on status “Defect” if they are defect or malfunctioning.

This allows the material items to be send to a vendor for repair or can be removed from stock should this

be desired. (if the IMS inventory is also related, cards can be set to defect already in the inventory node screen)

 

1.Changing the status of a material item to “Defect” can be done on the stock form by navigating to the

ItemsInStock tab. This tab lists all the individual material items related to the current selected stock.

 

2.Locate the material item in the list and double-click the StatusId field and change the status to

“Defect” and press the “V” at the left most side of the row to accept the change.

clip0341

 

Repair material

Material items with the status “Defect” can be sent to a vendor for repair. This updates the status of the

material item(s) to “returned to supplier”.

 

1.On the stock form click the button “Stock item action” to open the stock item action window and

select the “To Repair” option to list all the material items with the status “Defect”.

 

2.Select the material item(s) in the list and the vendor on the additional field that has appeared when

selecting the “To Repair” option at the top of the window and press the “update” button to change

the status of the material item(s) to “returned to supplier”.

 

When the material items have been repaired and received back from the supplier then the material items

can be booked back in stock by following the steps explained in chapter 3.3.

clip0342

 

Move to stock

Material items with the status “In Stock” or “Out Stock” can be moved to another stock or from the inventory

back to the stock. This updates the status of the material item(s) to “in transfer” in case the stock is moved

from one stock to another and to “to be returned” if the item is moved from the inventory (out stock) back to

a stock.

 

1.On the stock form click the button “Stock item action” to open the stock item action window and

select the “Move to Stock” option to list all the material items with the status “In Stock” or “Out Stock”.

 

2.Select the material item(s) in the list and the stock and order in the additional fields that  appeared

when selecting the “Move to Stock” option at the top of the window and press the “update” button

to change the status of the material item(s) to “in transfer” or “to be returned”.

 

The items in status “to be returned” and “in transfer” can be booked into the stock by following the steps

explained in chapter 3.3

clip0343

 

Move to site

Material items with the status “In Stock” or “Out Stock” can be moved to a site. This updates the status

of the material item(s) to “in transfer”.

 

1.On the stock form click the button “Stock item action” to open the stock item action window

and select the “Move to Site” option to list all the material items with the status “In Stock” or “Out Stock”.

 

2.Select the material item(s) in the list and the site and order in the additional fields that  appeared

when selecting the “Move to Site” option at the top of the window and press the “update” button

to change the status of the material item(s) to “in transfer”.

 

The items in status “in transfer” can be booked out the stock by following the steps explained in chapter 3.7.

clip0344

Material ready for sale

Material items can leave the stock by assigning to a bin, for example to sell them to a third party or to dispose

of them. This can be done by registering the appropriate bin and assigning the material items to the bin.

 

Step 1: Create a new material bin

Warehouse menu button and select Material Bin from the list. This opens the MaterialBin form.

 

Click the “New” button to create a new material bin.

clip0466

The new MaterialBin form contains the following fields:

 

Field name

Explanation

Requirements

Name

Name of the material bin

Mandatory and unique

Bin Type

Type of the bin, for example sale or waste

Mandatory

Stock

Stock the bin is related to

Mandatory

Comments

 

 

Sold

Yes or No, indicating if the bin is sold and the associated material items have left the stock

 

Open MaterialBin on Save

Checkbox to control automatic opening of the new material type on save

 

Close?

Checkbox to control the closing of the form on save

 

Save button

Button to create the new material bin and save it in the IMS warehouse database

 

 

 

Step 2: Assign material items to a bin

On the stock form click the button “Stock item action” to open the stock item action window and

select the “Ready for Sale” option. This will list material items with the status in stock.

 

Select the material item(s) from the list and select the appropriate bin in the additional field that appeared

when selecting the option “Ready for Sale” and select the “update” button.

 

clip0346

 

Cables

 

The management of cables is different in the IMS warehouse module, due to the nature of cables and the

way of ordering/delivering cables.

clip0467

Cables are not included in the stock level form, but in a separate tab: ‘Cables in Stock’

 

To book in or book out cables use the button on the warehouse menu bar ‘Book in/out Cables’ and select ‘IN’ or ‘OUT’

clip0468

The action type field and the stock field are already filled-in, but these can be modified if necessary.

 

Fill in:

Cable type                -        the type of cable, defining if ordered by qty or length

clip0349

The available quantity in stock is displayed for your convenience

 

Fill in:

Quantity

number of pieces or meters/rolls (mandatory)

Order

the order number (optional)

Purchase Order

the PO number (optional)

Employee

employee name (optional)

DateMark

timestamp (optional)

 

Warehouse administration

Register Material Types

Warehouse holds a separate library of equipment types and as such material types must be defined.

Material types can be setup independent of the inventory types depending on how the warehouse

functionality is intended to be used.

 

Access the Warehouse Material Types form

Warehouse menu button and click Material Type in the list.

clip0469

Create new material type

On the Material Type form click the button “Create new MaterialType” to open the form to create a new material type.

clip0470

The Details tab of the form contains the following fields:

 

Field name

Explanation

Requirements

Name

Name of the material type

Mandatory and unique

MaterialClass

Can be used the categorise materials into classes

Optional

Vendor

Vendor or manufacturer of the material

Mandatory

VendorCode

Code of the vendor

Optional

Version

Version of the material

Optional

Price

Material price to purchase

Mandatory, but can be 0 should finances be managed outside of IMS

Currency

Related currency of the material price

Mandatory

DepreciationDays

Period of depreciation in number of days

Optional

Description

Additional details of the material type

Mandatory

SerialNumberRequired

Define if the material type has a serial number which should be registered upon delivery. Not advisable for fast moving and/or high-volume materials

Mandatory

Supplier

Supplier of the material

Optional

Deliverable

Field to indicate if the material is deliverable yes/no

Mandatory

MinQuantity

Mininum quantity in stock

Optional

EndOfSale

End of sale date

Optional

EndOfService

End of service date

Optional

DefaultMaintenanceCycle

Period after which maintenance should be performed in days

Optional

ReplacedBy

Field to indicate a replacement should material not be deliverable anymore

Optional

Open MaterialType on Save

Checkbox to control automatic opening of the new material type on save

 

Close?

Checkbox to control the closing of the form on save

 

Save button

Button to create the new material type and save it in the IMS warehouse database

 

 

 

Should the material be related to an object in the IMS inventory, then the tab Inventory Item can be used,

which contains the following fields:

 

clip0471

 

Field name

Explanation

Requirements

Card definition

Relate material type to a card type

Optional

Card code definition

Relate material type to a card code type

Optional

Equipment definition

Relate material type to a node type

Optional

Shelf definition

Relate material type to a shelf type

Optional

Rack definition

Relate material type to a rack type

Optional

Ddf odf definition

Relate material type to a DDF or ODF type

Optional

Product

Additionally, relate material type to a product code

Optional

 

 

 

Create new material template

In IMS Warehouse it is possible to create material templates, these are used to order items that belong to a

certain configuration and should be ordered as a package, f.i. a switch that always has a certain card and

certain SFP’s or a BTS that has a huge list of material items varying from antenna pole’s to generators and

batteries etc.

By creating a material template, all items in such a configuration (or package) can be ordered at once

just by creating the list one time.

 

Access the Warehouse Material Types form

Warehouse menu button and click Material Template in the list.

On the Material Type form click the button “Create new MaterialTemplate” to open the form to create a

new material template.

 

clip0353

The form contains the following fields:

 

Field name

Explanation

Requirements

Name

Name of the template

Mandatory and unique

Description

Description of the template

Optional

Total Costs

The total price of all items in the template

Optional

OpenMaterialTemplate on Save

Checkbox to open the new template after it’s been created

Yes/No

Close?

Close the create screen after the template is created

Yes/No

Save

Save button to save the template

 

 

 

After creating the template, the materials can be added to the template by clicking on the

“Add new material” button, or by adding te materials that are already defined in another template by

clicking the button: “Add materials from template” in which case a list of existing templates is displayed.

clip0354

The form contains the following fields:

 

Field name

Explanation

Requirements

MaterialTemplate

Name of the template

Non editable

MaterialType

A list of materials per vendor

Mandatory

Quantity

The number of pieces odf the selected material

Mandatory

Version

To specify a specific version of the material

Optional

Close?

Close the create screen after the material is added

Yes/No

Save

Save button to save the material to the template

 

 

 

Create new Warehouse Stock Location

Locations containing one or more material items are called stocks in IMS Warehouse.

One or more of these stocks must be created to manage the ordering, delivery,

reservation and lay out process steps.

 

Creating a new stock can be done in IMS by going to the Warehouse button and click Stock in the list.

In the stock form click the New button to create a new stock.

clip0472

Explanation of the fields:

 

Field name

Explanation

Requirements

Site

Site (location) in IMS which is used as stock

Mandatory

Name

Name if the stock

Mandatory

StockType

Field to indicate the type of stock

Mandatory

Description

Description of the stock

Optional

 

 

 

Open Stock on Save

Checkbox to control automatic opening of the new stock on save

 

Close?

Checkbox to control the closing of the form on save

 

Save button

Button to create the new stock and save it in the IMS warehouse database