BUG: Sales Analysis Report incorrect

[Guest]

Hi Aneta,

I was able to reproduce the issue with Sales Analysis report and have raised a bug. However, I cannot replicate the issue with 'Manual Adjustments'. After adding the adjustment did you select a 'Tax Treatment'?

[zentauri]

I was able to reproduce the issue with Sales Analysis report and have raised a bug.

Thank you for looking into it

After adding the adjustment did you select a 'Tax Treatment'?

Of course I didn't, silly me
Thanks a million

[zentauri]

In my case I pull all the order data into excel and run my reports from there.

Mike, could you tell me how you put the data into excel please?

[Mike Hughes]

You can import data into excel by going to 'Data|Import External Data|Import Data', select the proper ODBC connection and then the required tables.

You might need to install the data connection bits into excel as this isn't always installed by default. It should be on the excel disk though.

It sounds complicated but is really quite easy as you're shown the tables that exist and can select / deselect the bits you want on the screen.

Excel will then create the database query to get the data and you can use that in a macro to automatically update the data and process it.

You'll then end up with something that looks like this:

' set the starting location

Cells(1, "A").Select

' get the actinic data

With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _
"ODBC;DSN=MS Access Database;DBQ=C:\Program Files\Actinic Ecommerce v6\Sites\Site1\ActinicCatalog.mdb;DefaultDir=C:\Program Fi" _
), Array( _
"les\Actinic Ecommerce v6\Sites\Site1;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;" _
)), Destination:=Range("A8"))
.CommandText = Array( _
"SELECT `Order`.`Order Sequence Number`, `Order`.`Order Number`, `Order`.`Date Ordered`,`Order`.`Date Order Finished`, `Order`.`Order Total Cost`, `Order`.`Shipping Total Cost`" & Chr(13) & "" & Chr(10) & "FROM `Order` `Order`" & Chr(13) & "" & Chr(10) & "ORDER BY `Order`.`Order Sequenc" _
, "e Number`")
.Name = "Query from MS Access Database"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = True
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.PreserveColumnInfo = True
.Refresh BackgroundQuery:=False
End With

' now analyse the data

This a V6 version which only has VAT exclusive prices. The tables in V9 will be slightly different. You should be able to get a copy of the data diagrams from Actinic if you ask nicely.

Mike

[zentauri]

Many thanks Mike, it does sound complicated but will have to have a look into it at some point as incorrect Sales Anaysis figures drive me mad

[Mike Hughes]

I should point out that you don't need any macros to do this. Just using the 'data import' bit will pull the data straight into excel.

Mike

[zentauri]

Hello Sumiya, could you please advise whether this bug was fixed in v10?

[zentauri]

You can import data into excel by going to 'Data|Import External Data|Import Data'

Mike, which version of Excel are you using? I have Excel 2000 and it seems to be different: I go to Data -> Get External Data and then the options are:

- Run Saved Query
- New Web Query
- New Database Query
- Import Text File

I tried to run 'New Database Query' but it keeps saying that Microsoft Query is not installed even though I inserted Excel disc and tried to install it several times so I am basically not able to import these data into Excel. Probably a silly question but is there any other way of doing it?

[TraceyHand]

There are several fixes to the Sales Analysis report in V10.
I would hope everything was fixed and not just some parts but I wouldn't guarantee it.
Download the 30 trial and see

[Nick Cook]

Hello Actinic

We have this same issue with a version 9 site. Can you let me know whether the bug was ever fixed in version 9?

I contacted Support about this yesterday only to be told we should try upgrading to version 11.

Whilst we are considering upgrading to version 11, it doesn't seem right that we should buy an upgrade to receive a bug fix for the version we have already bought!!

Can you let me know if there is a fix available for the Sales Analysis report please. (We are on version 9.0.5 JHZA)

Many thanks

Nick

[zentauri]

v10 - still not fixed, I don't know about v11, not upgraded yet

[Nick Cook]

I have raised this with Actinic Support and await a response.

Regards

Nick