Faulty invoice and tax calculation! - Solved

Hello,

now, near the lunch of my shop and some ordering testing, I ran into a big problem. The tax calculation and shipping-tax calculation makes some mistakes.

I did a testorder and took some screenshots (all from the same order) to explain it. and the tax for germany is 19%.

Here you see a screenshot of the cart in the frontend. Here is the first mistake:
- the "Zwischensumme" (sum) incl. the tax is 44,-€ -> thats ok.
- the "Versand" (shipping) incl. the tax is 5,95 -> thats ok.
- the "Steuern" (tax) is wrong. If 49,95€ is the endprice with tax, than 41,97€ is the endprice without tax and the tax is 7,98€ (not 7,95€).

Next screenshot. This time from the email the user will get:



Here the user gets an email with the price without tax. Ok, I think this could be changed in the emailsettings, but also here the price calculation is wrong. Because the price without tax from 44,-€ is not 37,-€, it should be 36,974789915966386554621848739496€ or better 36,97€.

Next screenshot from the invoice in the backend:



Here are some more mistakes:
- the 37,-€ without tax is wrong, as I allready said in the second picture.
- The MwSt. is wrong. Why only 7,-€? In the cart is was 7,95€ (that was allready wrong) and now its only 7,-€ (more wrong) but we allready told the user in the mail that it was 7,95€? I am confused about this.
- the rest is ok.

Ok, last screenshot. Now from my own invoice-program I use for a long time and do the calculation right:



Here you see the price per pcs. of 0,44€ with tax. So for 100 pcs. 44,-€. Then the shipping with 5,95€ incl. tax and the endprice incl. tax is 49,95. And now the big difference at the tax, with 7,98€ its right in this calculation.

So what do do? I think I know where is the big problem. At the product page I type in the price incl. tax. and I type there the price of 0,44€ incl. tax at min. 100pcs. When I leave the "price incl. tax" field it automatic write at the field "without tax" the value 0.37000€. And thats the mistake I think.

Regards, Benny.

@ nicolas

If it would be usefull to chat with me for this issue, here is my chat:

www.eiwomisa.de/website/chat.html

Regards, Benny.

Hmmmm, thats bad and makes the shop less usefull for me as my clients are most endusers and they don't want to know the untaxed price.
And where does hikashop get his price from for the database? I told them the taxed price. If hikashop would write the right price in the database, we all would be happy. As example:

I set a taxed price of 0,44€ with 19% tax in a product. Then hikashop should write in the database a untaxed price of 0,36974789915966386554621848739496€ in the database. This way my client would have to order a very lot from this product to get any rounding errors.

I don't know if this all is a big problem to solve, but virtuemart does this the right way.

And the other thing is, this all does not explain the mistake that is in pic number 3. Why only 7,-€ MwSt.? It should be 7,95€.

Regards, Benny.

Hmmm, I understand. But I think this is a problem you should solve when you got time for that.

But I think I have another bug. Like you said, I now did not set the taxed price of 0,44€ for the product, I set the untaxed price of 0,36975€ and saved. Now in the backend it display the right value in the pricelist in the product view of 0,36975€ untaxed and 0,44€ taxed. But still if I would order 100pcs. it says still 37,-€ untaxed and 44,-€ taxed. And now?

Regards, Benny.

Hi,

ok, I set the decimals to 5 in the currency. To set it to 3 is not enough.
I think this shop is very good the its very easy to manage all the normal work you have with a online shop. But to round a value before its calculation is not very smart. It was the first thing I learned in math to, if possible, only round the sum.

Ok, set the decimals to 5. Now my views are a little strange with 5 decimals. How could I set this to 2 rounded decimals in the views? What code do I need and where?

Regards, Benny.

Hi,

thanks, 50% solved. Now it does the rounding, but still shows all 5 decimals. Now its not 0,36975€, now its 0,37000€.

Regards, Benny.

Hi again,

ok, now its all fine, not all but most. In the backend in the product view I can only set an untaxed price with 5 decimals. How could I set this to 6 or 7 decimals?
And if I set there a taxed price, it automatical sets the untaxed price for this. But this way it only sets it automatical with 2 decimals, how could I make it that it automatical set the untaxed price with the max possible decimals available?

The problem is, if I have a taxed price of 0,38€ and a client wants 5000pcs, then it should be 1900,-€. But with the 5 decimals untaxed price (0,31933€) this would be 1900,01€

Regards, Benny.

Hi,

the first thing worked fine. Now I have 7 decimals in the table. But the second thing with the code didn't work. After I change that line and set a taxed price then it rounds only to 1 decimal in the untaxed price

Regards, Benny.

Thanks! That works right!

How do you mean that? Would this function, of the automatic untaxed calculation from the taxed price, be included in the next release? And do I have to change all my changes ones more after an update?

Regards, Benny.

Ahhh, ok. No problem and don't hurry! This workaround is ok and I think I could exchange virtuemart with hikashop in the next days.
I do electronic engineering and need the shop only to sell some of my projects, because of this I know this -> "Its done when its done"

Regards, Benny.

Hi,

I had the same problem and fixed it with the mentioned solution, but now I have a problem with the paypal plugin. When a customer is redirected to paypal, he gets the following message at PayPal: The link you have used to enter the PayPal system contains an incorrectly formatted item amount.

Used price with taxes: € 19,95, without tax: 16,76470 (19% tax).
International fractional digits: 5
Local fractional digits: 5

When I create a testproduct of € 1,00 without tax (€ 1,19 with tax), I don't get the paypal error.

Thanks for your help.

Regards,

Eppo