Manage Sublots

This document explains how to generate one or more sublots associated with an item.

Sublots may be used to capture the catch weight of an individually packaged item. Another purpose of sublots is to track items with serial numbers.

Outcome

Sublots are unique entities used to capture the catch weight of an individually packaged item or to identify, along the process, where this individual item came from and where it went.

Note: The Catch weight (CAWE) field in 'Catch Weight Item. Update Weight' (MMS360) is protected if the item is sublot-controlled. The system instead calls 'Sublot Master. Open' (MMS472) to enable the catch weight to be updated on the sublots.

When a sublot is created, the system assigns a number, referred to as the 'Sublot ID', to that sublot which is unique to the item and lot. A reference sublot ID is also generated during the sublot creation.

The creation of a sublot policy determines how the Reference sublot ID field value is managed for an associated sublot-controlled item.

See Define Sublot Policy.

Sublots are stored in the Sublot (MITSUB) table.

Items which are sublot-controlled cannot be backflushed automatically. When receiving an item into a lot that already has sublots defined, the newly assigned sublot numbers may not be incremented from the point where the previous sublot numbers were generated. Since previous sublots could have either been mistakenly created or issued from the same lot, the new sublot numbers may be generated from the next available sublot number for that particular item and lot.

As a sublot progresses through various types of inventory transaction processes, it is assigned one of these sublot states:

  • 10: In process - indicates the initial state of a sublot when it is generated
  • 20: Received - the state of the sublot when there is a related inventory receipt transaction
  • 30: Issued - the sublot state indicated upon inventory being issued
  • 95: Relocated - the state assigned to a sublot placed in a different location than originally indicated
  • 99: Discarded - the state for a sublot that never has been used in a transaction.

The sublot states come into play for the types of transaction activity described.

If a particular transaction fails, the sublot reverts to its original sublot state (for example, 'In process' or 'Received').

Using sublots in inventory transactions

Sublots may be transacted across the system. When an item is set up as sublot-controlled, all the related transactions require sublots to be selected. If the packaging functionality is used, sublots have to be selected so that they are included in the inbound package.

  • When one or more sublots are selected in 'Sublot Master. Open' (MMS472), the original sublot state is 10='In process'.
    • If the transaction is not a receipt, the sublot state changes to 30='Issued'.
    • If sublots are not selected (for example, not used), the sublot state of 99='Discarded' is assigned.
    • For sublots that are selected and received, the sublot state becomes 20='Received'.
  • When the inventory is transacted through batch program MMS900 (Stock transactions), the sublots will be updated to the state of 20='Received' for transactions, including a positive adjustment to physical inventory. When in transit, the sublots remain in the Sublot table (MITSUB) with an assigned state of 20='Received' in the in-transit location.

Using sublots in stock movement transactions

There are different ways to do stock movements in a warehouse. The transfer of sublot-controlled items requires individual sublots to be moved along with the quantity specified. Changes to catch weight or to the reference sublot ID are not allowed in any type of stock movement.

  • In 'Movement. Change Loc - Item' (MMS175), you can move stock between locations within a warehouse. When using an item that is sublot-controlled, 'Sublot Master. Open' (MMS472) launches to select sublots and also displays the sublots in stock. You can select less than the requested quantity and that specified quantity is used to update the inventory. Once the sublots are selected, the inventory is moved with those sublots from one location to another. When moving the full quantity on-hand, 'Sublot Master. Open' (MMS472) is not opened and the system moves all the sublots.
  • In 'Movement. Change Loc - Balance ID' (MMS177), you can move stock between locations within a warehouse. When using an item that is sublot-controlled, 'Sublot Master. Open' (MMS472) launches to select sublots and it displays the sublots in stock. You can select less than the requested quantity and that specified quantity is used to update the inventory. Once the sublots are selected, the inventory moves those sublots from one location to another. When moving the full quantity on-hand, 'Sublot Master. Open' (MMS472) is not launched and the system moves all the sublots. Movement from one location into multiple locations is prevented for sublot-controlled items.
  • In 'Movement. Change Loc - Container' (MMS105), you can move stock from one container in a location to another container in another location within the warehouse. When the container has items that are sublot-controlled, the system moves all sublots from the container into another container in a different location.
  • In 'Movement. Change Loc - All Items' (MMS180), you can move all the items from a location to different locations within the warehouse. When the location contains sublot-controlled items, the system moves them along with the quantity to the new locations.
  • In 'Movement. Change Loc - Single Loc Items' (MMS820), you can move items from a single location to another location. Sublot-controlled items will not be valid for movement.

Using sublots in balance ID reclassification transactions

In 'Balance Identity. Reclassify' (MMS130), you can change the status of a balance ID or reclassify an item/lot into a new item/lot. When using an item that is sublot-controlled, 'Sublot Master. Open' (MMS472) launches to select sublots and it displays the sublots in stock. Once the sublots are selected, the inventory reclassifies them into the new item/lot.

From item

To item

Result

Item is sublot-controlled

Item is sublot-controlled

(MMS472) opens so you can select sublots. Update the To Item/Lot with new sublot IDs but use the same catch weight and reference sublot ID.

Item is sublot-controlled

Item is not sublot-controlled

(MMS472) is opened and sublots selected are issued. The To item quantity is increased; no sublots are created.

Item is not sublot-controlled

Item is sublot-controlled

Using sublots in Manufacturing Order (MO) transactions

Manufacturing Order (MO) reporting transactions

  • When reporting a positive quantity in 'Manufacturing Order. Report Receipt' (PMS050), the 'Sublot Master. Open' (MMS472) launches and the number of sublots, as indicated by the quantity in base unit of measure, are created. Once you accept the selection and any entered information, including catch weight (if applicable to the item), and 'Reference sublot ID', the inventory is increased and sublots are stored in the sublot state of 20-'Received'.
  • For all sublot-controlled items that are set up as catch weight, the only way to specify the catch weight is through (MMS472). You are not permitted to edit the catch weight value in 'Manufacturing Order. Report Receipt' (PMS050).
  • If you cancel the selection of sublots, the state of 99='Discarded' is applied to those sublots.

Manufacturing Order (MO) reversal transactions

  • By specifying a negative quantity in 'Manufacturing Order. Report Receipt' (PMS050), you are performing a reversal transaction. The 'Sublot Master. Open' (MMS472) launches with the previously reported sublots displayed. You may select the sublot quantities required to complete the reversal. You also may select less than the requested quantity and that selected quantity is used to update the inventory. After the sublots are selected, the inventory is decreased and sublots that have been marked as 99='Discarded' will no longer be available in stock.

Manufacturing Order (MO) issue transactions

  • In 'Manufacturing Order. Report Issue' (PMS060), you may issue from stock inventory into the production line. When using an item that is sublot-controlled, the 'Sublot Master. Open' (MMS472) launches so you can select the sublots to be issued from stock. Only sublots available in a 'Received' state may be selected. Once you select the sublots, the total catch weight and total quantity values are calculated and the inventory is updated with those quantities.

Manufacturing Order (MO) return transactions

  • In 'Manufacturing Order. Report Issue' (PMS060), you may return into stock inventory what was previously issued from inventory into the production line. When using an item that is sublot-controlled, the 'Sublot Master. Open' (MMS472) launches so you can select the sublots that were originally issued for the same MO. Once you select the sublots, the total catch weight and total quantity values are calculated and the inventory is increased.

Using sublots in Purchase Order (PO) transactions

Purchase Order (PO) receipt transactions

  • When receiving sublots in 'Purchase Order. Receive Goods' (PPS300), a lot number is always required for sublots, regardless of the lot number method defined for the item. For all sublot-controlled items that are set up as catch weight, the only way to specify the catch weight is through 'Sublot Master. Open' (MMS472). You are not permitted to edit the catch weight value in 'Purchase Order. Receive Goods' (PPS300).
  • Sublots are created in the Sublot table (MITSUB) after the validations have occurred in the goods receipt process in 'Purchase Order. Receive Goods' (PPS300). The number of sublots created corresponds to the received quantity specified. You may display your sublot transactions in 'Sublot Transaction. Display' (MWS072).
    Note: The recommendation for sublot-controlled items is to always report a desired sublot selection on a unique receiving number, whether it is for a particular location or container.

Purchase Order (PO) receipt transactions through batch entry

  • The process of receiving sublots using API is performed in 'Order Init Stock Msg. Manage' (MHS850) or using the MHS850MI transaction, 'AddPOReceipt'.

    When an item is sublot-controlled, no catch weight value is available to report in this transaction and an error message results if an attempt to include the catch weight occurs.

  • The execution of 'AddPOReceipt' creates these levels:
    • Message header 'Order Init Stock Msg. Manage' (MHS850)
    • Package header 'Order Init Package Msg. Manage' (MHS851)
    • Message line 'Order Init Stock Trans Msg. Manage' (MHS852)
  • The fourth level implemented for sublots through 'Order Init Sublot Msg. Manage' (MHS854) is required to specify the sublots to be included in the goods receipt. Information such as 'Reference sublot ID' (BANT) and 'Catch weight' (CAWE) is updated for each sublot record. This level may be executed using the MHS850MI transaction, 'AddSubLine'.

    The 'Subline number' (SUBL) field value in the MHS854MI transaction does not always correspond to the actual 'Sublot ID' (BANS) created in the 'Sublot Master. Open' (MMS472). The 'Subline number' transaction value is used as the temporary number until a valid internal Sublot ID is retrieved from previous transactions.

  • When processing the message header, the number of sublot records specified must match the 'Received quantity' (RPQA) on the associated message line level (MHS852). If an alternate unit of measure is used as the PO unit of measure on the message line, a conversion will be performed to the basic unit of measure and the system will validate the quantity between the line and sublot level.
  • Sublot transactions created for a goods receipt processed using batch entry may be displayed in 'Sublot Transaction. Display' (MWS072).

Purchase Order (PO) receipt transactions using supplier delivery note

  • Suppliers sending advanced shipping notes (ASN) messages with detailed information of the goods shipped are received through the interface program 'Order Init Stock Msg. Manage' (MHS850). ASN messages including a full structure of packages and items are received into the system through the interface program (MHS850MI) using the transactions, 'AddWhsHead', 'AddWhsPack', and 'AddWhsLine'. For sublot-controlled items, the sublot details are specified into Order Init Sublot Msg. Manage (MHS854) through the 'AddSubline' transaction with sublot reference information and catch weight. The ASN message gets a qualifier of '29' in 'Order Init Stock Msg. Manage' (MHS850).

    Message numbers with ASN details (i.e. qualifier of '29') in 'Order Init Stock Msg. Manage' (MHS850) are processed into 'Supplier Delivery Note. Open' (PPS360). The ASN record structure has packages, items, and sublots. The sublots are connected to items/packages and handled in 'Delivery Note Sublots. Open' (PPS364) with information such as the sublot reference information and catch weight. You can adjust the sublot details in (PPS364) until the sublots are received into stock.

  • Goods receiving sublots in 'Supplier Delivery Note. Open' (PPS360) is done using option 14='Goods receipt'. The goods are updated into stock in 'Balance Identity. Open Toolbox' (MWS068) with quantity, lot number, sublots, and goods receiving number. In the case of in-house packages, sublots are not created after the goods receipt as a temporary lot number exists. Instead, the sublots are created when reporting the next activity defined in the goods receiving method, whether that be quality inspection or put-away.
  • The goods receipt reporting for the delivery note is performed using API with the PPS360MI transactions, 'StagePackage', 'StageSSCC', and 'ReceiveHead'. The PPS364MI transaction, 'UpdSublot', handles the update of sublot details per delivery note.

Put-away of sublot items

  • When reporting put-away for a receiving number in 'Purchase Order. Put away Goods' (PPS320), the lot number cannot be changed as the creation of sublots has already taken place. You must specify the same lot number which has been used in the goods receipt in order to select the sublots in 'Sublot Master. Open' (MMS472). An error message is displayed in 'Purchase Order. Put away Goods' (PPS320) if no sublots are found.
  • If the item is catch weight handled, the field will be locked in 'Purchase Order. Put away Goods' (PPS320) as reporting is always done in 'Sublot Master. Open' (MMS472) on the sublot level.
  • If the put-away is performed with full quantity, 'Sublot Master. Open' (MMS472) will not open as this suggests that all included sublots were selected. It could also be that the sublot item is catch weight managed, and that the intent is to change the weight on individual sublots. In that case, function key 'F14 – Sublots' can be used in order to open (MMS472) interactively.
  • Put-away with partial quantity always results in the automatic opening of 'Sublot Master. Open' (MMS472) as a mandatory step to account for the sublots included. The same applies when a quantity greater than received is specified. In this case, the difference will be created as new sublots with a sublot ID starting from the last used for that item and lot number.
  • Sublot transactions related to a put-away are created when submitting the sublots in 'Sublot Master. Open' (MMS472) and can be displayed in 'Sublot Transaction. Display' (MWS072).

Put-away of sublot items using batch entry

Put-away of sublot items through API is performed in 'Order Init Stock Msg. Manage' (MHS850MI) with the transaction 'AddPOPutaway'. When the item is sublot-controlled, no catch weight will be available to report as this will be done on sublot level. An error message displays if this is attempted.

The transaction works similar to 'AddPOReceipt' where these levels are created upon execution:

  • Message header 'Order Init Stock. Msg. Manage' (MHS850)
  • Package header 'Order Init Package Msg. Manage' (MHS851)
  • Message line 'Order Init Stock Trans Msg. Manage' (MHS852)

The fourth level 'Order Init Sublot Msg. Manage' (MHS854) is utilized to specify the sublots to be included in the put-away. This is only mandatory when reporting partial or higher quantity than received; these scenarios are described here:

  1. Buyer wants to perform put-away of all reported sublots without changing catch weight on any individual sublot.
    • In this case, no records in (MHS854) need to be created. The quantity (RVQA) specified on the line level (MHS852) must be equal to the quantity left to report. This cannot be performed on a partial or higher quantity of the receiving number.
  2. Buyer wants to report a quantity that is partial/higher than received or a full quantity with change of catch weight.
    • When this is attempted, sublot records are required to be created at the (MHS854) level and must equal to the quantity specified at the line level (MHS852). This can be utilized with the 'AddSubLine' transaction.
    • When creating sublots in (MHS854) for this second scenario, it is important that the correct 'Sublot reference ID' (BANT) is specified for the sublot. If it does not match a valid sublot in 'Sublot Master. Open' (MMS472), an error message is displayed.

When executing the message number for processing to the system, the lot number used in the goods receipt is always required. Sublots are never allowed to be created with a new lot number in the put-away; an error message is displayed if this is attempted.

Sublot transactions related to a put-away using batch entry are created when executing the message number and can be displayed in 'Sublot Transaction. Display' (MWS072).

You cannot put-away a sublot-controlled item using the 'PutawayPO' transaction in the purchase order interface program (PPS320MI). A stop message is given if this is attempted.

Quality inspection of sublot items

  • When reporting quality inspection for a receiving number in 'Purchase Order. Inspect Goods' (PPS310), the lot number cannot be changed as creation of sublots have already taken place. You must specify the same lot number which has been used in the goods receipt in order to select the sublots in 'Sublot Master. Open' (MMS472). An error message is displayed in (PPS310) if no sublots are found.
    Note: It is not possible to partially reject sublots in (PPS310) in the use of the 'QI result' (QCRR) field set equal to 3. This is because of the technical risk involved when calling (MMS472) two times interactively to account for which sublots that were approved and rejected.
  • If the quality inspection is performed with full quantity, 'Sublot Master. Open' (MMS472) will not open as this suggests that all included sublots were selected. It could also be that the sublot item is catch weight managed, and that the intent is to change the weight on individual sublots. In that case, function key 'F16 – Sublots' can be used in order to open (MMS472) interactively.
  • If the put-away is performed with full quantity, 'Sublot Master. Open' (MMS472) will not open as this suggests that all included sublots were selected. However, it could be that the sublot item is catch weight managed, and that the intent is to change the weight on individual sublots. In that case, function key 'F14 – Sublots' can be used in order to open (MMS472) interactively.
  • Quality inspection with partial quantity will always force-open 'Sublot Master. Open' (MMS472) as a mandatory step to account for the sublots included. The same applies when a quantity greater than received is specified. In this case, the difference will be created as new sublots with a sublot ID starting from the last used for that item and lot number.
  • Sublot transactions related to a quality inspection are created when submitting the sublots in 'Sublot Master. Open' (MMS472) and can be displayed in 'Sublot Transaction. Display' (MWS072).

Quality inspection of sublot items through batch entry

  • Quality inspection of sublot items using API is performed in 'Order Init Stock Msg. Manage' (MHS850MI) with the transaction 'AddPOInspect'. When the item is sublot-controlled, no catch weight will be available to report as this will be done at the sublot level. An error message will display if this is attempted.
    Note: It is not possible to partially reject sublots in the use of the 'QI result' (QCRR) field set equal to 3. An error message will display if this is attempted.
  • The transaction works similar to 'AddPOPutaway' and 'AddPOReceipt' where these levels are created upon execution:
    • Message header 'Order Init Stock. Msg. Manage' (MHS850)
    • Package header 'Order Init Package Msg. Manage' (MHS851)
    • Message line 'Order Init Stock Trans Msg. Manage' (MHS852)
  • The fourth level 'Order Init Sublot Msg. Manage' (MHS854) is utilized to specify the sublots to be included in the quality inspection. This is only mandatory when reporting partial or higher quantity than received. For specific scenarios, see Put-away of sublot items using batch entry.
  • When creating sublots at the (MHS854) level, it is important that the correct 'Sublot reference ID' (BANT) is specified for the sublot. If it does not match a valid sublot in 'Sublot Master. Open' (MMS472), an error message will be displayed.
  • When executing the message number for processing to the system, the lot number used in the goods receipt is always required. Sublots can never be created with a new lot number in the quality inspection; an error message is displayed if this is attempted.
  • Sublot transactions related to a quality inspection through batch entry are created when executing the message number and can be displayed in 'Sublot Transaction. Display' (MWS072).

    You cannot quality inspect a sublot-controlled item through the transaction 'QualityInspPO' in the purchase order interface program (PPS310MI). A stop message is given if this is attempted.

Report quality inspection and put-way of in-house packages

  • Quality inspection (QI) of delivery notes with in-house packages are reported in 'Purchase Order. Inspect Goods' (PPS310) with the inspection result, location and rejection reason for each package number. QI reporting is based on the Package number, not the individual item details in the packages and single goods receiving number. The input to the reporting, therefore, is the warehouse and the supplier delivery note. Before updating the QI results per package, the sublot details such as catch weight, can be updated manually in 'Delivery Note Sublots. Open' (PPS364) using a related option from 'Purchase Order. Inspect Goods' (PPS310).

    The QI reporting of in-house packages also may be performed through the PPS310MI transactions, 'QualityInspPack' or 'QualityInspSSCC'.

  • Put-away of delivery notes with in-house packages are reported using 'Purchase Order. Put away Goods' (PPS320). The put-away reporting is based on Package number. Therefore, the input to the reporting is the warehouse and the supplier delivery note. The reporting is performed on the H panel of (PPS320) where the put-away location may be reported for the individual package number. Before updating the put-away per package, the sublot details including catch weight can be updated manually in 'Delivery Note Sublots. Open' (PPS364) through a related option from the H-panel of 'Purchase Order. Put away Goods' (PPS320).

    The put-away reporting also can be performed using the PPS320MI transactions, 'PutawayPack' or 'PutawaySSCC'.

Reversal of PO lines with sublot items

  • The reversal of a purchase order transaction in 'Purchase Order. Display Line Trans' (PPS330) for an item that is sublot-controlled results in the restoration of a sublot's original state, in addition to correcting the associated stock transactions.
  • When deleting a transaction, the function will always find the related sublots that were received on the prior transactions and update them accordingly. Those sublots will have their previous sublot states restored, regardless of any subsequent inventory transactions processed, such as put-away. For example, if the deletion occurred for a goods receipt transaction, where the sublot state is '20-Received', the new sublot state would be 99='Discarded' and the sublot's connection to the purchase order line is removed as no previous stock transactions would have been created.

    Using sublots in cross-docking transactions

  • Cross-docking of a sublot-controlled item is allowed only if the full put-away quantity can be cross-docked to one demand order line, i.e. the demand quantity is greater than or equal to the put-away quantity.
  • See Cross-Docking and Extended Cross-Docking.

Using sublots in two-step put-away

  • When moving a quantity to another location in 'Pending Put-away. Process' (MWS460), sublots have to be selected in 'Sublot Master. Open' (MMS472) unless the full quantity on that combination of location/item/lot number/container is moved.

    This means that if there is more than one Put-away number on the same combination of location/item/lot number/container, sublots have to be selected manually in 'Sublot Master. Open' (MMS472) even if the full quantity on a specific Put-away number is moved.

    Note: All the sublots for the combination of location/item/lot number/container are displayed in (MMS472), not only the ones that are associated with the put-away number that is being changed.
  • The quantity that is pending for put-away is not allocatable, but it is possible to select sublots when reporting an issue. This only is applicable when there is an allocatable quantity on the same combination of location/item/lot number/container. The selection of sublots may be required if there is an interval of time between the actual put-away and the reporting of the put-away in 'Pending Put-away. Process' (MWS460). It is possible that the sublots are picked in this time interval and then it is important that the issue can be reported even though the specific sublots are not yet officially put-away.
  • Two-step put-away using API is performed in 'Order Init Stock Msg. Manage' (MHS850MI) transaction 'AddPutAwayConf'.

    If the 'To location' is blank (that is, 'AddPutAwayConf.TWSL' is blank), the transaction corresponds to related option 16–'Process' in (MWS460). The two-step put-away is confirmed, and the quantity becomes allocatable. If a quantity is specified (in the RVQA field), then that quantity is ignored, since it is not possible to confirm put-away of part of the quantity.

    Note: You cannot put-away a partial quantity in (MWS460) either.

    If the 'To location' is not blank (that is, AddPutAwayConf.TWSL is not blank), the transaction corresponds to option 2–'Change' in (MWS460) and changing the location (performing a move), followed by related option 16–'Process'. This results in a move to the specified location, the two-step put-away is confirmed, and the quantity becomes allocatable. For a sublot item, this is only allowed if the full quantity on that combination of location/item/lot number/container is moved.

    Note: The combination of location/item/lot number/container can belong to more than one put-away number, which would make it impossible to perform this move using API.

    See Goods Receiving with Two-Step Put-Away.

Using sublots in warehouse interface

Sublot item handling in Internal stock message interface

  • The Internal stock message 'Order Init Stock Msg. Manage' (MHS850) is a warehouse interface for item-related transactions, such as stock movement, reclassification, or inventory counting.
  • The sublot details are handled in 'Order Init Sublot Msg. Manage' (MHS854) for items having these transactions that involve sublots:
    • Location movements in stock
    • Inventory transactions
    • Package movements in stock
    • Stock-take reporting (for example, inventory counting)
    • Item and lot reclassification
    Note: The transactions in 'Order Init Stock Msg. Manage' (MHS850) where sublot details are not supported include: MO orderless reporting, Lot blending, and External sales transactions.
  • The sublot information is archived together with all the other stock message information when 'Archiving Stock Msg' (MMS894) is executed.

Sublot item handling in Order initial stock message interface

  • The 'Order Init Stock Msg. Manage' (MHS850) program is a warehouse interface to be used for item-related reporting transactions, such as MO put-away, PO receipt, picking/packing transactions, and shipment advice.
  • The sublot details are handled in 'Order Init Sublot Msg. Manage' (MHS854) for items having transactions that involve sublots.
  • Different transactions are identified with various qualifiers:
    • 20 - PO Receipt
    • 21 - PO Inspect
    • 22 - PO Put-away
    • 29 - Shipment advice - The Receive ASN information from a supplier about delivery notes has details about goods delivered in packages and items. All sublots packed per item/package are listed and individual information about the external Sublot reference ID and Catch weight.
    • 30D CO Return - Put-away of CO return.
  • The sublot information is archived together with all the other stock message information when 'Stock Messages. Archive' (MMS894) is executed.

Using sublots in physical inventory counts

On-hand balance entries/adjustments in (MMS310)

  • When creating or adjusting balance identities in 'Physical Inventory. Quick Entry' (MMS310), the 'Sublot Master. Open' (MMS472) program launches and the number of adjusted sublots in base unit of measure need to be managed.
  • The increase of on-hand balance creates and displays the new sublots only. Decrease of on-hand quantity displays existing available sublots. The selected sublots must be equal to the requested number of sublots (or none) before exiting 'Sublot Master. Open' (MMS472). If no sublots were selected, the process of changing the on-hand balance is stopped.
  • For all sublot-controlled items that are set up as catch weight, the Catch weight specified by sublot will be accumulated and saved on the balance ID.
  • Any created sublots during the process of increasing the on-hand balance and that has not been selected receive the state of 99='Discarded'. Sublots removed from stock are set to the state of 30='Issued' and sublots that have been specified into stock will be set to the state of 20='Received'.

Using sublots in Customer Order (CO) transactions

CO entry transactions

  • Customer order line entry of a sublot item is prevented if:
    • It is a line type of 2 (direct delivery from supplier to customer).
    • The dispatch policy (connected to the CO type) has an auto level above 3 (direct delivery) and the CO type is set up with an Inventory accounting code of '1' in (OIS010).
      Note: Adjustment orders (for example, customer order category '6') and credit orders created from a customer return both use order types that have auto level 5, but they are not blocked since the order types have an Inventory accounting code of '0' in (OIS010).
  • For batch order entry, the line would have to be removed manually in 'Batch Order. Open Lines' (OIS276) in order to release the batch order.
  • Customer order line entry of a sublot item also is prevented if the quantity is negative and the customer order line is flagged to be inventory accounted in (OIS101). You can also change the Inventory accounting code in order to allow the creation of the order line.

Using sublots in Customer Order (CO) return transactions

Returned quantities specified for CO return lines

  • Sublots must be selected or created in 'Sublot Master. Open' (MMS472) when a returned quantity is specified in 'Customer Return. Open Lines' (OIS391).
  • If the customer return has a reference to a customer order and the correct lot number was specified in (OIS391), the sublots in the 30='Issued' state that were delivered on that customer order are displayed in (MMS472). The catch weight of the selected sublots can be changed. If no matching sublots are found, you can create new sublots instead.
  • If the customer return does not have a reference to a customer order and an existing lot number was specified in (OIS391), all its sublots that were issued on a customer order (for example, transaction type '31') are displayed in (MMS472). If the sublot is not known (For example, if it is not possible to read the sublot number on the box), the system allows you to create a new sublot instead of selecting an existing one.
  • If no lot number was specified in (OIS391), the system generates a new lot number and new sublots.
  • If the item is catch weight controlled, the 'Catch weight for credit' field is calculated as the sum of the sublots' catch weights. The 'Catch weight for credit' can be changed in (OIS391), since it is not certain that the customer should be paid for the actual catch weight that is put into stock.
    Note: Action 'F14 – Retrieve' sets the return lines to status 11='Advised' even if the default status is set to 22='Returned' in 'Settings – Customer Returns' (OIS399). The status is set to '11' to avoid a call to (MMS472) for each line, which would be very cumbersome if there are many lines.
  • Related option 12='Received qty' is not permitted for a sublot-controlled item.
  • Related option 15='Split' is allowed if there is a lot number on the return line and the CO number is not blank. The panel sequence is executed in change mode for the new line. This can be used, for example, if the customer order line was supplied from several lots; split the return line to be able to create one return line for each lot number.

Inspection results displayed for CO returns

  • The lot number is protected in 'Customer Return. Display Inspection Result' (OIS392) for sublot-controlled items.
  • Sublots must be selected in 'Sublot Master. Open' (MMS472) for each line with a reported quantity in (OIS392).
    Note: Even if the full quantity is moved, the system displays (MMS472) with all the sublots automatically selected. The intention is to provide clarity as to which sublot is associated with each CO return line.

CO return entry for sublot-controlled items

  • The related option 12='Received qty' is blocked if there is any customer return line for a sublot-controlled item on the customer return.

CO return through API

  • Customer return put-away through API is performed in MHS850MI and OIS390MI.
  • In MHS850MI transaction 'MHS850MI.AddCOReturn' is used. For a sublot-controlled item, the 'AddCOReturn' transaction must be followed by transaction 'MHS850MI.AddSubLine' to record each sublot.
  • In OIS390MI, the transactions 'ReturnLine' and 'InspectLine' are used. For a sublot-controlled item the 'RtnSubLotLine' transaction must be run prior to 'ReturnLine' and 'InsSubLotLine' transaction must be run prior to 'InspectLine' to record each sublot.

CO return through API MHS850MI

  • Sublot-controlled items are not permitted in Maintenance Customer Orders and Work Orders.

Using sublots in Distribution Order (DO) transactions

DO receipt transactions

  • Certain data specified in 'Goods Receipt DO/RO. Report' (MWS440) or in 'Goods Receipt DO/RO. Report Details' (MWS445) should not differ from the distribution order:
    • Quantity received in (MWS440) and (MWS445) should not be greater than the quantity issued on the DO.
    • The lot received in (MWS440) and (MWS445) should be the same lot that was issued to the DO.
    • The sublots received in (MWS440) and (MWS445) should be the same lot that was issued to the DO.
  • When you report the receipt of goods for a DO using 'Goods Receipt DO/RO. Report' (MWS440), the system redirects you to 'Sublot Master. Open' (MMS472) to select sublots if the item is sublot-controlled and, optionally, catch weight enabled. This program displays the sublots issued from the shipping warehouse and you have the option to select all or some of these sublots. Once you confirm your selection of the sublots, the receipt quantity and total catch weight are calculated based on the selected sublots. Only the selected sublots are updated to the state of 10='In process'. Any sublots not selected will remain in the state of 20='Received'. Since you cannot receive different sublots than were issued to the DO, the creation and deletion of sublots are not allowed for DO receipts.
  • When the receipt quantity is recorded in the database for each lot/location/container being received, its corresponding sublots are set to a status of 20='Received'.
  • When a DO receipt is reversed, a system call to the Sublot function program MMS472Fnc is made to collect sublots for any item that is sublot-controlled. This function program captures the sublots received for the DO line for a Balance ID. For all of the sublots received in the receiving warehouse for a particular Balance ID, the receipt quantity and total catch weight are calculated.

    The system records the entire receipt quantity and associated sublots to the original in-transit location.

    Note: Since the full receipt quantity of a DO line must be reversed, a call to MMS472Fnc is made for each Balance ID (lot and location and container combination).

Dispatch DO transactions

Dispatch DO (for example, two-way issue and receipt) transactions

  • Issue transactions from stock
    • When one or more sublots are selected in 'Sublot Master. Open' (MMS472), the corresponding sublot state is updated from 'Received' to 'In process'. When the stock is transacted through (MMS900), no update to the Sublot table (MITSUB) is required.
      Note: In the case of the issue transaction failing, the sublot state reverts from 'In process' to 'Received'.

Before you start

The sublot-controlled check box must be enabled on the F-panel of 'Item. Open' (MMS001). See Create Item.

The sublot policy field must be defined on the F-panel of 'Item. Open' (MMS001). See Define Sublot Policy.

Follow these steps

  1. From an inventory program, such as 'Physical Inventory. Quick Entry' (MMS310), where a sublot-tracked item is being managed, launch 'Sublot Master. Open' (MMS472).
  2. Select a range of sublots.

    If no sublots exist, select Actions > Create Sublots to go to the A panel:

    1. Specify a value in the Requested quantity in the basic unit of measure field.
    2. Specify the sublot catch weight.
    3. Click Next.
  3. Optionally, on the B1 panel, update the given Reference Sublot ID, which identifies the sublot associated with a package received into inventory, and the Catch weight.
  4. Select Create to add one or more sublots with the corresponding details in the grid.
    1. To remove a sublot, highlight the row in the grid and select the Delete option.
  5. Save your changes to generate the sublot numbers.

Function program: MMS472Fnc

This function program supports the 'Sublot Master. Open' (MMS472) display program, as well as transactions performed on sublots.

API: MMS472MI (Sublot interface)

These transactions may be used for listing sublots.

API: MWS072MI (Sublot transactions)

These transactions may be used for listing sublot transactions.