Prices inc tax

[capers123]

We run a paper mail order catalogue and have also recently set it up in Actinic Catalog 6.0.2. Most of our customers are end users, therefore all our prices displayed are inclusive of VAT.

Take, for example, our item 420030. We sell it at £6.95 – a nice round figure. Working this back to ex-VAT (div by 1.175), it costs £5.91. Multiply this up and you get a price in Catalog of £6.94 – one penny difference.

This looks very odd when the customer gets the invoice from us (we input orders into our own order & stock control system) as we either have to adjust the P&P by a few pennies, or charge them a couple of pence more (or less).

Anyone got any suggestions (other than changing around 1/4 of the 2000 odd items in our next paper catalogue?)

Thanks

Mark Rogers

[Owen Drumm]

If you got to View|Business Settings|Tax and set the Tax setting as Round Item Up that should work

[capers123]

Fine, but if I take £7.00, work out the ex VAT & then RoundUp, I get £7.01!

There are some numbers which you can not get if you multiply the exVAT by 1.175 - you either get 1p lower or 1 p higher

I did talk to Actinic about this, who referred me here to see if anyone had a work around.

What would be ideal would be to import the inclusive of tax figure into Actinic & let it work out the exVAT

Mark

[lee.harris]

Seconded.

[Florian]

Put me on the list too!

[cdicken]

I'm pleased to say that this will be in the next major release.

[Florian]

Great news Chris!

[capers123]

Thanks!

[Highlander]

VAT Rounding

Chris,

Have there been any developments on this?

I have 6.1.5 but cannot see this facility - have I missed something?

[cdicken]

You haven't missed anything. We were planning it for v7, and we fully specified it and then realised that it would take a vast amount of effort to do - and we wanted to get v7 out at some point in 2004.

It is top of my list for proposed features for the next release, but I can never provide any guarantee about future features until I see them working and finished.

[Highlander]

The simple things ...

Chris,

As a developer my experience is that the most impossible demand turns out to be simple and the really simple turn out to be nightmares.