+ Start a Discussion
Navneeth RajNavneeth Raj 

Formula for an INVOICE

How to write a formula for an Invoice field, so that IF YOU SELECT INVOICE STATUS AS OPEN & SAVED IT THEN IT HAS TO BE SAVED AS SAY For Example  "INV-{0001} OPEN". So, that if you select Invoice from lookup from line item you come to know the status of it whether it is OPEN or CLOSED or anything by viewing it.
ManojjenaManojjena
Hi Navneeth,

You can do one thing if you have any auto number to diaplay with format liek INV-{001},If not then create an auto number field with format like as you expected .Then create a formula which wil simple addition of autonumber and Status field which will solve your problem .

Let me know if it helps .

Thanks 
Manoj