Warehouse mapping lets you specify the warehouse from which an item contained in a bill of materials or a set is issued.
You will use it in two situations:
1) When producing goods using a bill of materials (when the product is received into stock, the relevant material is issued from the warehouse specified in the warehouse mapping)
2) When selling a set (the corresponding set components are issued from the warehouse specified in the warehouse mapping)
If you prefer video tutorials, you can watch the video. However, the video tutorial is available only for the desktop application. The principles are the same in both versions.
How do I set up warehouse mapping correctly?
You can find warehouse mapping in Settings under Records, in the Goods and Warehouses group, in the Warehouse Mapping record, or by searching for the keywords Warehouse Mapping.
It is worth repeating that warehouse mapping is used to determine the warehouse for the relevant items. The relevant items are the items of a bill of materials (material) or the items of sets (components).
After opening the module, click the New button in the top right corner, and a form for a new warehouse mapping record will open.
The mapping defines where the items (material) of the bill of materials or the items (components) of the set are located. The form has four fields:
Warehouse
The warehouse where the items are located, according to the conditions entered below.
Price list
If the mapping applies to only one specific item, enter that item here. If it applies to a group of items (rather than just one item), leave this field empty.
Goods group
Enter the goods group to which the warehouse mapping you are creating applies. The mapping will be applied to all goods that belong to the group.
Cost center
If your company is divided into cost centers, specify here which cost center this mapping is valid for. An empty field means the mapping is valid for all cost centers.
Now we will show two usage examples: one for a bill of materials and one for sets and kits.
Bill of materials
Let's say we have set up the bill of materials for a product in the following way. Setting up a bill of materials and production in the web interface is described in the article Bill of Materials in the Web Interface.
The product is a FRONT WHEEL and consists of the following materials:
RIM (1 pc); HUB (1 pc); SPOKES (32 pcs)
All materials belong to the goods group MATERIAL and are stored in the PLZEŇ warehouse, which is different from the warehouse where the product will be received. With a bill of materials, mapping makes sense mainly when the material is located in a different warehouse than the one where the product will be received.
We will therefore set up the warehouse mapping as follows.
Goods in the Material group are located in the PLZEŇ warehouse. The company is not divided into cost centers, so we leave the cost center field empty.
The warehouse mapping is now ready, and provided we have enough material in stock, we can proceed to production.
We will create a goods receipt with the item FRONT WHEEL and the movement type specified as Product receipt (this is the key piece of information for Flexi in production). You can find more information about stock document types for production in the guide to the bill of materials.
When you save the goods receipt, and provided the document type is set up correctly, a material issue note is created from the warehouse specified in the warehouse mapping, in our case the PLZEŇ warehouse (the warehouse is shown on the individual items of the issue note).
Sets and kits
Let's say we have a set called Camera set configured in the following way. You can find more information about setting up sets and kits here.
The first item, NIKON, belongs to the goods group CAMERAS and is located in the PLZEŇ warehouse.
The second item, SD, belongs to the goods group SD CARDS and is located in the LIBEREC warehouse.
Warehouse mapping will therefore need to be set up separately for each item. We will create two records as follows.
With this setup, we can proceed to selling the set by creating an issued invoice. In the price list, the set is a stock item, so we specify a warehouse on the invoice item (PLZEŇ in the example). The set components are nevertheless issued from the warehouses according to the mapping.
Provided the invoice type is set to create a stock document automatically, issue notes are created from two warehouses. You can also see the issue notes as Receipts/Issues labels in the invoice header.
Mapping sets and kits on a credit note
Invoices and credit notes create stock documents differently. When invoicing, the set is first broken down into its components, and a separate issue note is created for each warehouse to which any component belongs according to the mapping.
A credit note does not break the set down again, but takes over the items from the original issue notes. The target receipt note is determined by the warehouse specified on the credit note item, which is a single value for the whole set, so only one receipt note is always created. Warehouse mapping does not come into play at this step, so changing the cost center or editing the mapping does not affect the number of receipt notes.












