Storage location query

Topic overview

The storage location is the smallest logically possible organizational level within the warehouse organization. A storage location belongs to a warehouse and warehouse zone and is identified within it on the basis of a row, a level and a location. If more than one storage unit can be put away in a storage location, then a storage location is further structured into slots.

Every storage location must have a storage location type assigned. The storage location receives its properties with the assignment. These properties include, for instance, the storage location type, the priority and the maximum number of storage units allowed for the storage location.

This article describes how to query for storage locations of any warehouse zone according to their allocation, usage and storage location priority using the Storage location query application.

Instructions on how to use the Storage location query application, e.g., how to query storage locations, can be found in the article Procedures: Storage location query.

Definitions of terms

ABC storage
ABC storage classifies items by their turnover rate. If ABC storage is activated by specifying a storage location overrun rule, then items are put away in storage locations with an ABC classification that agrees with the ABC storage of the item.

Storage unit
Storage unit is a general term for the storage and packing materials used during storage, transport, and shipping of an item. Storage units are managed as items with material category Storage unit.

Warehouse organization
Warehouse organization determines the structure of a warehouse or warehouse zone. Using warehouse organization, warehouse structures such as simple warehouses, high rack storage areas, and bulk storage can be mapped.

Warehouse
A warehouse is a logically or physically defined area in which item inventory is maintained. A warehouse is always assigned to a site. A warehouse can be subdivided into storage locations if storage location control is enabled in Customizing. The exact structure of the warehouse is defined by the warehouse organization.

Storage location
A storage location is the exact point in a warehouse where items can be stored. A storage location within a warehouse always lies in a warehouse zone and is determined precisely on the basis of a row, a level, and a storage location number. Each storage location has a storage location category that establishes the use of the storage location. The availability of storage locations is essential for storage location control.

Storage location types
The storage location type is an important characteristic of a storage location. Attributes pertaining to a storage location type include, e.g., absorption capacity and presence of storage unit. The ABC classification and maximum permitted weight are also determined by the storage location type.

Warehouse zones
If storage location control is activated in the Customizing application, a warehouse can be subdivided into warehouse zones. A warehouse can have any number of warehouse zones.

Warehouse zone allocation
The warehouse zone allocation specifies the organizational allocation of a warehouse zone. Possible allocations are: receipt of goods, issue of goods, picking, reserve, and inventory count differences. When a warehouse zone is divided into storage locations, these storage locations must have a storage location type that agrees with the allocation of the warehouse zone. A warehouse zone without specified allocation can have both reserve locations and picking locations.

Application description

Using the Storage location query application, you can query storage locations for any warehouse zone according to the following criteria:

Each criterion corresponds to one view in the application. In all views, the application consists of a query pane and a work pane. The colors in the presentation of the query results are differentiated according to the view.

Note
Using the tooltip of a storage location, you can receive a summary of the most important information on the storage location. It includes the storage location category, the count of the storage units stored therein and a note on future receipts or issues
.

Display of the results

By allocation

In the By allocation view, the allocation of storage locations is presented according to the color scheme that reflects their filling status. The filling status of a storage location can have one of three values that are defined as follows:

  • Empty: the storage location does not have any item inventory.
  • Filled in part:
    • Storage location without storage unit: the current inventory of the storage location is lower than its capacity
    • Storage location with storage unit: not all its slots are utilied
  • Full:
    • Storage location without storage unit: the current inventory of the storage location is equal to or higher than its capacity
    • Storage location with storage unit: all slots are utilized
Note
The Full filling status is used also for inventory quantities that exceed the capacity of the storage location. It therefore does not differentiate between Full and Overfilled.
  • Blue – the storage location has open receipts or issues that will lead to a change of the filling status
  • Green – the storage location has the Empty filling status
  • Yellow – the storage location has the Partially filled filling status
  • Red – the storage location has the Full filling status
  • Dark green – the storage location has the Full filling status, but only empty storage units are stored.

If the storage location is not usable or if it is blocked by an inventory count, the number of the storage location is displayed with strikethrough.

The change of the filling status (blue color) always has the higher display priority.

Note
A planned issue from a partially filled storage location leads only then to a change of the filling status if the complete inventory should be withdrawn from the storage location. If only a partial quantity is to be withdrawn, the filling status is not changed. The case is similar with planned receipts. A picking location is usually displayed in blue only if completely empty or if it should be replenished to its maximum inventory level according to a replenishment order.

In the two examples below, the storage location is shown in blue:

  1. Two full storage units are put away in a storage location of the Storage location with storage unit category. For the storage location type, a maximum count of two storage units was defined. An inventory order for withdrawal of one of the two storage units has the Generated status. After reporting of the inventory order, the filling status will change from Full to Partially filled.
  2. A storage location of the Storage location without storage unit category does not have a current inventory. An inventory order for the put-away of 100 pieces has the Generated status. After reporting the inventory order, the filling status will change from Empty to Full if the storage location capacity amounts to 100 pieces.

In the example below, the storage location is shown in yellow:

50 kg of an item are put away in a storage location of the Fixed location without storage unit category. The capacity of the storage location is 150 kg. Even in the case of an open issue of 10 kg, the storage location is shown in yellow because the filling status (Partially filled) will not change as a result.

By storage location priority

In the By storage location priority view, the priority of the storage location is presented according to the following color scheme:

  • Orange – the storage location is usable and has the priority entered in the Storage location priority field.
  • Light orange – the storage location is usable, but it does not have the priority entered in the Storage location priority field.

If the storage location is not usable or if it is blocked by an inventory count, the number of the storage location is displayed with strikethrough.

By storage location category

In the By storage location category view, the storage location category of the storage locations is presented according to the following color scheme:

  • Orange – the storage location is usable and has the storage location category entered in the Category field.
  • Light orange – the storage location is usable, but it does not have the storage location category entered in the Category field.

If the storage location is not usable or if it is blocked by an inventory count, the number of the storage location is displayed with strikethrough.

By storage location type

In the By storage location type view, the storage location type of the storage locations is presented according to the following color scheme:

  • Orange – the storage location is usable and has the storage location type entered in the Type field.
  • Light orange – the storage location is usable, but it does not have the storage location type entered in the Type field.

If the storage location is not usable or if it is blocked by an inventory count, the number of the storage location is displayed with strikethrough.

Query pane

The query pane contains fields to determine the desired storage locations.
The field contents are described in detail below.

Warehouse – in this field, enter the identification of the warehouse where the desired storage locations are located. the warehouse organization must permit the allocation of the storage locations. First enter the available warehouses in the Warehouses application.

Warehouse zone – in this field, enter the identification of the warehouse zone where the desired storage locations are located. the warehouse organization of the warehouse zone must permit the allocation of the storage locations. First enter the available warehouse zones in the “Warehouses” application.

Row – in this field, you can limit your query to one or more rows.

Note
If there are no rows in the warehouse organization of the warehouse zone and you enter a value in this field, you will receive an error message. If you leave the field empty, the storage locations of all rows in the warehouse zone will be included in the query.

Level – in this field, you can limit your query to one or more levels.

Note
If there are no levels in the warehouse organization of the warehouse zone and you enter a value in this field, you will receive an error message. If you leave the field empty, the storage locations of all levels in the warehouse zone will be included in the query.

Storage location – in this field, you can limit your query to one or more storage locations.

Category – in case of a query for storage locations by storage location category, enter one or more storage location categories. In the work pane, all usable and not blocked storage locations of one of the entered storage location categories are highlighted with a color. The Category field is visible only in the By storage location category view.

Type – in case of a query for storage locations by storage location type, enter a storage location type here. In the work pane, all usable and not blocked storage locations of the entered storage location type are highlighted with a color. The Type field is visible only in the By storage location type view.

Work pane

The storage locations are grouped by rows and levels. Each row and level is presented as an individual line in the work pane. The storage locations are displayed in alphabetical order from left to right. If there are gaps in the storage location numbers, the storage locations appear on the monitor with corresponding intervals.

If there are no levels in the warehouse organization, the storage locations are displayed below the rows. If there are only storage locations in the warehouse organization, all storage locations of the warehouse zone are displayed in the same line.

The contents of the lines in the work pane are described in detail below.

Row – this line displays the identification of the row. each row of the warehouse zone is presented as an individual line. the lines are displayed in alphabetical order.

Note
This field is only visible if there are rows in the warehouse organization of the warehouse zone.

Level – this line displays the identification of the level. each level of the warehouse zone is presented as an individual line. the levels are displayed in alphabetical order.

Note
This field is only visible if there are levels in the warehouse organization of the warehouse zone.

Storage locations – each storage location is displayed as a square with the identification of the location displayed in its middle. the storage locations are displayed in alphabetical order. the query result is shown by the color of the storage location. the displayed colors depend on the view; see Display of the results.

Note
Using the tool tip, you can receive a summary of the most important information on the storage location. It includes the category of the storage location, the count of the storage units stored therein and a note on future receipts or issues.

Customizing

To make sure that the Storage location query application is visible, the Storage location control function must be activated in the Customizing application.

The operation of the Customizing application is described in detail in the Customizing article.

Business entities

The following business entity is relevant for the Storage location query application that you use, for example, in order to:

  • assign authorizations
  • set up activity definitions
  • import or export data.

Storage location: com.cisag.app.inventory.obj.StorageLocation

The business entity is part of the following business entity group: com.cisag.app.inventory.MasterData

Authorizations

Authorizations can be assigned by means of authorization roles as well as by assigning an organization. The authorization concept is described in the technical documentation Authorizations.

Special capabilities

There are no special capabilities for the Storage location query application.

Organization assignments

If the Content-based authorizations function is activated in the Customizing application, a person can only view the Storage location query application if an organization that is linked to at least one of the following structures has been assigned to him or her in the partner master data:

  • Inventory management

Special features

There are no special features for the Storage location query application.

Authorizations for business partners

The Storage location query application is not released for business partners.

Czy ten artykuł był pomocny?

Wyślij opnie