Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Edit formula to give option

Status
Not open for further replies.

GRECONCG

Technical User
Oct 8, 2009
31
US
Hi I have this formula:

if {INVOICE.INV_TOTAL}<0 then "CREDIT ON FILE"

Is there a way I can give my bookkeeper the option to have this print or not? I don't want it to print on all the credits since some are adjustments. If so how would I do that?
 
Hi,
Is there something in the data that indicates the status as an adjustment?
If so then:
Code:
If ({Table.StatusCode} <> 'Adjustment' and {INVOICE.INV_TOTAL} < 0 )
  then "CREDIT ON FILE"


[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
No there is nothing in the data it is just some credits are actually owed to the customer and others are a credit because of an error that it was billed to the wrong custmer so we have to do a credit to get it off that account and they want proof we did it. I was thinking there was a way to use a parameter that asked Print Credit on File and we could select true or false. Basically I kjust want the choice to print that phrase (Credit on File) or not, Can that be done?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top