Peg distribution in the outbound process

During the outbound process, issuing project pegged goods from a warehouse results in inventory transactions that are based on the peg distribution.

During the outbound advice and during inspections, the outbound order line cost peg distribution is updated with the advised quantities, approved quantities and the rejected quantities. When the goods arrive at the staging location and are shipped, the actual pegs are created. During the confirmation process, the shipment line peg distribution is created.

Generating outbound advice

While generating an outbound advice for a pegged outbound order line, additional inventory checks are performed to determine the pegged inventory that must be advised. LN first searches for the available stock points. If the stock point is identified, the outbound order line cost peg distribution is advised based on the available quantity at the stock point and the available quantity in the project pegged inventory. The peg distribution is based on the earliest required date.

When determining the quantity that must be advised for each separate peg line, this calculation is performed before searching for the project pegged inventory:

Quantity to be advised = Required Quantity - Advised Quantity - Rejected Quantity
 - Shipped Quantity - Not Shipped Quantity - Expected Not Shipped Quantity
Quantity to be advised = Minimum (To be distributed (Stock point Quantity), To be Advised )

This table explains the quantity that must be advised:

Required Quantity Advised Quantity Shipped Quantity Not Shipped Quantity To be Advised Quantity
10 10 10 0 0 (10 – (10 – 0))
20 10 10 0 10 (20 – (10 – 0))
20 20 10 10 10 (20 – (20 – 10))
20 20 10 0 0 (20 – (20 – 0))
20 20 15 5 5 (20 – (20 – 5))
20 20 0 20 20 (20 – (20 – 20))

After the to be advised quantity is retrieved, the project pegged inventory search engine is activated.

These scenarios exist:

  • No shortages, full advise
  • Shortage on project pegged inventory
  • Shortage on stock point inventory

    • Part that can be advised has no shortage in project pegged inventory
    • Part that can be advised has a shortage in project pegged inventory

No shortages, full advise

Initial position of the inventory:

Warehouse - Item Inventory (whwmd215)
Warehouse Item Inventory on hand Location Allocated Quantity Available Quantity
WH01 item001 100 0 100
Project Pegged Inventory (whwmd260)
Warehouse Item Project Element Activity Extension Cost Component Inventory on Hand Location Allocated Quantity Available Quantity
WH01 item001 proj1 elem1 acti1     40 0 40
WH01 item001 proj2 elem2 acti2     40 0 40
WH01 item001 proj2 elem3 acti2     20 0 20
Outbound Order Line (whinh220)
Order Origin Order Line Sequence Item Warehouse Ordered Quantity Status
Sales SLS000001 10 1 item001 WH01 40 Open
Outbound Order Line cost peg Distribution (whinh290)
Order Origin Order Line Sequence Peg Line Project Element Activity Ordered Quantity Advised Quantity Required Date
Sales SLS000001 10 1 10 proj1 elem1 acti1 10 0 10/30/2011
Sales SLS000001 10 1 20 proj2 elem2 acti2 20 0 11/1/2011
Sales SLS000001 10 1 30 proj2 elem3 acti2 10 0 10/29/2011

In the example, you can see that the outbound order line can be advised because the inventory levels are sufficient.

This example displays results after an outbound advice is created:

Warehouse - Item Inventory (whwmd215)
Warehouse Item Inventory on hand Location Allocated Quantity Available Quantity
WH01 item001 100 40 60
Project Pegged Inventory (whwmd260)
Warehouse Item Project Element Activity Extension Cost Component Inventory on Hand Location Allocated Quantity Available Quantity
WH01 item001 proj1 elem1 acti1     40 10 30
WH01 item001 proj2 elem2 acti2     40 20 20
WH01 item001 proj2 elem3 acti2     20 10 10
Outbound Order Line (whinh220)
Order Origin Order Line Sequence Item Warehouse Ordered Quantity Status
Sales SLS000001 10 1 item001 WH01 40 Advised
Outbound Advice (whinh225)
Order Origin Order Line Sequence Item Warehouse Advised Quantity
Sales SLS000001 10 1 item001 WH01 40
Outbound Order Line Cost Peg Distribution (whinh290)
Order Origin Order Line Sequence Peg Line Project Element Activity Ordered Quantity Advised Quantity Required Date
Sales SLS000001 10 1 10 proj1 elem1 acti1 10 10 10/30/2011
Sales SLS000001 10 1 20 proj2 elem2 acti2 20 20 11/1/2011
Sales SLS000001 10 1 30 proj2 elem3 acti2 10 10 10/29/2011
Note: Only one outbound advice is created. The outbound order line cost peg distribution is updated with the advised quantity for each peg.

Shortage on project pegged inventory

The cost peg transfer functionality enables you to track the shortages in project pegged inventory. For more information, refer to Cost peg transfers in Warehousing.

Initial position of the inventory:

Warehouse - Item Inventory (whwmd215)
Warehouse Item Inventory on hand Location Allocated Quantity Available Quantity
WH01 item001 100 60 40
Project Pegged Inventory (whwmd260)
Warehouse Item Project Element Activity Extension Cost Component Inventory on Hand Location Allocated Quantity Available Quantity
WH01 item001 proj1 elem1 acti1     20 0 20
WH01 item001 proj2 elem2 acti2     10 0 10
WH01 item001 proj2 elem3 acti2     70 60 10
Outbound Order Line (whinh220)
Order Origin Order Line Sequence Item Warehouse Ordered Quantity Status
Sales SLS000001 10 1 item001 WH01 40 Open
Outbound Order Line Cost Peg Distribution (whinh290)
Order Origin Order Line Sequence Peg Line Project Element Activity Ordered Quantity Advised Quantity Required Date
Sales SLS000001 10 1 10 proj1 elem1 acti1 10 0 10/30/2011
Sales SLS000001 10 1 20 proj2 elem2 acti2 20 0 11/1/2011
Sales SLS000001 10 1 30 proj2 elem3 acti2 10 0 10/29/2011

In the example, peg line 20 has a higher priority, because the required date is earlier.

The resulting inventory after the outbound advice is created (without the use of transfer logic) is listed in these tables:

Warehouse - Item Inventory (whwmd215)
Warehouse Item Inventory on hand Location Allocated Quantity Available quantity
WH01 item001 100 90 10
Project Pegged Inventory (whwmd260)
Warehouse Item Project Element Activity Extension Cost Component Inventory on Hand Location Allocated Quantity Available Quantity
WH01 item001 proj1 elem1 acti1     20 10 10
WH01 item001 proj2 elem2 acti2     10 10 0
WH01 item001 proj2 elem3 acti2     70 70 0
Outbound Order Line (whinh220)
Order Origin Order Line Sequence Item Warehouse Ordered Quantity Status
Sales SLS000001 10 1 item001 WH01 40 Partially Advised
Outbound Order Line Cost Peg Distribution (whinh290)
Order Origin Order Line Sequence Peg Line Project Element Activity Ordered Quantity Advised Quantity Required Date
Sales SLS000001 10 1 10 proj1 elem1 acti1 10 10 10/30/2011
Sales SLS000001 10 1 20 proj2 elem2 acti2 20 10 11/1/2011
Sales SLS000001 10 1 30 proj2 elem3 acti2 10 10 10/29/2011
Outbound Advice (whinh225)
Order Origin Order Line Sequence Item Warehouse Advised Quantity
Sales SLS000001 10 1 item001 WH01 30

Shortage on stock point inventory

The possible scenarios for stock point inventory shortage:

The part that can be advised has no shortage in the project pegged inventory

In this example, there is not enough inventory available. However, the part of the inventory that can be advised must also be handled.

Initial position of the inventory:

Warehouse - Item Inventory (whwmd215)
Warehouse Item Inventory on hand Location Allocated Quantity Available quantity
WH01 item001 50 20 30
Project Pegged Inventory (whwmd260)
Warehouse Item Project Element Activity Extension Cost Component Inventory on Hand Location Allocated Quantity Available quantity
WH01 item001 proj1 elem1 acti1     10 0 10
WH01 item001 proj2 elem2 acti2     30 20 10
WH01 item001 proj2 elem3 acti2     10 0 10
Outbound Order Line (whinh220)
Order Origin Order Line Sequence Item Warehouse Ordered Quantity Status
Sales SLS000001 10 1 item001 WH01 40 Open
Outbound Order Line cost peg Distribution (whinh290)
Order Origin Order Line Sequence Peg Line Project Element Activity Ordered Quantity Advised Quantity Required Date
Sales SLS000001 10 1 10 proj1 elem1 acti1 10 0 10/30/2011
Sales SLS000001 10 1 20 proj2 elem2 acti2 20 0 11/1/2011
Sales SLS000001 10 1 30 proj2 elem3 acti2 10 0 10/29/2011

A shortage of 10 pieces is present on the inventory level. The advice can be created only for the available pegged inventory. LN generates a message for shortage and an outbound advice of the available inventory is created. Following is the resulting inventory after the outbound advice is generated:

Warehouse - Item Inventory (whwmd215)
Warehouse Item Inventory on hand Location Allocated Quantity Available quantity
WH01 item001 50 50 0
Project Pegged Inventory (whwmd260)
Warehouse Item Project Element Activity Extension Cost Component Inventory on Hand Location Allocated Quantity Available quantity
WH01 item001 proj1 elem1 acti1     10 10 0
WH01 item001 proj2 elem2 acti2     30 30 0
WH01 item001 proj2 elem3 acti2     10 10 0
Outbound Order Line (whinh220)
Order Origin Order Line Sequence Item Warehouse Ordered Quantity Status
Sales SLS000001 10 1 item001 WH01 40 Partially Advised
Outbound Order Line cost peg Distribution (whinh290)
Order Origin Order Line Sequence Peg Line Project Element Activity Ordered Quantity Advised Quantity Required Date
Sales SLS000001 10 1 10 proj1 elem1 acti1 10 10 10/30/2011
Sales SLS000001 10 1 20 proj2 elem2 acti2 20 10 11/1/2011
Sales SLS000001 10 1 30 proj2 elem3 acti2 10 10 10/29/2011
Outbound Advice (whinh225)
Order Origin Order Line Sequence Item Warehouse Advised Quantity
Sales SLS000001 10 1 item001 WH01 30

The part that can be advised has a shortage in the project pegged inventory

There is a shortage in the project pegged inventory.

Initial position of the inventory:

Warehouse - Item Inventory (whwmd215)
Warehouse Item Inventory on hand Location Allocated Quantity Available quantity
WH01 item001 50 20 30
Project Pegged Inventory (whwmd260)
Warehouse Item Project Element Activity Extension Cost Component Inventory on Hand Location Allocated Quantity Available quantity
WH01 item001 proj1 elem1 acti1     10 0 10
WH01 item001 proj2 elem2 acti2     5 0 0
WH01 item001 proj2 elem3 acti2     35 20 15
Outbound Order Line (whinh220)
Order Origin Order Line Sequence Item Warehouse Ordered Quantity Status
Sales SLS000001 10 1 item001 WH01 40 Open
Outbound Order Line cost peg Distribution (whinh290)
Order Origin Order Line Sequence Peg Line Project Element Activity Ordered Quantity Advised Quantity Required Date
Sales SLS000001 10 1 10 proj1 elem1 acti1 10 0 10/30/2011
Sales SLS000001 10 1 20 proj2 elem2 acti2 20 0 11/1/2011
Sales SLS000001 10 1 30 proj2 elem3 acti2 10 0 10/29/2011

There is a shortage of 10 pieces on the inventory level. In the part that can be advised, a shortage of 5 pieces is also identified on the project pegged inventory. In this situation, LN determines that 30 pieces can be advised. However, an additional shortage of 5 pieces is identified. Hence, only 25 pieces are available to be advised. The resulting inventory is explained in these examples:

Warehouse - Item Inventory (whwmd215)
Warehouse Item Inventory on hand Location Allocated Quantity Available quantity
WH01 item001 50 45 5
Project Pegged Inventory (whwmd260)
Warehouse Item Project Element Activity Extension Cost Component Inventory on Hand Location Allocated Quantity Available Quantity
WH01 item001 proj1 elem1 acti1     10 10 0
WH01 item001 proj2 elem2 acti2     5 5 0
WH01 item001 proj2 elem3 acti2     35 30 5
Outbound Order Line (whinh220)
Order Origin Order Line Sequence Item Warehouse Ordered Quantity Status
Sales SLS000001 10 1 item001 WH01 40 Partially Advised
Outbound Order Line cost peg Distribution (whinh290)
Order Origin Order Line Sequence Peg Line Project Element Activity Ordered Quantity Advised Quantity Required Date
Sales SLS000001 10 1 10 proj1 elem1 acti1 10 10 10/30/2011
Sales SLS000001 10 1 20 proj2 elem2 acti2 20 5 11/1/2011
Sales SLS000001 10 1 30 proj2 elem3 acti2 10 10 10/29/2011
Outbound Advice (whinh225)
Order Origin Order Line Sequence Item Warehouse Advised Quantity
Sales SLS000001 10 1 item001 WH01 25

Create outbound advice despite inventory shortage

LN does not allow you to generate an outbound advice with an advised quantity higher than the total advised quantities of the related outbound order line cost peg distribution.

Outbound advice ownership

LN automatically generates the outbound advice ownership when the outbound advice is created if the outbound line is project pegged. LN does not allow you to change the ownership distribution for the project pegged order lines. The ownership distribution is based on the issue ownership set on the outbound order line.

LN does not allow you to generate ownership distribution or insert, modify, delete records for pegged outbound order lines in the Outbound Advice Ownership (whinh4128m000) session.

Inventory search engine

Inventory selection during the process of generating an outbound advice must be changed to support the project pegged inventory. When demand for a pegged item is advised, the process takes care of these peg distribution lines. So, the inventory search engine logic is extended to support the project pegged inventory.

The initial point of these steps is that the inventory on item warehouse level is found. The search sequence for inventory:

  • Search for available inventory with the required peg.
  • Search for available cost peg transfer orders (cost peg transfer orders created by Enterprise Planning or manually entered).
  • Search for available excess.
  • Search for available to transfer (non-excess inventory).
  • Unpegged inventory.
  • Alternative Items.

Manual outbound advice

For a manually created outbound advice, when there is insufficient inventory to allocate for the manually entered advised quantity, LN displays an error message. The cost peg transfer logic is also executed.

Manual changes on outbound advice

When you modify the outbound advice quantity, LN updates the advised quantity on the underlying peg distribution.

In case of a decrease in the quantity, a peg redistribution is initiated. The decrease in advised quantity must be based on the latest required date. For example:

Warehouse - Item Inventory (whwmd215)
Warehouse Item Inventory on hand Location Allocated Quantity Available quantity
WH01 item001 50 50 0
Project Pegged Inventory (whwmd260)
Warehouse Item Project Element Activity Extension Cost Component Inventory on Hand Location Allocated Quantity Available Quantity
WH01 item001 proj1 elem1 acti1 100 100 20 20 0
WH01 item001 proj2 elem2 acti2 100 100 30 30 0
Outbound Order Line (whinh220)
Order Origin Order Line Sequence Item Warehouse Ordered Quantity Status
Sales SLS000001 10 1 item001 WH01 50 Advised
Outbound Order Line cost peg Distribution (whinh290)
Order Origin Order Line Sequence Peg Line Project Element Activity Ordered Quantity Advised Quantity Required Date
Sales SLS000001 10 1 10 proj1 elem1 acti1 20 20 10/30/2011
Sales SLS000001 10 1 20 proj2 elem2 acti2 30 30 11/1/2011
Outbound Advice (whinh225)
Order Origin Order Line Sequence Item Warehouse Advised Quantity
Sales SLS000001 10 1 item001 WH01 50

When you change the advised quantity to 45, the following is the result:

Warehouse - Item Inventory (whwmd215)
Warehouse Item Inventory on hand Location Allocated Quantity Available quantity
WH01 item001 50 45 5
Outbound Advice (whinh225)
Order Origin Order Line Sequence Item Warehouse Advised Quantity
Sales SLS000001 10 1 item001 WH01 60

Undo outbound advice

When an advice is removed, the advised quantity on the deleted outbound advice line must be removed from the outbound order line cost peg distribution.

Process pick

When the user processes the picking list, LN also processes the pending cost peg transfers for the outbound advice that is picked.

Outbound advice for returns

Advising is done based on the latest required date; the pegs with the latest required date are advised first.

Creation of shipment line cost peg distribution

When the shipment lines are confirmed, the shipment line cost peg distribution is created for shipment lines related to an outbound order line that is pegged. The shipped quantities are distributed over the pegs for the shipment lines. The distribution is explained in these examples:

Warehouse - Item Inventory (whwmd215)
Warehouse Item Inventory on hand Location Allocated Quantity Available quantity
WH01 item001 50 50 0
Project Pegged Inventory (whwmd260)
Warehouse Item Project Element Activity Extension Cost Component Inventory on Hand Location Allocated Quantity Available Quantity
WH01 item001 proj1 elem1 acti1     20 20 0
WH01 item001 proj2 elem2 acti2     10 10 0
WH01 item001 proj2 elem3 acti2     20 20 0
Outbound Order Line (whinh220)
Order Origin Order Line Sequence Item Warehouse Ordered Quantity Status
Sales SLS000001 10 1 item001 WH01 50 Open
Outbound Advice (whinh225)
Order Origin Order Line Sequence Item Warehouse Advised Quantity
Sales SLS000001 10 1 item001 WH01 50
Outbound Order Line cost peg Distribution (whinh290)
Order Origin Order Line Sequence Peg Line Project Element Activity Ordered Quantity Advised Quantity Required Date
Sales SLS000001 10 1 10 proj1 elem1 acti1 20 20 10/30/2011
Sales SLS000001 10 1 20 proj2 elem2 acti2 10 10 11/1/2011
Sales SLS000001 10 1 30 proj2 elem3 acti2 20 20 10/29/2011

For this situation the following shipment lines are created:

Shipment Lines (whinh431)
Shipment Shipment Line Order Origin Order Line Sequence Item Shipped Quantity
SHIP00001 10 Sales SLS000001 10 1 item001 30
SHIP00002 10 Sales SLS000001 10 1 item001 20
Shipment Lines (whinh428)
Shipment Shipment Line Peg Line Project Element Activity Required Date Shipped Quantity
SHIP00001 10 10 proj1 elem1 acti1 10/30/2011 10
SHIP00001 10 30 proj2 elem2 acti1 10/29/2011 20

When the shipment is confirmed, the shipped quantity is updated on the outbound order line cost peg distribution

Outbound Order Line cost peg Distribution (whinh290)
Order Origin Order Line Sequence Peg Line Project Element Activity Ordered Quantity Advised Quantity Required Date Shipped Quantity
Sales SLS000001 10 1 10 proj1 elem1 acti1 20 20 10/30/2011 10
Sales SLS000001 10 1 20 proj2 elem2 acti2 10 10 11/1/2011 0
Sales SLS000001 10 1 30 proj2 elem3 acti2 20 20 10/29/2011 20

Underdeliveries and overdeliveries

For underdeliveries, the quantity not delivered must be distributed on the peg distribution, beginning with the peg line with the latest required date. For overdeliveries, the quantity overdelivered must be distributed equally over the available peg lines for the outbound order line.

Not shipped quantities

The peg line distribution data is transferred to the transfer order / adjustment order only if a not-shipped quantity exists on peg distribution. During the confirmation process the not-shipped quantity is updated on the outbound order line cost peg distribution and the shipment line cost peg distribution.

Shipments for returns

When the items are not shipped to the destination, but are shipped back to the origin, a reverse required date priority is applied when generating the shipment line cost peg distribution during the confirmation of the return shipment line. As item inventory is decreased, LN changes the pegged inventory with the latest required dates.

Cost peg transfers

Cost peg transfers enable transfer of costs between two different pegs (pegged to unpegged and vice versa). The cost peg transfers do not physically move the inventory but only transfer the costs of the inventory. Cost peg transfers are performed within the same warehouse. It is not possible to transfer the goods across warehouses. For more information, refer to Cost peg transfers in Warehousing

Transfer (manual) orders / Transfer orders

LN allows you to use an inbound and outbound cost peg distribution to specify transfer manual orders to transfer actual goods between warehouses. LN generates the outbound order line cost peg distribution based on the project pegged inventory. The cost peg distribution can also be created manually and transferred to the inbound line cost peg distribution.

Change warehouse order at a later stage

LN allows you to modify the outbound warehousing order data related to the sales order/schedule. The data can be modified for warehousing orders of all origins. You can also define up to which outbound procedure step the data can be modified. For more information, refer to To modify the outbound warehousing order data.

Additional costs on shipment header/line

When the cost item that is mandatory pegged is added as additional cost to the shipment, the cost item is not displayed because LN cannot decipher which pegs must be added to the additional cost line.

When the cost item that is mandatory pegged is added as additional costs on the shipment line, or when the parent shipment line has a peg distribution, LN copies the peg distribution data to the additional cost line. The cost peg distribution of this additional cost line is transferred to the sales cost order. For more information, refer to Additional costs - shipment based