Negative number displayed as a positive

[Tinkypot]

We are a non profit and we have a conference coming up in another country who requires a VAT which is a tax in that country. The way they want it displayed on our invoices is to have the total of the invoice on one line then the VAT amount on the next line then a total of the Invoice. We are using the discount as a negative amount which adds to the line item on invoice data entry but it is displaying as a negative number on the invoice. I am not sure what the formula should be to change this to a positive number. This is what I have but it is still showing up as a negative number. if {SO_InvoiceWrk.DiscountAmt}<0.00 THEN {SO_InvoiceWrk.DiscountAmt}*-1. Can anyone help with this problem. We had thought of setting up a tax but we are a non profit and we do not charge taxes.

 

[pmax9999]

I don't see any reason why your formula would not work although if I understand correctly the sign (+ or -) on the Discount field would always need to be reversed so could be simplified to:

- {SO_InvoiceWrk.DiscountAmt}

Are you sure you have replaced the {SO_InvoiceWrk.DiscountAmt} field on the report with the Formula?

Pete

 

[IanWaterman]

If its for display purposes only, just go to number format. Select customise and check reverse indicator for display

Ian

 

[pmax9999]

Ian's suggestion is, of course, the simplest and the best.

Cheers
pete

 

[Tinkypot]

Thanks so much for all of your help.