Discount Printed Field (no decimals)

[ismet sener]

Hi,
When I try to print a invoice with 12,50 % discount AND select the field Discount printed, I see a invoice with just 12%   and not 12,50% on the invoice.
So the customer will see just 12  and not 12,50 on the invoice.
The amount is calculated right, so that is not the problem. But the discount percentage is printed without decimals.

Could you please help me?

Regards,
Ismet

[ismet sener]

Very strange !!!!
When I login with language = English (UK) I see as date format the UK version dd/MM/yyyy in the SalesOrder/Invoice window

and when I login with language = English (USA) I see as date format the US version MM/dd/yyyy in the SalesOrder/Invoice window

Til now everything seems OK

But But But WHEN I PRINT the invoice:
if the language of the Business Partner = English (UK) I see the date format in UK version dd/MM/yyyy but the discount is :
12.00000000000 (not rounding !!!)

if the language of the Business Partner = English (USA) I see the date format in USA version MM/dd/yyyy but the discount is :
12.00 (ROUNDING is OK)

With SQL I made some changes in
Table: C_Invoice_LineTax_v
Column: Discount (here I changed the reference from Integer to Number)
and in View Column I add the next SQL:
CASE WHEN i.IsDiscountPrinted='Y' AND il.PriceList>il.PriceActual AND il.PriceList<>0 THEN ROUND((il.PriceList-
il.PriceActual)/il.PriceList*100,2) END

In English (USA) it rounds OK, but in English (UK) it rounds WRONG, without taking the SQL formula ROUND in consideration

Please help me,
Ismet