Cost peg transfers in Warehousing

The cost peg transfer functionality enables the transfer of costs between two different pegs, from 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.

When a cost peg transfer is processed, the changes are permanent (when excess inventory is moved). However, the inventory can be transferred back.

The source peg and the target peg can be either unpegged inventory (no project, element and activity filled) or pegged inventory (belonging to a project, element and/ or activity). For a cost peg transfer line, either the source peg or the target peg must be specified. The cost peg transfer also changes the allocations within the inventory - Transfer Allocated (from peg) and Transfer on Order (to peg).

Cost peg transfers can be generated from these sources within LN:

  • Enterprise Planning
  • Outbound Advice
  • Manual
  • Mass Project Cost Peg Transfer
Enterprise Planning

The cost peg transfers are created in Enterprise Planning during the planning runs and can be transferred to Warehousing by the user or by LN. The cost peg transfers are generated to handle shortages, using the Project Pegged Inventory (whwmd2560m000) session, identified during the planning run. When you process the cost peg transfer, the cost is transferred from the source peg to the target peg. Financial transactions are created during the processing of the cost peg transfer.

Outbound Advice

Cost peg transfers can be created to handle shortages when outbound advice is generated. If shortages occur, LN searches for an open cost peg transfer and links it to the outbound advice. The cost peg transfer is processed when the outbound advice is picked, or can be processed manually.

If the shortage is not met, a cost peg transfer is created if excess inventory or available to transfer (ATT) inventory is present for a different peg. The excess inventory and ATT inventory is transferred to the pegs with the inventory shortage.

Manual

LN allows you to manually create cost peg transfers. These are not created by a specific process. You can determine which pegged inventory must be transferred.

Mass Project Cost Peg Transfer

Mass cost peg transfers are created by executing a separate process that allows the user to transfer all excess inventories from a source peg to a target peg.

Processing cost peg transfers

While processing the cost peg transfer, LN:

  1. Checks the inventory level of the source peg. In case of insufficient inventory, the cost peg transfer is not processed.
  2. Moves the quantity of the cost peg transfer from the source peg to the target peg.
  3. Creates financial transactions for the cost peg transfer.

The cost peg transfer can be processed manually or automatically during the picking process. Manual processing can be performed using an option or by a batch session available in all the cost peg transfer sessions.

Changes on the cost peg transfer

LN allows you to modify the cost peg transfer of all origins. In case of insufficient inventory, the cost peg transfers are not processed. The cost peg transfer that is linked to an outbound advice cannot be modified.

In case the cost peg transfer quantity increases, and the excess and ATT inventory of the source peg no longer meets the requirement, LN checks for the inventory available on the source peg. If inventory is available, LN displays a warning message that the transfer includes the goods that are not moved from excess and ATT inventory. In case the inventory is not sufficient, LN displays an error message.

Changes on the outbound advice

If the advised quantity is increased on the outbound advice, the cost peg transfers linked to the outbound advice are also updated (if there is enough inventory), or a new cost peg transfer is created to match the advised quantity.

Example

Increase the advised quantity:

When you change the advised quantity on the outbound advice from 20 to 25:

Cost Peg Transfer Lines (whinh145)
Cost Peg TransferFrom PegTo PegQuantityRequired DateProcessed
TRF000001AAA-01BBB-028 (5+3)11/30/2011No

 

The project pegged inventory:

Project Pegged Inventory (whwmd260)
Pegon orderon HandAllocatedLocation AllocatedAvailable ExcessAvailable to TransferTransfer AllocatedTransfer on order
AAA-010201012 (10+2)2 (5-3)08 (5+3)0
BBB-02051013 (10+3)0008 (5+3)

 

Outbound Advice is updated:

Outbound Advice (whinh225)
Outbound AdviceAdvised Quantity
125 (20+5)

 

The Outbound Order Line Cost Peg Distribution:

Outbound Order Line Cost Peg Distribution (whinh290)
PegOrdered QuantityRequired QuantityNeed DateAdvised Quantity
BBB-02101011/30/201113 (10+3)
AAA-01101012/01/201112 (10+2)

 

Decrease the advised quantity:

When you change the advised quantity from 20 to 14:

The cost peg transfer:

Cost Peg Transfer Lines (whinh145)
Cost Peg TransferFrom PegTo PegQuantityRequired DateProcessed
TRF000001AAA-01BBB-02511/30/2011No

 

The cost peg transfer remains unchanged, because the decrease in advised quantity is removed from the location allocated based on the latest required date.

The project pegged inventory:

Project Pegged Inventory (whwmd260)
PegOn orderOn HandAllocatedLocation AllocatedAvailable ExcessAvailable to TransferTransfer AllocatedTransfer on order
AAA-010201045050
BBB-020510100005

 

Outbound advice is updated:

Outbound Advice (whinh225)
Outbound AdviceAdvised Quantity
114 (20-6)

 

The outbound order line cost peg distribution:

Outbound Order Line Cost Peg Distribution (whinh290)
PegOrdered QuantityRequired QuantityNeed DateAdvised Quantity
BBB-02101011/30/201110
AAA-01101012/01/20114 (10-6)

 

Splitting the cost peg transfer

During the generate outbound advice run, shortages if identified, are met using the existing cost peg transfers. The two scenarios are:

  • Quantity on the cost peg transfer is more than the shortage quantity
  • Quantity on the cost peg transfer is less than the shortage quantity

If the cost peg transfer quantity is more than the shortage quantity, the total cost peg transfer quantity is not utilized. A new cost peg transfer is created (with the same origin) with a quantity equal to the shortage quantity. Therefore, the quantity of the original cost peg transfer is reduced.

If the cost peg transfer quantity is less than the shortage quantity, the cost peg transfer must be updated with the outbound advice. LN checks for other cost peg transfers that can be used to handle the shortage.

Example

Starting point:

Project Pegged Inventory (whwmd260)
PegOn orderOn HandAllocatedLocation AllocatedAvailable ExcessAvailable to TransferTransfer AllocatedTransfer on order
AAA-0102010000100
BBB-020510000010

 

An order is created with this outbound order line cost peg distribution data:

Outbound Order Line Cost Peg Distribution (whinh290)
PegOrdered QuantityRequired QuantityNeed DateAdvised Quantity
AAA-01101011/30/20110
BBB-02101012/01/20114 (10-6)

 

This cost peg transfer is present, origin can be Enterprise Planning, Manual, Mass Cost Peg Transfer:

Cost Peg Transfer Lines (whinh145)
Cost Peg TransferOrder LineFrom PegTo PegQuantityRequired DateProcessed
TRF0000110AAA-01BBB-021012/10/2011No

 

As per the data, there is a shortage of five pieces for the Peg BBB-02 which can be handled with the cost peg transfer TRF000001.

The outbound advice is created with this data:

Cost Peg Transfer Lines (whinh145)
Cost Peg TransferOrder LineFrom PegTo PegQuantityRequired DateProcessed
TRF0000110AAA-01BBB-025 (10-5)12/10/2011No
TRF0000120AAA-01BBB-02512/01/2011No

 

For cost peg transfer line 20 the required date was changed to match the outbound order line cost peg distribution record.

For the cost peg transfer TRF000001, line 20 of the outbound advice is also populated.

Within the inventory table, this data is updated:

Project Pegged Inventory (whwmd260)
PegOn orderOn HandAllocatedLocation AllocatedAvailable ExcessAvailable to TransferTransfer AllocatedTransfer on order
AAA-01020101000100
BBB-0205101000010

 

Only the location allocated is changed, because the cost peg transfer is already present before the outbound advice was created. Splitting the cost peg transfer does not impact the Project Cost Peg Transfer On Order and Project Cost Peg Transfer Allocated quantities in the Project Pegged Inventory (whwmd2560m000) session.