Product documentation
In This Topic
    Dynamics Advanced Warehouse Management - Inbound and replenishment
    In This Topic

    Business value

    Replenishment is an activity that basically adds no value to the product. When searching the best balance between optimal purchase quantities or production quantities and picking efficiency, replenishment from bulk locations to pick locations is often a necessary evil.   

    Efficient replenishment is facilitated to great extent by smart receipt and storage of bulk inventory. Therefor, the inbound process should be aligned too. 

    In many warehouses, items arrive on pallets or bulk packages, but are sold by case or by piece. So in a high bay warehouse, there is a considerable flow of replenishment between bulk locations and picking locations. Often, the picking locations are fixed, and the bulk locations are flexible.

    Replenishment tends to be on the critical path in the warehouse:

    Therefore, it makes sense to store the bulk as close as possible to the fixed picking location. If bulk inventory is stored exactly above the fixed picking location, this saves a considerable amount of replenishment time and cost, because the reach truck does not have to move horizontally when replenishing from bulk location to pick location.

    Challenge in Microsoft Dynamics 365 for Finance and Operations location directives: several put away strategies are available to determine an optimal put location. Especially if there are many replenishment activities, the distance between the dynamic bulk and the fixed pick location should be minimal. Theoretically, this could be set up standard with an almost endless definition of location directives, zones etc. The impact on maintainability and performance would be huge!

    With Advanced Warehouse Management it is possible to store incoming goods on bulk locations in the same vertical location (same rack, same position) as the fixed picking location. Or as nearby the fixed picking location as possible.

    Thus, replenish from bulk to pick can be executed optimally because the fork lift or reach truck does not have to move horizontally. This saves a lot of time and labor cost, especially for products with a high cubic velocity that need to be picked in less than pallet quantity from ground level.

     

    Visibility of free locations, or locations that are already assigned as fixed location is added in Advanced Warehouse Management .

     

    To prepare for peaks in picking activity, replenishment can be run based on minimum stock level (normal or high minimum) to maximum as defined on the fixed location of an item.  

     

    Appointment scheduling

    Transportation management > Planning > Dock appointment scheduling > Appointment scheduling

    Improved user experience in the TMS appointment scheduling for faster arrival registration. The appointment scheduling screen can be used to register a planned appointment at the dock. This appointment can be related to an order. To enable fast entry of appointments, defaults can be set up in the parameters for:

    Note that the appointment rule in the filter is inserted in a new appointment.

    Setup Advanced warehousing parameters 

     

    Advanced Warehouse Management adds a data entity that allows the insert and update of a dock appointment for a

    E.g. mass create open (tentative) dock slots through Excel, and allow to book (firm) a slot through an external source (Power app, etc.).

     

    Free location near fixed location

    Warehouse management > Setup > Location directives

    Advanced Warehouse Management  adds a new and lean strategy that finds a suitable empty bulk location near the picking location, i.e. preferably in an upside down triangle shape above the picking location.

    The new strategy in the location directive action “Free location nearby fixed location” combines:

    Example:

    Consider the following situation (racks A1 and A3 in front view), where the fixed (picking) location is situated in rack 3 in the middle (Loc A1-02). Bulk pallets (1) to (8) will be directed to the bold locations. The upside down triangle shape is visible.

    Additional bulk pallets (9) to (16) will gradually fill up rack A1, and continu in neighbouring rack A3. 

    Field Description Remark
    6 - Bulk Loc A1-61   (6)              Loc A1-62   (5)                Loc A1-63   (7) Loc A3-61 (16)    Loc A3-62        Loc A3-63 

    5 - Bulk

    Loc A1-51   (8)              Loc A1-52   (4)                 Loc A1-53   (9)

    Loc A3-51           Loc A3-52        Loc A3-53 

    4 - Bulk

    Loc A1-41   (10)              Loc A1-42   (3)                 Loc A1-43  (11)

    Loc A3-41           Loc A3-42        Loc A3-43 

    3 - Bulk

    Loc A1-31   (12)              Loc A1-32   (2)                 Loc A1-33  (13)

    Loc A3-31           Loc A3-32        Loc A3-33 

    2- Bulk

    Loc A1-21   (14)              Loc A1-22   (1)                 Loc A1-23  (15)

    Loc A3-21           Loc A3-22        Loc A3-23 

    1- Pick

    Loc A1-11                        Loc A1-12                         Loc A1-13

    Loc A3-11           Loc A3-12        Loc A3-13 

    0 - Pick

    Loc A1-01                        Loc A1-02 = fixed loc        Loc A1-03

    Loc A3-01           Loc A3-02        Loc A3-03 

    The standard checks and location directive query criteria are taken into account.

    The strategy only considers the current aisle. In most cases, an aisle change of a reach truck is time consuming, so that should be avoided. 

    The maximum distance (number of racks up or down the aisle) that is evaluated by this strategy is specified in the warehouse zone group setup. Note that the zone group that contains the zone of the fixed location, is used to find this maximum number of racks. If the maximum distance is set to more than 10 racks, performance will be slower.

    In many cases odd racks are on the left side and even racks on the right side of the aisle or opposite. Depending on the characteristics of the reach truck it is easy or difficult to replenish goods to the opposite side.

    Setup location directives

    Setup warehouse

    Warehouse zone groups

    Warehouse zone group setup

    Zones

    Aisles

    Location format

    Locations

    Fixed locations

     

    Locations

    Warehouse management > Setup > Warehouse > Locations

    On the locations, a new field ABC frequency is added. This field can be used to detect, e.g.

    Display fields are added to provide quick information about current and incoming inventory on the location.

    Standard WMS fields are added to the WHS location form.

    Field Description Remark
    ABC frequency

    A locations are easily accessible and are generally suitable for fastmover storage.

    C locations are generally suitable for slow mover storage.

    Filter on C-items that have been assigned to an A-location as fixed location.

    Create a movement by template setup that finds a suitable A, B or C location based on the ABC frequency of the released product.

    Filter on inventory of C-items that occupies an A-location. From the location, create movement work to relocate these items to a C location.

    Incoming LP *)

    Open or in process put away work for this license plate exists and is heading for this location

    Item on location *)

    Currently, physical inventory of this item exists on the location

    Free location *)

    Display method, used to find a suitable fixed location for a new item in a limited range of locations.

    Location is assigned as fixed location for this item

    Display method, used to avoid assigning a fixed location for a new item next to a look-a-like item. Use in a limited range of locations.

    Aisle

    Aisle can be used actively, incl. travel direction and aisle sequence

    Rack

    Rack number

    Shelf

    Shelf number (a.k.a. level or beam). Ground level is the lowest number

    Bin

    Bin number (a.k.a. position on the shelf, level or beam).

    *) On the form Locations, the user can switch on or off additional information that dynamically retrieves relevant information about the location.

     Important

    If the warehouse contains many locations: before switching on additional information columns such as "Incoming LP", "Item on location", "Free location", "Fixed location for item", narrow the selection of locations first.  
       

    Setup locations

     

    Replenish to fixed locations

    Warehouse management > Setup > Warehouse > Fixed locations

    The standard replenishment template lines can be set of for min max replenishment. However, if the minimum and maximum quantity on the fixed location varies per item, the required setup of one replenishment template line per item is enormous. 

    Therefor, on the fixed locations per released product and the fixed locations per product variant three fields are added to the form (and the data entity WHSFixedProductWarehouseLocationV2):

    Field Description Remark
    Minimum quantity Below this minimum quantity replenishment will be generated if in the periodic replenishment the parameter is set to Minimum from fixed location. 

    High minimum

    Optional. Below this higher than minimum quantity, replenishment will be generated if in the periodic replenishment the parameter is set to Minimum from fixed location.

    Use to cram up locations before a peak period, even though the current inventory is above the normal minimum quantity.

    Maximum quantity

    The replenishment will aim for this level. 

     

    Warehouse management > Replenishment > Replenishments

    In the Replenishment dialog there are three options for the use of replenishment values:

     

    Replenish to dynamic locations

    Exact timing is a common challenge in replenishing to fixed locations:

    High cubic velocity of an item (the cubic pick volume per period per item), in combination with a large number of less-than-pallet picks typically cause an even bigger challenge in replenishment. Especially when an item needs multiple replenishments per day, it might be better to replenish to dynamic picking locations in stead of replenishing the fixed location.

    Advanced Warehouse Management streamlines the replenishment process:

    Setup location directives 

     

    Load requirements

    Warehouse management > Inquiries and reports > Load line requirements

    Warehouse management > Loads > All loads > Button: Requirements

    An inbound or outbound sea container should be monitored in an efficient way. Container unloading must be prioritized if it contains items that are needed shortly. Container loading could be waiting until the last items are received in the warehouse. In some cases, it might speed up the process if the vendor will send the missing item via express carrier service.

     

    Challenge in standard Microsoft Dynamics 365 for Finance and Operations is the overview: it is possible to monitor each line individually, and view the net requirements per load line. Advanced Warehouse Management adds a clear overview screen per inbound load and outbound load.

     Note

    The load requirements screen is based on the Master planning (MRP) transactions. There are multiple ways to setup the Master planning and this can influence the way the load requirements are displayed. For most cases it is advised to switch off the increase action and the postpone action on the coverage group.
       

    From the inbound load, the requirements, i.e. the planned destination for the load lines are displayed.

    E.g. if an incoming container is lost on the sea, or an outbound load is being planned, it is important to see the MRP transactions related to this container (effects on sales orders, and dependencies on purchase orders).

    In the upper fast tab, all planned receipt transactions (master planning transactions of type receipt) for the load lines are displayed, and the assigned quantity and first outbound ship date of any related requirement (issue transaction). Note that if the full quantity will be put on stock and is not linked to a requirement, there is no assigned quantity and no first assigned date.

    In the lower fast tab, the demand requirements, i.e. all master planning transactions (receipt) with related issue transactions are displayed.

    With the checkmark "Link requirement lines to receipt lines" switched on, the lower part only contains the demand requirments for the selected receipt transaction. 

     

    In a similar way, from the outbound load, the requirements, i.e. the planned sourcing for the load lines are displayed.

    E.g. the outbound load is already planned via the load planning work bench, and several load lines will be supplied through open purchase order lines.  

    Field Description Remark
    Plan Master plan

    Direction

    Inbound and / or outbound

    Link requirement lines to receipt lines

    Only display the requirement transactions for one selected load line

    Load ID

    Load

    Hoover over the load ID to view status, load reference number (container ID), carrier and service, extra info, voyage, vessel, volume and weight etc.

    Load shipped confirmation date

    Confirmed that the load was actually shipped on this date

    ETA

    Estimated date and time of arrival

    Order type

    Sales order, Purchase order, Transfer order issue

    Order number

    Sales ID, Purchase ID, Transfer ID

    Item number

    Released product ID

    Warehouse

    Configuration, Size, Color, Style

    Product dimensions, can be displayed or hidden

    Quantity

    MRP planned increase or decrease of inventory

    Assigned quantity

    MRP planned demand that will be sourced by this load line  

    Outbound: negative

    First date assigned

    MRP planned date on which the first demand is planned

    If this date is within a short period, prioritize the unloading of this inbound load

    On hand

    Current on hand inventory in this warehouse

    If the current on hand quantity is low, prioritize the unloading of this inbound load.

    Customer account

    Customer to which the quantity is assigned

    Outbound load only

    Customer group

    Customer group to which the quantity is assigned

    Outbound load only

    Requirement date

    Confirmed date, or requested date 

    Delay (days)

    MRP calculation of the expected delay

    Reference

    Number

    Number of the reference order

     

    Delivery address per vendor and warehouse

    Warehouse mgt > Setup > Shipping > Vendor and warehouse address settings

    For optimal flexibility and the benefits of the capabilities of WHS for internal warehouse replenishment, the best practice is to have few warehouses. E.g. if two physical warehouse buildings are on opposite sides of the street, it is generally a good decision to depict these two warehouse buildings as one administrative warehouse.

    If the warehouse has a large size, there could be multiple gates or addresses to which a vendor should ship to.

    Therefor, Advanced Warehouse Management adds functionality to select a deliver-to-address per vendor and warehouse. Only valid addresses for this warehouse or the site of the warehouse can be selected.

    This address will be defaulted when a purchase order header is created or generated for this warehouse, and when a purchase order line is entered or generated for this warehouse, or when the warehouse is changed.

    The deliver-to-address can be printed on the purchase order documents.

     

    If no exception is specified, the standard address of the warehouse or site will apply.

    Note that the standard header to line functionality is not changed.   

     

    Validate weight and height on double deep locations

    Scenario:

    In one location, two Euro pallets can be stored (double deep). The maximum weight on this location is 1400 kg, and usable height is 1.80 m.

    The weight of the first, resp. second Euro pallet should not exceed 700 kg, and the pallet height should not exceed 1.80 m.

     

    In the location profile, tab Container types, the maximum number of units can be specified (e.g. a specific location profile can be setup for a double deep location for two Euro pallets). Unfortunately, in standard Microsoft Dynamics 365 for Finance and Operations the maximum weight and height are not checked per unit:

    For put away of purchase orders, production orders, goods in transit orders and inventory movement by template, Advanced Warehouse Management can optionally validate the weight and the height of a single unit, specific for double deep, triple deep etc.

     

    Setup:

    On the location profile, specify:

     

    On the location stocking limits, tab container types, specify:

     

    On the released product, physical dimensions, e.g. for the unit PL specify:

     

    Default BOM journal location for kit (dis)assembly

    Inventory management > Periodic tasks > Bills of materials > Report as finished

    Standard Microsoft Dynamics 365 for Finance and Operations in a WHS enabled warehouse does not work well with the most simple version of kitting, i.e. through a BOM journal. The main problem is that the locations can not be defaulted, and therefor it is not possible to post the journal in one go. After creation of the BOM journal in the form Report as finished, the user has to open a different form Bills of materials journals, find the right journal and enter the location for all components in the journal lines, and post the journal

    In Advanced Warehouse Management , on the warehouse, a default BOM journal location can be set. Through the Report as finished form, enter an item and a warehouse and a quantity, and press OK.

    The default location on the kit header and kit lines is retrieved automatically. 

    For kit assemby, enter a positive quantity. For disassembly, enter a negative quantity.

    Suggested use: define one multi SKU, non-LP location per warehouse for kitting. Transfer the components to this location through replenishment, which can be executed by the mobile device. Use a PC or laptop for creating and posting the BOM journal. 

     

    ASN lines

    Warehouse management > Inquiries and reports > ASN lines

    Through the packing structure of an inbound load, the SSCC and the content of the SSCC is visible per load.

    However searching this information based on the SSCC and without knowing the load ID is less straightforward.

    This Advanced Warehouse Management form displays the lines for all SSCCs (pallets/cases etc. notified on the Advanced Shipping Note from the vendor) on incoming purchase orders, and transfer orders. Main tables: WHSASNItem and WHSLoadLine.

     

    Open ASN lines

    Advanced filter:

     

    Open ASN lines in process

    Advanced filter:

     

    Received ASN lines

    Advanced filter:

     

    See Also