Lot Blending

This document explains the routines for lot blending. Each lot consists of one or more quantities that possess identical characteristics. Bulk items, both those stored in Silos or Full Mix Tanks (Location Characteristic = 2 or 3), can be either solid or liquid. They can be received into a silo or full mix tank by receiving of any type of order (PO, DO, MO and CO return). In addition, items stored in silos and full mix tanks can be transferred (pumped or conveyed) from one location to another.

When items share the same Location Characteristic with one another and also with the location (such as a silo or tank), the blending of those items is permitted. Tank cleaning is the equivalent of a stock adjustment whereby a location balance will be set to zero so that a tank may be used to blend a different set of items.

Use lot blending for items to be put-away or transferred to locations with matching location characteristics. All existing programs used to put-away or transfer items will validate this, and any transactions where the Location Characteristic of the item and location are not equal are prevented. In some cases, existing location change functions will be blocked entirely and you are directed to 'Blending Lot. Open' (MWS155) for this purpose.

Outcome

Lot blending is a concept used when handling bulk items in tanks and/or silos. Because food safety is more important than ever, the system supports a solid lot blending process that is industry-specific in Food & Beverage, as well as the Chemicals industry. Blending ensures a secure proper proactive control of logistics flows and provides follow-up and traceability within the supply chain.

To gain traceability, a Location Characteristic may be attached to stock locations and to the item master. In contrast to Location Type, Location Characteristic has a limited number of options describing the nature of the location, providing the ability to add logic to the behavior of an item in the location.

Two important tables are used for lot blending. They are MILOMA (Lot Master File) and MIWLAL (Location Action Log).

The lot characteristic (TANK) defined for the item is stored in the MITMAS table (item master).

The lot characteristic (WHLC) defined for the location is stored in the MILOMA table (lot master).

The MIWLAL table (Location Action log) displays the history for related transactions (with a transaction type of '99-Blending').

Before you start

Completing the basic item setup

  1. Open 'Item. Open' (MMS001).

  2. On panel G, select a Lot characteristic of '0-No special characteristics', '1-Bulk', '2-Silo with FIFO consumption' or '3-Full Mix Tank'.

    Note: After the value is set, it cannot be changed until the quantity on hand of the item is zero (for all balance identities, all locations, all warehouses).
  3. If you select a Lot characteristic of '2-Silo with FIFO consumption', you must define the item's Lot control method on panel E as anything other than '0-Not used'.

  4. If you select a Lot characteristic of '3-Full Mix Tank', the item must:

    • Have a Lot control method of '1-Lot control used but not defined in lot master' or '3-Lot control used and must be entered in lot master'.

      AND

    • Use a Lot numbering method (defined on panel E of MMS001) of '1-Automatically use YYMM plus a 6-position long sequence number', '2-Automatically use YY plus an 8-position long sequence number', '3-Automatically use a 7-position long sequence number', or '6-Automatically use YYMMDD plus a 4-position long sequence number'.

Setting the basic data for inventory management

  1. Open 'Stock Location. Open' (MMS010).

  2. On panel E, select a Location characteristic value of '0-No special characteristics', '1-Bulk', '2-Silo with FIFO consumption' or '3-Full Mix Tank'.

    Note: After the value is set, it cannot be changed until the quantity on hand in the location is zero.
  3. If you select a Location characteristic of 2 or 3:

    • Multi-storage must be set to '3-Same item'

      AND

    • Container management must be set to '0-Not selected'.
  4. Open 'Item. Connect Warehouse' (MMS002).

  5. On panel G, the default location for the item must have the same Location characteristic as the item. Otherwise, an error message, saying "Item can only be stored in location with corresponding Location characteristic," will be presented.

  6. If the item has a Location characteristic of 2 or 3, the Container Management setting on panel G must be set to '0-Not used' and this value cannot be changed.

  7. Open 'Item. Connect Facility' (MMS003).

  8. On panel E, you cannot set up items with the Location characteristic value of 3 to use dynamic or actual costing. Therefore, the Inventory accounting method field cannot be set to '3-Dynamic' or '4-Actual'.

  9. Open 'Number Series. Open' (CRS165) to view each series that supports blending:

    • Series B5 A for Lot blending
    • Series B6 A for Tank cleaning
  10. On 'Stock Transaction Type. Open' (CRS205), you may assign a Transaction type of '99-Blending'.

Follow these steps

Blending lots

  1. Launch 'Blending Lot. Open' (MWS155).

  2. On panel A, specify the Warehouse, Item Number, Location (From Location), Lot Number, To Location, Quantity (to transfer), and Catch Weight (if used for the item).

  3. On panel E, you can select a Status for the new lot and enter additional details. The system displays details of the last recorded movement on the New lot no, (Total) New qty, and (Total) Allocated qty fields.

  4. Click Next to perform the transfer. A new item-lot number is created for the blend.

    Note: 'Blending Lot' (MWS155) replaces 'Movement. Change Loc - Item' (MMS175) and 'Movement. Change Loc - Balance ID' (MMS177) for items with a location characteristic of '3 - Full Mix Tank'.
  5. Open 'Tank cleaning' (MWS156) to set all Balance Identities in a selected location to '0' by generating a Transaction Type = '91-Scrap transaction'.

    Note: This function is restricted to locations with a Location characteristic of '2-Silo with FIFO consumption' or '3-Full Mix Tank'.
  6. On panel B, enter or select the Warehouse and the Location within the warehouse to be cleaned.

  7. Click Next and the system displays all lots found in the location as well as the last cleaning date/time.

  8. Specify a Remark and a Trans Reason code, if desired.

  9. From the Actions menu, select Clean Tank Update. The system displays the message: 'WARNING - the location balance will be '0' after cleaning.'

  10. Again, select Clean Tank Update from the Actions menu.

  11. Click Next to clean the tank. The screen refreshes and shows that no lot balances occupy the location.

  12. Open 'Location Activity Log. Open' (MWS157) to view the history for blended transactions.

  13. On panel A, specify a Warehouse and Location.

    Note: Optionally, you may specify a transaction date and time, item number and lot number to filter the result set.
  14. Click Next and the system will display all records from MIWLAL (Location Action Log) that match the input criteria.

  15. Open 'Lot. Trace' (MMS140) and select the Transaction Type of '99-Blending' to trace blended items.

Related topics