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!

Need a formula

Status
Not open for further replies.

GRECONCG

Technical User
Oct 8, 2009
31
US
I need a formula to do this:

If invoice total is negative don't show payment applied or invoice balance.

How would I do this?
 
I think you need to provide more info,also show a sample of what you would like the display to look like.

 
I have a credit memo and the invoice total shows a negative number, I want to get rid of the payment applied which is a positive number and invoice balance which is 0 (because the positive number and negative number made the balance 0)
I would really like for it to say CREDIT ON FILE if the payment applied comes out to a positive numnber. Right now I have my payment applied formulas as:

IF {INVOICE.TRANS_TYPE}='R' and {INVOICE.POSTADJ}>0 then {INVOICE.POSTADJ} else {INVOICE.REMITTED}

so that is showing a positive number because of the return and an invoice balance of 0 since the - and + = 0.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top