Tax Calculation For Quantity Discounts

I have added the adjustments to the database for 4 decimals to account for GST. however the quantity discounts does not hold 4 decimals. its only got 2
mike

Edited by

Click Settings in the main menu of your Sytist admin
Underneath the left menu click MySQL query.
Copy the following line of code and paste it in the query area and click run.

ALTER TABLE `ms_photo_products_discounts` CHANGE `dis_price` `dis_price` DECIMAL( 10, 4 ) NOT NULL DEFAULT '0.00';

Edited by

There appears to be some sort of calculation error happening in the booking calendar. I have entered 177.2727 as the price for a booking calendar price (does not show 4 decimals places, or may not save 4 decimal places either which is having 10 get being applied so shows 195. which is correct, however when an option is selected, say a 0 value the price changes to 194.00. if a different option is selected say location shoot which is an extra 68.1818 (plus gst = 75) it then show a total value of $268. (which it should show $270). However when it is added to the cart it show correctly as $270. so somewhere on the popup screen I would suggest it is not calculating 4 decimals but only two?????

Can this be looked into please. hope that make sense

Edited by

also on the first checkout screen, is it possible to have a current total or something. it only displays the subtotal and GST value but not a current total of both combined

Edited by

It is probably not saving the 4 decimal points. Try this

Click Settings in the main menu of your Sytist admin
Underneath the left menu click MySQL query.
Copy the following line of code and paste it in the query area and click run. This will give you 4 decimal places for the booking service price

ALTER TABLE `ms_calendar` CHANGE `prod_price` `prod_price` DECIMAL( 10, 4 ) NOT NULL DEFAULT '0.00';

On the checkout screen, it won't show the grand total until the second step.

Edited by

added line to to database. now saves the 4 digits in the booking calendar but still calculates wrong on popup with the options. And Still displays correctly in cart after continuing

Edited by

I am unable to duplicate that. My tests seem to calculate correctly. Post or email me a link to a booking service doing that.

Edited by

https://www.milnerstudios.com.au/buy-now/
Select buy and book now. Should be 195 if you select no on one of the options it will change to 194

Edited by

What do you have entered in for the price of that one and what is your VAT percentage?

Edited by

177.2727
GST 10%

177.2727x10% = 194.99997

Edited by

I just changed it to 177.2728 and it behaves better. I suspect if I change to option to round up on the fourth digit it will behave perfect. Therefore I suspect the formula on the booking calendar is rounding down if not exactly 195

Edited by

Oh PS. Taxes in Australia are not added on to the price. Here taxes are included in the price. So I have the option selected for that

Edited by

Is it working correctly now with 177.2728 as the price? Just tested it and seems to be.

Edited by

Yes. It is now working. The only other item is the booking option that uses the checkbox don’t allow 4 digit prices

Edited by

See the bottom of this page on how to turn all the prices including options to 4 decimals
https://www.picturespro.com/sytist-manual/settings/tax/

Edited by

Thats great. I was looking for some kind of list that would adjust all the necessary fields. However with the calendar options. if you use the checkbox option it does not save 4 digits. This option still calculates wrong

Edited by

Click Settings in the main menu of your Sytist admin
Underneath the left menu click MySQL query.
Copy the following line of code and paste it in the query area and click run.

ALTER TABLE `ms_product_options` CHANGE `opt_price_checked` `opt_price_checked` DECIMAL( 10, 4 ) NOT NULL DEFAULT '0.00';

Edited by

thank you

Edited by