Peg distribution in the outbound process

During the outbound process, issuing project pegged goods from a warehouse result 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.

Generate outbound advice

While generating 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 clears the quantity that must be advised:

Required QuantityAdvised QuantityShipped QuantityNot Shipped QuantityTo be Advised Quantity
10101000 (10 – (10 – 0))
201010010 (20 – (10 – 0))
2020101010 (20 – (20 – 10))
20201000 (20 – (20 – 0))
20201555 (20 – (20 – 5))
202002020 (20 – (20 – 20))

 

With the retrieved To be Advised Quantity, the project pegged inventory search engine is activated. The possible scenarios are:

  • 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)
WarehouseItemInventory on handLocation Allocated QuantityAvailable quantity
WH01item0011000100

 

Project Pegged Inventory (whwmd260)
WarehouseItemProjectElementActivityExtensionCost ComponentInventory on HandLocation Allocated QuantityAvailable quantity
WH01item001proj1elem1acti140040
WH01item001proj2elem2acti240040
WH01item001proj2elem3acti220020

 

Outbound Order Line (whinh220)
Order OriginOrderLineSequenceItemWarehouseOrdered QuantityStatus
SalesSLS000001101item001WH0140Open

 

Outbound Order Line cost peg Distribution (whinh290)
Order OriginOrderLineSequencePeg LineProjectElementActivityOrdered QuantityAdvised QuantityRequired Date
SalesSLS00000110110proj1elem1acti110010/30/2011
SalesSLS00000110120proj2elem2acti220011/1/2011
SalesSLS00000110130proj2elem3acti210010/29/2011

 

In the example, you can see that outbound order line can be advised as the inventory levels are sufficient. This example displays results after an outbound advice is created:

Warehouse - Item Inventory (whwmd215)
WarehouseItemInventory on handLocation Allocated QuantityAvailable quantity
WH01item0011004060

 

Project Pegged Inventory (whwmd260)
WarehouseItemProjectElementActivityExtensionCost ComponentInventory on HandLocation Allocated QuantityAvailable quantity
WH01item001proj1elem1acti1401030
WH01item001proj2elem2acti2402020
WH01item001proj2elem3acti2201010

 

Outbound Order Line (whinh220)
Order OriginOrderLineSequenceItemWarehouseOrdered QuantityStatus
SalesSLS000001101item001WH0140Advised

 

Outbound Advice (whinh225)
Order OriginOrderLineSequenceItemWarehouseAdvised Quantity
SalesSLS000001101item001WH0140

 

Outbound Order Line cost peg Distribution (whinh290)
Order OriginOrderLineSequencePeg LineProjectElementActivityOrdered QuantityAdvised QuantityRequired Date
SalesSLS00000110110proj1elem1acti1101010/30/2011
SalesSLS00000110120proj2elem2acti2202011/1/2011
SalesSLS00000110130proj2elem3acti2101010/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 - overview.

Initial position of the inventory:

Warehouse - Item Inventory (whwmd215)
WarehouseItemInventory on handLocation Allocated QuantityAvailable quantity
WH01item0011006040

 

Project Pegged Inventory (whwmd260)
WarehouseItemProjectElementActivityExtensionCost ComponentInventory on HandLocation Allocated QuantityAvailable quantity
WH01item001proj1elem1acti120020
WH01item001proj2elem2acti210010
WH01item001proj2elem3acti2706010

 

Outbound Order Line (whinh220)
Order OriginOrderLineSequenceItemWarehouseOrdered QuantityStatus
SalesSLS000001101item001WH0140Open

 

Outbound Order Line cost peg Distribution (whinh290)
Order OriginOrderLineSequencePeg LineProjectElementActivityOrdered QuantityAdvised QuantityRequired Date
SalesSLS00000110110proj1elem1acti110010/30/2011
SalesSLS00000110120proj2elem2acti220011/1/2011
SalesSLS00000110130proj2elem3acti210010/29/2011

 

In the example, based on Required Date the 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)
WarehouseItemInventory on handLocation Allocated QuantityAvailable quantity
WH01item0011009010

 

Project Pegged Inventory (whwmd260)
WarehouseItemProjectElementActivityExtensionCost ComponentInventory on HandLocation Allocated QuantityAvailable quantity
WH01item001proj1elem1acti1201010
WH01item001proj2elem2acti210100
WH01item001proj2elem3acti270700

 

Outbound Order Line (whinh220)
Order OriginOrderLineSequenceItemWarehouseOrdered QuantityStatus
SalesSLS000001101item001WH0140Partially Advised

 

Outbound Order Line cost peg Distribution (whinh290)
Order OriginOrderLineSequencePeg LineProjectElementActivityOrdered QuantityAdvised QuantityRequired Date
SalesSLS00000110110proj1elem1acti1101010/30/2011
SalesSLS00000110120proj2elem2acti2201011/1/2011
SalesSLS00000110130proj2elem3acti2101010/29/2011

 

Outbound Advice (whinh225)
Order OriginOrderLineSequenceItemWarehouseAdvised Quantity
SalesSLS000001101item001WH0130

 

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)
WarehouseItemInventory on handLocation Allocated QuantityAvailable quantity
WH01item001502030

 

Project Pegged Inventory (whwmd260)
WarehouseItemProjectElementActivityExtensionCost ComponentInventory on HandLocation Allocated QuantityAvailable quantity
WH01item001proj1elem1acti110010
WH01item001proj2elem2acti2302010
WH01item001proj2elem3acti210010

 

Outbound Order Line (whinh220)
Order OriginOrderLineSequenceItemWarehouseOrdered QuantityStatus
SalesSLS000001101item001WH0140Open

 

Outbound Order Line cost peg Distribution (whinh290)
Order OriginOrderLineSequencePeg LineProjectElementActivityOrdered QuantityAdvised QuantityRequired Date
SalesSLS00000110110proj1elem1acti110010/30/2011
SalesSLS00000110120proj2elem2acti220011/1/2011
SalesSLS00000110130proj2elem3acti210010/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)
WarehouseItemInventory on handLocation Allocated QuantityAvailable quantity
WH01item00150500

 

Project Pegged Inventory (whwmd260)
WarehouseItemProjectElementActivityExtensionCost ComponentInventory on HandLocation Allocated QuantityAvailable quantity
WH01item001proj1elem1acti110100
WH01item001proj2elem2acti230300
WH01item001proj2elem3acti210100

 

Outbound Order Line (whinh220)
Order OriginOrderLineSequenceItemWarehouseOrdered QuantityStatus
SalesSLS000001101item001WH0140Partially Advised

 

Outbound Order Line cost peg Distribution (whinh290)
Order OriginOrderLineSequencePeg LineProjectElementActivityOrdered QuantityAdvised QuantityRequired Date
SalesSLS00000110110proj1elem1acti1101010/30/2011
SalesSLS00000110120proj2elem2acti2201011/1/2011
SalesSLS00000110130proj2elem3acti2101010/29/2011

 

Outbound Advice (whinh225)
Order OriginOrderLineSequenceItemWarehouseAdvised Quantity
SalesSLS000001101item001WH0130

 

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)
WarehouseItemInventory on handLocation Allocated QuantityAvailable quantity
WH01item001502030

 

Project Pegged Inventory (whwmd260)
WarehouseItemProjectElementActivityExtensionCost ComponentInventory on HandLocation Allocated QuantityAvailable quantity
WH01item001proj1elem1acti110010
WH01item001proj2elem2acti2500
WH01item001proj2elem3acti2352015

 

Outbound Order Line (whinh220)
Order OriginOrderLineSequenceItemWarehouseOrdered QuantityStatus
SalesSLS000001101item001WH0140Open

 

Outbound Order Line cost peg Distribution (whinh290)
Order OriginOrderLineSequencePeg LineProjectElementActivityOrdered QuantityAdvised QuantityRequired Date
SalesSLS00000110110proj1elem1acti110010/30/2011
SalesSLS00000110120proj2elem2acti220011/1/2011
SalesSLS00000110130proj2elem3acti210010/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)
WarehouseItemInventory on handLocation Allocated QuantityAvailable quantity
WH01item00150455

 

Project Pegged Inventory (whwmd260)
WarehouseItemProjectElementActivityExtensionCost ComponentInventory on HandLocation Allocated QuantityAvailable quantity
WH01item001proj1elem1acti110100
WH01item001proj2elem2acti2550
WH01item001proj2elem3acti235305

 

Outbound Order Line (whinh220)
Order OriginOrderLineSequenceItemWarehouseOrdered QuantityStatus
SalesSLS000001101item001WH0140Partially Advised

 

Outbound Order Line cost peg Distribution (whinh290)
Order OriginOrderLineSequencePeg LineProjectElementActivityOrdered QuantityAdvised QuantityRequired Date
SalesSLS00000110110proj1elem1acti1101010/30/2011
SalesSLS00000110120proj2elem2acti220511/1/2011
SalesSLS00000110130proj2elem3acti2101010/29/2011

 

Outbound Advice (whinh225)
Order OriginOrderLineSequenceItemWarehouseAdvised Quantity
SalesSLS000001101item001WH0125

 

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)
WarehouseItemInventory on handLocation Allocated QuantityAvailable quantity
WH01item00150500

 

Project Pegged Inventory (whwmd260)
WarehouseItemProjectElementActivityExtensionCost ComponentInventory on HandLocation Allocated QuantityAvailable quantity
WH01item001proj1elem1acti110010020200
WH01item001proj2elem2acti210010030300

 

Outbound Order Line (whinh220)
Order OriginOrderLineSequenceItemWarehouseOrdered QuantityStatus
SalesSLS000001101item001WH0150Advised

 

Outbound Order Line cost peg Distribution (whinh290)
Order OriginOrderLineSequencePeg LineProjectElementActivityOrdered QuantityAdvised QuantityRequired Date
SalesSLS00000110110proj1elem1acti1202010/30/2011
SalesSLS00000110120proj2elem2acti2303011/1/2011

 

Outbound Advice (whinh225)
Order OriginOrderLineSequenceItemWarehouseAdvised Quantity
SalesSLS000001101item001WH0150

 

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

Warehouse - Item Inventory (whwmd215)
WarehouseItemInventory on handLocation Allocated QuantityAvailable quantity
WH01item00150455

 

Outbound Advice (whinh225)
Order OriginOrderLineSequenceItemWarehouseAdvised Quantity
SalesSLS000001101item001WH0160

 

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)
WarehouseItemInventory on handLocation Allocated QuantityAvailable quantity
WH01item00150500

 

Project Pegged Inventory (whwmd260)
WarehouseItemProjectElementActivityExtensionCost ComponentInventory on HandLocation Allocated QuantityAvailable quantity
WH01item001proj1elem1acti120200
WH01item001proj2elem2acti210100
WH01item001proj2elem3acti220200

 

Outbound Order Line (whinh220)
Order OriginOrderLineSequenceItemWarehouseOrdered QuantityStatus
SalesSLS000001101item001WH0150Open

 

Outbound Advice (whinh225)
Order OriginOrderLineSequenceItemWarehouseAdvised Quantity
SalesSLS000001101item001WH0150

 

Outbound Order Line cost peg Distribution (whinh290)
Order OriginOrderLineSequencePeg LineProjectElementActivityOrdered QuantityAdvised QuantityRequired Date
SalesSLS00000110110proj1elem1acti1202010/30/2011
SalesSLS00000110120proj2elem2acti2101011/1/2011
SalesSLS00000110130proj2elem3acti2202010/29/2011

 

For this situation the following shipment lines are created:

Shipment Lines (whinh431)
ShipmentShipment LineOrder OriginOrderLineSequenceItemShipped Quantity
SHIP0000110SalesSLS000001101item00130
SHIP0000210SalesSLS000001101item00120

 

Shipment Lines (whinh428)
ShipmentShipment LinePeg LineProjectElementActivityRequired DateShipped Quantity
SHIP000011010proj1elem1acti110/30/201110
SHIP000011030proj2elem2acti110/29/201120

 

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 OriginOrderLineSequencePeg LineProjectElementActivityOrdered QuantityAdvised QuantityRequired DateShipped Quantity
SalesSLS00000110110proj1elem1acti1202010/30/201110
SalesSLS00000110120proj2elem2acti2101011/1/20110
SalesSLS00000110130proj2elem3acti2202010/29/201120

 

Under and over deliveries

For under deliveries, the quantity not delivered must be distributed on the peg distribution, beginning with the peg line with the latest Required Date. For over deliveries, the quantity over delivery must be distributed evenly 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 (for example, buy-from business partner); 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

The cost peg transfers functionality is introduced that enables transfer of cost between two different pegs (pegged to unpegged and vice versa). The cost peg transfers do not physically move the inventory but only transfer the cost 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 - overview

Transfer (manual) orders/ Transfer orders

LN allows you to use inbound and outbound cost peg distribution to enter 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 sales order/ sales 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