Can't change taxes format

[midana]

I have tried to change from three to two zerios behind the taxes, pressed saved and then three zeros still appear.. Why doesn't it save my input?

 

I do this under Localization > Taxes
 

It would be even better if the zeros weren't there at all, but I need it to be maximum two zeros and not three as they are now. Anyone who knows what to do?

[tdr170]

The only way to do this is directly in the database, look to ps_tax you will see a field named rate, with a type of decimal (10,3) if you change the 3 to 2 you should now only show 2 decimal places in the taxes.

 

 

ps: you can do this for other areas such as product - prices as well.

Edited December 3, 2013 by tdr170 (see edit history)

[midana]

I tried removing the zeros from the 25.000, but in the type of this it says decimal(10,3)  and it's not editable. How do I change the type to decimal 10,2?

[tdr170]

It is or should be editable on the lkeft click the check box then at bottom click the edit icon (little pencil in my database) you should also have the text change to the right, either will bring up the edit page then just change the 3 to 2.

 

as you can see here I already changed mine.

 

Edited December 5, 2013 by tdr170 (see edit history)

[midana]

This is how mine looks when I click the pencil in ps_Tax and by the 25.000 

[tdr170]

You are not clicking the pencil in the correct place, do not click browse, click on ps_tax then on change to the right on the line labeled rate. OR click the box to the left of rate to check it then on the pencil at the bottom of the table list.

 

ps: I updated my pic in the other post as I realized I made an error on the pencil I had put a red box around.

[midana]

Thank you for helping me.

 

I don't have the same look of the database admin as you have. If I click the other "change" then it looks like this:

 

 

:/

[tdr170]

Can you take a snap on the page only after clicking on ps_tax and post that here.

Who is your provider, maybe you can PM me a log in so I can take a look at the database myself.

[eleazar]

I would strongly recommend not to modify this in your database because this could be a bias for correct computing.

 

If it's just a matter of the display you should modify the code directly in your invoice or mails by adding a round:"0" command to the tax rate Smarty variables like this e.g.:

{$shipping_tax_infos.rate|round:"0"} %

[midana]

Eleazar: Thank you so much for your insight and help to this. I used that variable to rate {$rate|round:"0"} % and now the zeros are gone to the tax procentage. Thank you!

Edited December 5, 2013 by midana (see edit history)

[tdr170]

Good job eleazar I have used the database change for years and have never had an issue, always nice to know of another solution.

[eleazar]

So what do you think about a [solved] for this issue?

[Robwankenobi]

Hello,

 

where can I find what you wrote:

 

''modify the code directly in your invoice or mails by adding a round:"0" command to the tax rate Smarty variables like this e.g.: {$shipping_tax_infos.rate|round:"0"} %''

 

thanks in advance