Multi-Warehouse Flow Capability

(*) – Product Type defined for item in warehouse location

Note: Within Dynamic 3i applications product types 1, 2, 5 are all treated the same this follows for product types 3 & 4 as well

Dynamic3i Multi-Warehouses and Manufacturing

Product in Dynamic3i is set up only once on the product file (IN0100). In a multi-warehouse environment the product can then be defined in many warehouses.

This is done in the Stock Master Maintenance - IN0200 for each location/warehouse that the product is required. The warehouse assignment allows product to have different attributes based upon its location. For example, the item may have a different supplier and cost based upon its geographical location such as an east coast warehouse as apposed to a west coast warehouse.

It is by way of the product type and supply attribute in each warehouse location that gives the Dynamic 3i’s Manufacturing process the ability to automatically place demand into another warehouse location.

On the Stock Master Maintenance there is a Vendor and Supplying Warehouse selection. Only one of these can be entered for any given item and in the case of a finished good it is not required.

In Dynamic3i Product types ‘1-Assembly’, ‘2-Manufactured Item’ and ‘5-Finished Good’ are all Manufactured Items. Types 1 and 2 being special in that they can be used as a component in another Bill Of Material (BOM).

Product Types 3-Raw Material and 4-Purchased Item are the items that make up the Bill of Material for the other product types. These items are attained form somewhere. Either and external source such as a vendor or another internal source such as a warehouse location

Multi-Warehouses and Manufacturing - The Set-up

When defining product to a warehouse the selection of either the vendor or the supplying warehouse can be thought of as:

Where do I get this product?

Do I manufacture/build it?
Do I purchase it from an outside supplier (ie. vendor)?
Do I get the item from somewhere else in the company?

If it is a product type 1, 2 or 5 then I must manufacture it in the warehouse defined so a vendor and/or supplying warehouse is not required.

If it is a product type 3 or 4 than I MUST get it from somewhere. If it is a vendor then you enter the vendor number or if you get it from somewhere else in the company then you would enter the supplying warehouse. As a rule if the item is not manufactured in the warehouse it is being set up in then it would be set up as a type 4-purchased item, as the item is supplied from somewhere else.

Referring to the above diagram

Each location BLN, PUR, SUP, QF and STR are defined with stock. The BLN and SUP locations are manufacturing sites. The PUR location is where all items that are purchased from a vendor are located. The QF is a quality control warehouse to act as a holding/testing location for all items manufactured and sold externally and finally the STR is the central distribution warehouse where ALL orders would be received and processed for customers.

Lets analyze the attributes of the product defined in each location:

For the example we make and sell a bottle of some liquid – WO-750.

Location STR being the central warehouse distribution point for our product, we would receive ALL external orders from customers for our product here. This being the case our bottle of liquid (WO-750) is defined via the stock master to warehouse location STR.

Asking the questions mentioned above as to where I get this item dictates the product type and where I would get the item to supply the demand of any given customer order.

As I have a process of quality control in my supply chain it can be seen that all items must flow through the QF warehouse. So in the STR warehouse I would get the WO-750 from the QF warehouse. This being the case the product type in STR for the item would be defined as a purchased item and be supplied by the QF warehouse instead of a vendor.

Product : WO-750

Warehouse : STR

Product Type : 4 – Purchased Item – (as it is not made in this warehouse)

Supplied by : Another warehouse – supplying warehouse set to QF

Likewise in the QF warehouse. As the item is requested from the STR warehouse the QF warehouse must supply it so it must also be defined in this warehouse location as well. The QF warehouse is acting exactly like a vendor. Again, asking the same questions mentioned above and referring to the diagram it can be seen that the WO-750 is supplied by the SUP warehouse. This being the case the product type for the item in this location would also be a purchased item (as I get it from somewhere else) and the supply warehouse be set to SUP.

Product : WO-750

Warehouse : QF

Product Type : 4 – Purchased Item – (as it is not made in this warehouse)

Supplied by : Another warehouse – supplying warehouse set to SUP

In following with the diagram and moving right to left in the supply chain we are defining the WO-750 which is defined in the SUP warehouse is actually manufactured there as this is one of the two manufacturing sites. It is in this warehouse location that the WO-750 is actually manufactured. In the SUP warehouse the WO-750 has a Bill Of Material (BOM) defined to it and since we do not get this from anywhere else it is set to a product type 5-Finished Good.

Product : WO-750

Warehouse : SUP

Product Type : 5 – Finished Good – (as it is made in this warehouse)

Supplied by or Vendor not required.

All of the items that go into the Bill of Material for WO-750 in warehouse SUP are purchased items however it was stated above that ALL purchases are done in the purchasing warehouse PUR. This means that these items are first purchased from an external vendor and received into the PUR warehouse. In the SUP warehouse as they are attained from somewhere else they are set to product type 4-Purchased Item with the supply warehouse set to PUR.

Product : Bott-750, Cap-750, Case-750, Label-750

Warehouse : SUP