Need a calculation to show order status

[Rangoon]

I want to automate a function to show the proper order status. I use FM 5.5

[aklodner]

Create a calculated field to display the status using the following:

Case(not IsEmpty(payment date), "Paid", not IsEmpty(invoice date), "Invoiced", not isempty(order date), "Ordered", "")

Make sure you set result to Text. Hope this helps.

[Rangoon]

That worked great. Thanks for the help!