Skip to main content

Warehouse Mapping

Documentation - Determining the Warehouse for Bill of Materials Items, Kits and Bundles

Written by Petr Pech

Items – Warehouse Mapping

Warehouse mapping allows you to define the warehouse location of an item included in a bill of materials or in a set and bundle.


In the case of a bill of materials, the form allows you to specify that the item's warehouse is different from the warehouse where the finished product is received. Use this feature, for example, during production — i.e., when receiving finished products into stock and issuing materials from the warehouse to production.


In the case of a set sale, the corresponding set components will be issued from the warehouse defined in the warehouse mapping.

Bill of materials example:

You are creating a goods receipt for a finished product at Warehouse A – Cost Center A. The materials are located at Warehouse B – Cost Center B, and one component (fasteners) is located at Warehouse C – Cost Center C.


In the warehouse mapping table, select Cost Center A (or all cost centers), all items (or a group, e.g., materials, or specific price list items), and select Warehouse B.
In the next warehouse mapping entry, select Cost Center A (or all cost centers), the specific price list item – fasteners, and Warehouse C.

Sets and bundles example:

Let's say we have a set called PHOTO, which consists of the price list items NIKON and SD CARD.
The first item, NIKON, belongs to the item group CAMERAS and is located at the PILSEN warehouse.
The second item, SD CARD, belongs to the item group SD CARDS and is located at the LIBEREC warehouse.

The warehouse mapping therefore needs to be configured so that the item group CAMERAS is pre-selected at the PILSEN warehouse and the item group SD CARDS is pre-selected at the LIBEREC warehouse.

Subsequently, when an invoice containing the PHOTO set is created, and provided that automatic stock document creation is enabled, a goods issue from two warehouses will be generated. The NIKON item will be issued from the PILSEN warehouse and the SD CARD item will be issued from the LIBEREC warehouse.

Main Panel

Clicking the button opens a form for a new record — essentially for configuring the path to the warehouse where the system should look for items belonging to the bill of materials being created or the set/bundle being issued.

Cost Center Selection

You can select all cost centers or specify a particular cost center. The finished product/bill of materials will be received into stock at this cost center.

for all cost centers

If you have only one cost center (e.g., C: Headquarters), select the first option – for all cost centers.

for selected

If your company is divided into cost centers, you can define in the warehouse mapping which cost centers the mapping should apply to.

Cost Center

Select the relevant cost center from the drop-down list; the field becomes available after checking the for selected option.

Item Selection

You can select all items, specify a particular item group, or select a specific price list item that is part of the given product/bill of materials. In the latter case, the warehouse mapping will contain as many entries as there are components in the product.

for all items

for item group

The most commonly used option is item group. For example, if you select the item group MATERIALS, the mapping will apply to all price list items included in that group. In practice, this means that whenever a product is received or a set is sold and the item in the bill of materials or set belongs to the MATERIALS group, it will be issued from the warehouse specified below.

Item Group

Select the relevant item group from the drop-down list.

for price list item

Price List

Use the magnifying glass icon on the right to select the price list item; the field becomes available after checking the for price list item option.

Pre-selected Warehouse

Select the warehouse where the price list items that make up the product or set are located. Items will subsequently always be issued from this warehouse.

Warehouse

Select the relevant warehouse from the drop-down list.

Related

Did this answer your question?