AnsweredAssumed Answered

Need Help Writing an "If" Statment Please!!!

Question asked by sheuerman on Apr 13, 2010
Latest reply on Apr 13, 2010 by sheuerman

Title

Need Help Writing an "If" Statment Please!!!

Post

I have the statement but my boss asked me to only show outstanding balance's over 45 days. This is what I have so far and it brings up everything that is outstanding be it one day or 100 days.

 

Commit Records/Requests []

If [not IsEmpty( Orders_Orders__Account Number::Acct. No.)]

   Show Custom Dialog ["Payment"; "Customer has Outstanding Balanace!!!!"]

End If

 

 

How do I make it search if the Payment is overdue by 45 days or more? I do have field that show's how many days they are past due called "Days Past Due". Can someone help me with this?


Thanks!

Sandi

Outcomes