1 Reply Latest reply: Jan 5, 2013 11:01 AM by Gysbert Wassenaar RSS

    Inventory Allocation

      Hi all,

       

      I am looking for a best practice to allocate available inventory from a plant-inventory table to a set of orders, which will need to be prioritized by the scheduled date of the order. It will only fill the order in the column "Available Qty" if the remaining inventory can fill the entire order.

       

      Example Table of Inventory:

       

       

      Material
      Plant
      Inventory
      100-1A1,000
      100-1B10,000
      500-2A500
      500-2B0

       

      Table of Orders:

      Order Number
      Material
      Plant
      Order Qty
      Delivery Date
      1100-1A1,0001/5/2013
      2100-1A5,0001/7/2013
      3500-2A101/10/2013
      4100-1B20,0002/1/2013

       

      Final Expected ResultOrder

       

      Order Number
      Material
      Plant
      Order Qty
      Available Qty
      Delivery Date
      1100-1A1,0001,0001/5/2013
      2100-1A5,00001/7/2013
      3500-2A10101/10/2013
      4100-1B20,00002/1/2013

       

      Number

      Order Number
      Order Number