AnsweredAssumed Answered

Setting a Status field from a Numeric Field

Question asked by dansan500 on Feb 16, 2011
Latest reply on Feb 17, 2011 by 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

Outcomes