Not shure yet, but I think this problem is related to the variable jos_vm_product_price and its setting in the mysql table.

It is set to the total number of 12 digits (the precision) and the number of 5 digits after the decimal point (the scale).

(Don't know where the rounding to two digits takes place - in MySQL or VM?)

One example from my installation:

If I type a product price (Gross) of 198.00 into the product information form, VM displays 166.38655 (VAT set to 19 percent) for the product price (Net). The last digit (5) is rounded - the numbers behind it are truncated. When I save this price, VM obviously recalculates the Gross price and changes my 198.00 to 197,99999 in the product information form, which is the result of taking the Net product price including its five digits after the decimal point x 1.19.

The 197,9999 has annoyed me for quite a while already although I didn't complain about it yet. Would be nice if I could see 198.00 in the administration product information form some time in the future.

MySQL changed the handling of Decimal Data Types in MySQL 5.03. Maybe this is causing the output described in the first post of this thread.

Joerg

Joomla 1.5.3, VM 1.1