6 Replies Latest reply on Feb 17, 2011 8:38 AM by dansan500

    Setting a Status field from a Numeric Field

    dansan500

      Title

      Setting a Status field from a Numeric Field

      Post

      I need to set a STATUS field to PARTIAL or COMPLETE :

      Field1 = QTY_ORDERED

      Field2 = RECEIVED_QTY

      Field3 = STATUS

      Senerio:

      QTY_ORDERED  has a Qty.of 8

      RECEIVED_QTY has a Qty of 7

      STATUS should then indicate PARTIAL (because the order was incomplete) leaving a balance of 1

      -----------------------------------------------------------------------------------------------------------------

       Now if RECEIVED_QTY has a Qty of 8 STATUS should indicate COMPLETE

      How do I automatically change the status from PARTIAL to COMPLETE when the balance =0

      Status2.jpg