7 Replies Latest reply on May 19, 2011 8:36 PM by projay

    Stumped by Weird Calculation Results

    projay

      Title

      Stumped by Weird Calculation Results

      Post

      I just had something very weird happen that I just can't seem to figure out. 
      Here is the situation: After I receive payment for a invoice...that invoice has a "0" balance due and it is also marked as "closed" 

      Paidstatus=
      If (cBalanceDue = 0 and order_open_closed="closed" ;"PAID" ;"" )

      And when that happens I have filled that is displayed across the invoice that says "Paid"...So here is the deal it has so far worked perfectly on all invoices except for one...why it doesn't work on this one I have no idea, it just simply doesn't make sense.  So far I have recreated the invoice and the results are the same...HELP...any suggestions.

      -Jay