[SOLVED] Virtuemart 3.2.2 shipping cost shown max of 100,000 (SOLVED by MILBO)

[Jörgen]

Hello

You are absolutely correct, there is some kind of limit of 100 000, but you can add tax,

I tested on Your site and got the result ahown in the added image.

I also tested on my site with 125 000 + tax (25%) = 156 250
But I got 100 000 + tax on 125 0000 = 100 000 + 31 250 = 131 250.

This has probably nothing with the template to do. Funny that the displayed value is affected but not the calculated value.

regards

Jörgen @ Kreativ Fotografi

[fredricklamaz]

Thanx Jorgen..

that is why it is really confusing.. It is a simple bug yet fatal. As customer wont pay the total if the shipment is only 100,000.

Milbo, did you try until the process completed? the pdf is also shown max 100,000.

Anyone has the solution for this? I think must be edited from the php.

Thank you

[fredricklamaz]

Milbo. Do you kbow anyone can help me on this bug?

Anyone can help me please?

Thank you.

[fredricklamaz]

Anyone know how to solve this problem? I really need solution for this bug.

Thank you.

[Milbo]

It took me a while to reproduce it.

It is very strange, the sql "SELECT o.*, o.created_on as order_created, u.*, s.order_status_name FROM #__virtuemart_orders o LEFT JOIN #__virtuemart_orderstates s ON s.order_status_code = o.order_status LEFT JOIN #__virtuemart_order_userinfos u ON u.virtuemart_order_id = o.virtuemart_order_id WHERE o.virtuemart_order_id=yourOrderId"

just returns a 99999.99999, the used database field has DECIMAL(10,2), so it is big enough. I am on it

[Milbo]

Just use a bigger decimal in table virtuemart_orders, I set it now in the core to `order_shipment` decimal(12,5), this allows 9 Millionen, that should be enough.

[fredricklamaz]

Thanx a lot Milbo.

So sorry i just manage to reply. was out of town, no laptop.

I have tried your solution and it is working really fine now.

I am really thankful you solve this problem. Thanx a lot Milbo.