Product permutation pricing including VAT

[shaneod]

Do I still have to do the above to get VAT inclusive prices in a permutation dropdown list in v9?

[simonc]

So, since having their fingers burned on Monday has anyone worked out a better way of doing this? Could the value for VAT (Normal) be hauled out of ActinicCatalog.mdb somehow?

[KevWal]

Hi

Did you find an answer at all? I have only just found the problem, am just writing to support...

Thanks
Kev

[Lisa Carey]

Me too! - Has this been solved yet?

[nikkijones]

me three! do we still have to use the work around as this means the design will need to be changed if we revert to 17.5% VAT at some point.

[Lisa Carey]

Also, the VAT does not calculate quite correctly if using the manual workaround.

For example - assuming VAT at 15% and tax rounding set to Standard -

If a product is £4.30 ex-VAT Actinic calculates the inc VAT price as £4.95 and this is what appears in the basket.

Using the workaround, the product price displays in the permutation drop down as £4.94.

I know it's only 1p difference between the price displayed and the price in the basket, but customers do notice and query inconsistencies like this.

Please can this thread be added to the wish list if it's not already there??

[nikkijones]

Hi Lisa,

I've been addressing this issue here:
http://community.actinic.com/showthread.php?t=42061

It looks like its the PHP method 'float' thats causing our prices to be incorrect. This is rounding some prices down that should be rounded up. I'm not sure how to fix it, i keep trying to look for fixes or trying different ideas myself but when you get it to work with one price, it causes a problem with another.

I can only think we need to scrap the 'float' method and try something else but i'm unsure what.

If i come across anything i'll let you know, unless anyone else has any ideas?

My customer wont be happy until its fixed as net prices showing in the components are useless and incorrectly priced components are just as bad!

nikki.

[nikkijones]

Looking into PHP a bit more....as we know, we're using 'float' - this seems to be random, sometimes rounds up, sometimes rounds down.

we can use php to 'floor' a number (ie round it down) or 'ceil' a number (ie round it up). Presumably actinic follows the normal decimal method of...

if third number is greater than or equal to 5 (eg. £4.995) then it rounds it up to £5.00)

and likewise if less than 5 (eg. £4.994) then it rounds down to £4.99.

So effectively we need a little bit of script that says if the third digit is greater than or equal to 5 - 'ceil'

and if less than 5 - 'floor'

anyone know any php????