BUG: Sales Analysis Report incorrect

[zentauri]

I've realised today that my Sales Analysis Report is giving me incorrect figures. It doesn't seem to cope with orders that are VAT exempt i.e.

order from the US, product total including VAT was £39.20 but because it's VAT exempt the customer pays £33.36, yet when I run Sales Analysis Report it tells me that Goods Total (ex. VAT) from the US is £25.73

It seems to ignore the fact that this order is VAT exempt and deduct VAT from it again? It does only to 'Goods' and seems to calculate 'Shipping' fine.

In 'Sales by country' the numbers doesn't add up e.g.

Goods (excl tax) £25.73 (that's incorrect, should be £33.36)
Shipping £10.21 (correct)
Total £43.57 (correct)

Anyone has an idea what's wrong? Is it another bug or I am missing something?

I read some posts from the past about similar problems but that supposed to be fixed now. I am on V9.0.5 Business Plus

[Mike Hughes]

It does sound like a bug.

Are you entering prices including or excluding VAT? I'm just wondering if the new feature of entering VAT inclusive prices missed something in one of the reports.

Mike

[zentauri]

It does sound like a bug.

Are you entering prices including or excluding VAT? I'm just wondering if the new feature of entering VAT inclusive prices missed something in one of the reports.

Mike

Hi Mike,

All prices are VAT inclusive.

I just had a look at some other orders and it seems that also orders from EU where custmer is VAT registered are not adding up properly. In Sales Analysis by Country the last column 'Total' is fine but 'Goods (ex. tax)' column is not and most importantly Grand Total in Summary is wrong and I depend of these for my tax returns

[Mike Hughes]

It does sound like a bug in the report to me. I'm not too surprised as there was an awful lot of work and changes involved in the VAT inclusive feature.

The good news is that as these are VAT exempt reports you won't be underpaying or overclaiming any VAT. Just making an error in the reporting of VAT exempt sales.

Actinic need to look into this. I don't know what the process is supposed to be for reporting a bug. Maybe the mods could find out for us.

In the meantime you might want to add 'BUG' to the title of the thread. That should get some attention and you can always change it later if necessary.

Mike

[zentauri]

The good news is that as these are VAT exempt reports you won't be underpaying or overclaiming any VAT. Just making an error in the reporting of VAT exempt sales.

Thanks heavens for that at least.

Still, on the days I get VAT exempted order my day's total in 'Summary' on the top is incorrect i.e. it seems that the amount of VAT deducted from VAT exempted order is deducted once again from day's total.

I don't get VAT exempted orders on daily basis but I do get them from time to time, which means that I cannot relay on this report to give me accurate turnover.

Anyone having the same problem? I wonder what people do, do you rely on Actinic's reports, use third party reports or do your figures manually?

[Mike Hughes]

In my case I pull all the order data into excel and run my reports from there. I don't think many people are doing this though.

I suspect most people are still entering prices as VAT exclusive which is unlikely to have the same problem. Entering prices as VAT inclusive was only introduced in V9.

Mike

[zentauri]

Actinic need to look into this. I don't know what the process is supposed to be for reporting a bug. Maybe the mods could find out for us.
Mike

No one seems to be interested. I wonder whether bugs like that are going to be carried over to v10

[Mike Hughes]

A lack of response doesn't necessarily mean a lack of interest.

Actinic will have seen this and taken note. They'll normally check for themselves before coming back and confirming it as a bug.

On a simple scale of Low, Medium or High impact I'd probably rate this as Low (it doesn't impact customer sales, can be worked around with a calculator, and only affects users using 'tax inclusive' price entries and the actinic sales reports for VAT) which means other things are likely to get looked at first.

That, and the work that's going on to get V10 into customers hands, is probably why we aren't seeing much of a response yet.

If you're looking for support on the problem, and possibly a fix / workaround, then the best thing to do is log a support request. You can this by phone if you have cover or via the form on the support page on the actinic website.

Mike

[zentauri]

Thanks Mike, I will log a support request. I don't have a cover though.

I am little bit disapointed with these reports. I had to register for VAT three months ago and believed that I can rely on them for my book-keeping. I understand it has got to do with VAT inclusive prices but it's already second bug I've found in this short time.

[Guest]

Hi Aneta,

I'm checking this for you. Can you please let me know the version number and day no of Actinic installed in your machine.

[zentauri]

I may be the only person on the planet who is VAT registered and uses tax inclusive prices and sees these bugs everywhere but here is another one:

Manual adjustments are ignored e.g. after applying a discount to the order the amount of tax due remains the same

or even better one: a customer reduced a quantity of product A and replaced it with product B which is slightly cheaper. I've added product B to the order manually and adjusted the total with 'Adjustment' so that the overall total is lower but there is more VAT due.

[zentauri]

Hi Aneta,

I'm checking this for you. Can you please let me know the version number and day no of Actinic installed in your machine.

Hello Sumiya,

I am using Business Plus 9.0.5.0.0.0.J.H.Z.A

Sorry, I am not sure what you mean by 'day no'

Thanks!

[Jan]

It's the JHZA bit - a number that corresponds to the day the product was build.

Cheers,

[zentauri]

Thanks Jan,

BTW where do I find your Crystal Reports?

[Jan]

I'm just about to answer your support query about that - they aren't a mole end product they are produced by SAP, you can buy them from those guys but you it's very expensive so the best way to get them is to look on eBay.

For small changes it's usually cheaper to get a consultant to make the changes for you - Duncan Rounding can do that and so can Mole End.

Regards,

Jan Strassen
www.mole-end.biz