2 Replies Latest reply: Apr 5, 2013 4:50 AM by SIVASUBRAMANIAN KNK RSS

    Production Vs Manufacturing Issue

    SIVASUBRAMANIAN KNK

      Hi all,

      I have a "HL" type code in Production table

      and "S"type code in Manufacturing table

      Both Prod and MFG is linked by ItemCodekey(ItemCode&'-'&Year&'-'&Month)

       

      Production:

      ItemCodeProductionQty
      WNU012H268542
      WNU012L27517
      VNU012H21780
      VNU012L20764

       

      Manufacturing:

      ItemCodeManufacturing Qty
      WNU012S28063
      VNU012S21511

       

      Most important is I need to split the Item Code in MFG table

      WNU012S as WNU012H and WNU012L

      Similarly,VNU012S as VNU012H and VNU012L and both H and L should get the same value of S

      and my final table should look like this

       

      ItemCode
      ProductionQty
      Manufacturing Qty
      To be Packed
      WNU012H2684228063-1221
      WNU012L2751728063-546
      VNU012H2178021511269
      VNU012L2076421511-747

      FYI: To be Packed= ProdQty-MFGQty

       

      With Kind Regards,

      Shiva