0 Replies Latest reply: Oct 20, 2017 2:36 PM by Mark Graham RSS

    Peek Help with script

    Mark Graham

      Hello Everyone,

       

      I'm tring to create a logic with the below sample data:

       

      Req O/P: 'Can fill' column

         

      ITEMIncoming DateIncoming_Qty  RequiredCan fill
      110/19/201781    12681
      111/1/2017122   45
      111/1/2017214
      111/9/2017233

       

       

      I have 126 units required.

      i'm getting 81 on one date. So, i can fill only 81 units.

      Now, the rem. quantity is 45. This can be filled with the incoming qty on 11/1/2017.

      Please see attached application.

       

      Any help is highly appreciated.