Hi hilmar
>Things can get complicated if you need different formulae for each line. But perhaps you can use the same formulae for each line.
Okay
>Well, it might be something like:
>
>Line1: InvoiceTotal * 10%
>Line2: InvoiceTotal * 15%
>Line3: Accumulated(2) * 12%
>Line4: Line(2) * 3%
>
>Before applying eval(), you would replace "%" with "/100". Other replacements might be required, as well.
Okay
>Line(2) means the amount calculated in the formula in Line2. Accumulated(2) might be the entire amount, of invoice plus taxes up to Line2.
Okay this can be a udf, I guess.
>This might also be applied throught the entire system - the same number of decimals in every case. Better consult with your users, or the accounting department: 1) What is the standard requirement, 2) How likely it is that there will be exceptions.
Actually this will vary between clients and even sister concerns will have differences. Also like I had mentioned previously my clients to whom they are supplying will also dictate the rounding and stuff. So X Ltd. will want rounding here and not there and Z Ltd. will want rounding everywhere. Big Fish , small fish thing <g>. These guys can't tell their IT dept. anything but will want the smaller developers to cater to their whims <g>. I know this sounds like ranting, maybe I am <g>. But out of all the experience till date I have learnt to KIFS (keep it flexible stupid) <g>.