Rate with four decimal places for price rounded to unity with taxes included

More
9 years 10 months ago #5155 by maxandreoli
Hi,
Let me know if you can handle the rate to four decimal places to get the price inclusive of taxes rounded.
Example: tariff without taxes € 27.2727 = tariff with taxes at 10% rounded to € 30.00
it's possible?

Regards,

Please Log in or Create an account to join the conversation.

More
9 years 10 months ago #5157 by vietvh
Hi,

Thank you for posting it here.

It'd require changing all database fields which is currently using 2 decimal places format as well as making changes to the code as well.

If other users have the same need for this change, please reply here so that we can consider it for upcoming releases.

Regards,

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #5596 by ChefsGaestezimmer
Hi!

I have the same desire.

My room is € 27.00 incl. 19% tax. Which means a room of (round about) € 22.6890756302521 without tax.
I would suggest that the fields are expanded equal to 6, 8 or 10 decimal places.

Can you tell me the relevant fields, so that I can even change the column definition?

regards;
Tobias

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #5598 by vietvh
Hi,

Below is a list of fields that you should change:

total_price
total_price_tax_incl
total_price_tax_excl
total_extra_price
total_extra_price_tax_incl
total_extra_price_tax_excl
total_discount
deposit_amount
total_paid
tax_amount

Regards,

Please Log in or Create an account to join the conversation.

More
9 years 6 months ago #5734 by ChefsGaestezimmer
Hi,

I have altered only the master data tables. The total columns still have 2 decimal places. It works for me perfect!

Complex Tariff:
ALTER TABLE `[Database Tables Prefix]_sr_tariff_details` CHANGE`price` `price` DECIMAL(16,6) ;

Extras:
ALTER TABLE `[Database Tables Prefix]_sr_extras` CHANGE `price` `price` DECIMAL(16,6) ;
ALTER TABLE `[Database Tables Prefix]_sr_extras` CHANGE `price_adult` `price_adult` DECIMAL(16,6) ;
ALTER TABLE `[Database Tables Prefix]_sr_extras` CHANGE `price_child` `price_child` DECIMAL(16,6) ;

Regards,
Tobias

Please Log in or Create an account to join the conversation.

More
9 years 6 months ago #5736 by vietvh
Hi Tobias,

Nice to see it worked for you.

Regards,

Please Log in or Create an account to join the conversation.

Moderators: solidres
Powered by Kunena Forum

All the things you need to make your work easier. Did you like Solidres?