Different VAT rounding between Cart and Actinic Order Management

[evey]

Just to say, this isn't a post about trying to get VAT inclusive prices to display £29.99 etc.
I suspect this is a bug...(Using Latest version 7)

Customer orders 2 items through our online store - cart displays and processes order through PSP:
Item 1: £13.58
Item 2: £19.53
Shipping: £3.40
Vat: £6.39
Total: £42.90 (Customer charged through PSP this amount - hunk dory)

Download order through Actinic and go to Orders > Line Items, and line items are displayed correctly as above.
Shipping is displayed correctly as above.
Viewing the Taxes tab, VAT is listed as £6.40 ????????? - no alterations have been made to the order/no surcharges etc. - all plain Jane.

Viewing the Totals tab, on the left hand 'Original', total is £42.90, but in the 'Current' section on the right - it reads £42.91.

This results in the order displaying as only received part payment (Has to be manually fixed with a discount of -0.03%to take it to £42.90).

From speaking to our finance manager (senior accountant) - VAT should allways be rounded down on the whole pence - so e.g. 6.3999 should allways come to 6.39

I know about the Business Settings > Tax dialog and the ability to select different Tax rounding schemes - but that doesn't help much if they're being applied in one way for the online web catalogue and in another for the Actinic order processing side.

Other orders have processed fine - it appears to affect orders that end up on the VAT rounding anvil...

Please can someone comment if this is a bug, and if not - how both are brought into line.

Thanks

[Bruce]

Hi Paul,

I was unable to replicate this issue locally. I have asked Development for their comments and will update you. We may need a snapshot of the site else the database to be able to tell you what is going wrong. Will keep you updated.

Kind regards,

[evey]

Thanks Bruce
I've set the Business Settings > Tax to round down on order (From the default Scientific 3) - I've tried several different orders, trying to get the tax anvil - and this appears ok.

What seemed strange was the disparigy between the Cart calculation and Actinic - I'm wondering if this is my misunderstanding of this setting - I expected it to affect both the online catlog and the Actinic order processing in the same way.

The way it's working though now is ok for us (We really deal mostly with the UK)

[antnb]

Which is the best VAT setting to use?

For instance, I have a product price £118.00 gross. The net figure £100.42 gives me 117.99 inc. VAT, the net figure £100.43 gives me £118.01.

[evey]

Hi antnb

I think your VAT inclusive price issue is a bit different from the above - but well known with Actinic (We just accept going over the target vat inclusive price by a penny).

See the link below for some discussion and ideas to resolve:

http://community.actinic.com/showthr...&highlight=VAT

cheers

[zmagyar]

I can confirm this is a bug in Actinic scripts. Most likely it is going to be fixed in the next maintenance release. If you can't wait until that you can change your scripts. Just open ActinicOrder.pm in a plain text editor and find

sub RoundTax

You will find the following lines there

	elsif ($eRule == $ActinicOrder::SCIENTIFIC_NORMAL)
		{
		$nValue = int ($nValue + 0.5);
		}

If you have found it just change to

	elsif ($eRule == $ActinicOrder::SCIENTIFIC_NORMAL)
		{
		$nValue = int ($nValue + 0.500001);
		}

Then save the file and upload. Please note the usual disclaimer about script changes (always backup first, Actinic is not supporting, etc) applies here.

[Bruce]

Thanks Zoltan

Regards,

[evey]

cheers for that Zoltan and Bruce, I'll keep an eye out for next maintenance release.
It's working ok for us at the moment - so I'll leave it at that.
Thanks