guys, please please assist me. We have a product, that "bolts on" to another product. when producing the sales document, we need to deduct the product from the one and place it to the other sales document for the Bolt-on.

This is the string for report 1, which should be deducting the bolt on...
{v_ReportPolicy.Duration} + ' Months ' + {v_ReportPolicy.PlanType} + ' Warranty at R ' + ToText(toNumber({v_ReportPolicy.TotalCost}) - toNumber({v_ReportPolicy.TyreCost}) - toNumber({v_ReportPolicy.MicrodotPrice}) - tonumber({v_ReportPolicy.SOSCost}))

the result it gives, does not deduct the cents, only the whole units of currency.

is there a way around this? what have i done wrong?

You need a parameter on ALL of your totext functions.
totext(variable,2) will force 2 decimal places
otherwise, it could round that number

12.53 becomes 13
12.47 becomes 12

CORRECTED: originally typed the tonumber but meant totext


Edited by joeg1962 - 15 May 2013 at 4:30am