- Posts: 1
- Home
- Forum
- Community Forum
- Questions
- Manager permissions
- Forum
- Community Forum
- Feature requests / Suggestions
- Implemented
- Rate with four decimal places for price rounded to unity with taxes included
Rate with four decimal places for price rounded to unity with taxes included
- maxandreoli
- Topic Author
- Offline
Less
More
9 years 10 months ago #5155
by maxandreoli
Rate with four decimal places for price rounded to unity with taxes included was created 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,
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.
- vietvh
- Offline
Less
More
- Posts: 1553
9 years 10 months ago #5157
by vietvh
Replied by vietvh on topic Rate with four decimal places for price rounded to unity with taxes included
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,
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.
- ChefsGaestezimmer
- Offline
Less
More
- Posts: 4
9 years 7 months ago #5596
by ChefsGaestezimmer
Replied by ChefsGaestezimmer on topic Rate with four decimal places for price rounded to unity with taxes included
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
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.
- vietvh
- Offline
Less
More
- Posts: 1553
9 years 7 months ago #5598
by vietvh
Replied by vietvh on topic Rate with four decimal places for price rounded to unity with taxes included
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,
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.
- ChefsGaestezimmer
- Offline
Less
More
- Posts: 4
9 years 6 months ago #5734
by ChefsGaestezimmer
Replied by ChefsGaestezimmer on topic Rate with four decimal places for price rounded to unity with taxes included
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
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.
- vietvh
- Offline
Less
More
- Posts: 1553
9 years 6 months ago #5736
by vietvh
Replied by vietvh on topic Rate with four decimal places for price rounded to unity with taxes included
Hi Tobias,
Nice to see it worked for you.
Regards,
Nice to see it worked for you.
Regards,
Please Log in or Create an account to join the conversation.
Moderators: solidres