AnsweredAssumed Answered

Stumped by Weird Calculation Results

Question asked by projay on May 17, 2011
Latest reply on May 19, 2011 by 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

Outcomes