Peg distribution in the inbound and inspection processes

Receiving project pegged goods into a warehouse results in inventory transactions that are based on the underlying peg distribution of the related receipt line.

Inbound and pegging

This results in an update of the pegged inventory levels in the Project Pegged Inventory (whwmd2560m000) session. The planned quantity of the inbound order line is updated in the Planned Inventory Transactions (whinp1500m000) session, which also includes the peg data. Planned inventory transactions are also generated for each peg.

If the receipt line is marked for inspection, the received quantity is blocked. Depending on the parameter settings, the quantity can also be blocked for usage by Enterprise Planning. Any quantity, rejected (or destroyed) during receipt inspection are assigned to the pegs having the latest required date to make sure that the approved items are assigned as much as possible to the pegs with the earliest required date in order to meet the demand in time.

Project warehouses

For a ship-from or ship-to warehouse, that is a project or a project-WIP warehouse, no inbound/outbound order line peg distribution is created. Instead, the project fields on the inbound/outbound order lines are used. When however, an inbound/outbound order line is created for a project pegged item related to a normal warehouse, a peg distribution is applicable and the project fields on the inbound/outbound order lines are disabled.

Inbound order line peg distribution

For an inbound order line, the peg distribution data can only be viewed and not maintained. In case of manual transfer orders, the peg distribution can only be maintained (manually) on the outbound order line. When an outbound transfer line is saved after the peg distribution is modified, the inbound transfer order line peg distribution changes accordingly.

Cost and service Items

For order lines with a cost or service item, also a peg distribution can exist, but assigning the received quantities of these item types to the peg lines is always performed pro-rata. This peg distribution data is only essential for proper cost allocation to projects/pegs and has no logistic purpose as these items are non-physical entities. When ordering zero pieces of a certain cost/service item, also a peg distribution can be created, consisting of only one peg line.

Warehouse receipts
  • Receipt line peg distribution

    When confirming a receipt line, LN creates a peg distribution under the receipt line. In addition, peg distribution receipt data is recorded for future auditability in the Receipt Line Peg Distribution Audit (whinh3579m000) session if the Project Peg Receipt Transactions check box is selected in the Project Pegging Parameters (tcpeg0100m000) session.

    The sequence of assigning received items to pegs is based on the earliest required dates and required quantities retrieved from Enterprise Planning.

    If an inbound line contains multiple pegs and the received quantity deviates from the ordered quantity, the received quantity must be apportioned to the peg distribution lines according to the priority determined by the earliest required date as specified in Enterprise Planning. The peg distribution lines are generated when the receipt is confirmed.

    Sometimes, the order quantity of the order exceeds the total required quantity of the item, resulting in an excess quantity. The excess is determined in Enterprise Planning, in which case the distribution lines have no demand order reference and an empty required date. Any excess on top of the required quantity (not exceeding the ordered quantity) is assigned to the pegs in peg line sequence. Any excess that is received on top of the ordered quantity is proportionally distributed to the peg lines based on the ratio of ordered quantities.

  • Updating planned inventory transactions/inventory levels

    When confirming a receipt line, the planned inventory transactions are updated, based on the received quantities of the corresponding receipt line peg distribution. So, the planned inventory transactions are recorded on project peg level.

    When confirming a receipt line, the inventory on hand is increased in the Warehouse - Item Inventory (whwmd2515m000) session. Similarly, the inventory on hand must be increased in the Project Pegged Inventory (whwmd2560m000) session, based on the received quantities of the corresponding receipt line peg distribution.

  • Assigning received quantities to project pegs

    In case of a full, partial or over receipt on an expected inbound order line containing multiple peg lines, LN decides to which pegs the received quantity is assigned, based on the following sequence:

    1. The pegs having the earliest required date are received first, until all required quantities are fulfilled.
    2. The pegs having unfulfilled ordered quantities (and no required quantities anymore) are received in sequence of peg line.
    3. Any excess on top of the ordered quantity is proportionally assigned to the pegs.

    When the full order line quantity is received on the linked receipt line, for each order line peg, a receipt line is created and the total of the received quantities per peg line is equal to the ordered quantity.

  • Back Orders

    For a confirmed receipt line, if the received quantity is less than the expected quantity, the difference must be resolved in Purchase Control by processing the created back order (if allowed). This back order is received on another inbound line with a peg line distribution for the pegs that are not fully received.

    When the back order line is received and confirmed, a receipt line peg distribution is created for the remaining pegs received.

  • Receipt Corrections

    You can use the Receipt Correction (whinh3121s000) session to change the confirmed received quantity. Increasing the already received quantity leads to a positive receipt correction. The additional received quantity is assigned to the pegs in the same way as the initial receipt.

    1. The pegs having the earliest required date are received first.
    2. The pegs having unfulfilled ordered quantities are received in sequence of peg line.
    3. Any excess on top of the ordered quantity is proportionally assigned to the pegs.

    Decreasing the already received quantity leads to a negative receipt correction.

    When the received quantity is decreased, the change in received quantity is distributed across the received pegs as follows:

    1. Any excess on top of the ordered quantity is decreased proportionally.
    2. The received excess on top of the required quantity, but less than the ordered quantity, is decreased in sequence of the peg line.
    3. Any remaining received quantity is decreased in the sequence of the latest required date.
Inbound procedure - inspection

The Warehouse Inspections (whinh3122m000) session does not have a peg distribution. Registration of inspected/rejected quantities takes place in the peg distribution available under the receipt lines which roll up into the inbound order line peg distribution.

Generally, inventory subject to warehouse inspections remains blocked. Similarly, the project pegged inventory to be inspected remains blocked. After processing the inspection, the planned inventory transactions and the inventory levels are updated accordingly, by peg level.

Approved quantities are assigned first to peg lines having the earliest required date. Rejected or destroyed quantities are assigned first to the peg lines having the latest required dates. In case of excess quantities, the excess quantities must be utilized first. The rejected or destroyed quantities are distributed based on the actual received quantities of the receipt line (not on the total values of the related inbound order line). The updated receipt line peg information is rolled up to the level of the inbound order line peg distribution.

Outbound procedure - inspection

The Warehouse Inspections (whinh3122m000) session does not have a peg distribution. There is also no specific peg distribution related to the outbound advice. Inspected rejected quantities are registered in the Outbound Order Line Peg Distribution (whinh2190m000) session.

Generally, inventory scheduled for outbound inspections remains blocked. Similarly, the project pegged inventory to be inspected remains blocked. After processing the inspection, the planned inventory transactions and the inventory levels are updated accordingly, by peg level.

Update outbound order line pegs

The To be Inspectedin Inventory Unit field in the Outbound Order Line Peg Distribution (whinh2190m000) session includes the advised peg quantity that is already released and is subject to inspection.

The following conditions are applicable to handle the outbound order line pegs during warehouse inspections:

  • For each released outbound advice, an inspection line is created. At this point, the To be Inspectedin Inventory Unit is defined and apportioned to the pegs in sequence of earliest required date.
  • When the advised quantity of the earliest peg is fully assigned as To be Inspectedin Inventory Unit, the remainder of the released quantity is assigned to the To be Inspectedin Inventory Unit of the next peg with the earliest required date and so on.
  • Any approved quantities are assigned to the pegs in sequence of the earliest required date.
  • Any rejected quantities are assigned to the pegs in sequence of latest required date. But in case of over delivery (Advised quantity > Ordered Quantity), the excess must be consumed first in sequence of earliest required date.
  • The To be Inspectedin Inventory Unit of the pegs is blocked for inspection.
  • While processing an inspection record, any approved or rejected quantity is apportioned only to the pegs that have a To be Inspectedin Inventory Unit. This To be Inspectedin Inventory Unit is consumed by the approved and rejected quantities assigned to the peg. Effectively, the blocked quantity is decreased for the quantity processed.

Related topics