### Author Topic: Problem rounding Product Price (Gross)  (Read 807 times)

#### k2bmedia

• Beginner
• Posts: 3
##### Problem rounding Product Price (Gross)
« on: July 08, 2011, 04:57:58 AM »
Hello.

I'm using;

Joola 1.5.22
VirtueMart 1.1.8

And I have a major problem.

We sel business to business products, so we carry in product prices exclude VAT.

In the order, the price including VAT is charged.

Now the problem;

The Product Price (Gross) is rounded with 2 decimals. For example I have a product with Product Price (Net) of 8.99000 the Product Price (Gross) will be displayed 10.70 (including 19% vat) but should be 10.6981.

Where can I change the value to the same 5 decimals as the Product Price (Net)?

I hope anyone can help me

#### lipes

• Sr. Member
• Posts: 726
##### Re: Problem rounding Product Price (Gross)
« Reply #1 on: August 26, 2011, 19:57:28 PM »
maybe its better to try some change in jos_vm_product_price on phpmyadmin

i've got an similar problem my VAT it's 23% and before the price in frontend dont give me a perfect price .. like 25.00€   it gives me like 25.01€

i changed the product_price    decimal(12,6)
and now it's +/- .... but i've got problems in the administration product price with vat.... it display the price with the same problem like 25.00956€ ... but it solves the problem on frontend price...

VM V. online: J2.5.14 | VM 2.0.20a | SQL 5.1.70 | PHP 5.3.25

#### elvispl

• Beginner
• Posts: 5
##### Re: Problem rounding Product Price (Gross)
« Reply #2 on: July 10, 2012, 07:45:17 AM »

jos_vm_product_price
product_price   decimal(12,5) -> product_price   decimal(12,2)

jos_vm_order_item
product_item_price   decimal(15,5) -> product_item_price   decimal(15,2)

jos_vm_orders
order_total   decimal(15,5) -> order_total   decimal(15,2)
order_subtotal   decimal(15,5) -> order_subtotal   decimal(15,2)

#### VirtueMart Forum

##### Re: Problem rounding Product Price (Gross)
« Reply #2 on: July 10, 2012, 07:45:17 AM »