Sage 300 support will assist with Sage Intelligence issues. If needed the team can schedule a remote session with Alchemex team. There were reported cases where removing the solver add-in from Excel Add-in helped. If solver Add-in is selected, unchek it, click ok and close Excel. Try the reports again.

Ok so i have tried the solver issue cuz thats something i can do. PATH is something i have to check with consultant on. Will do that as soon as he returns call.

Meanwhile, the solver, when i disable it, does seem to change the error msg i got. it no longer says that i need a designer licence. Now, it just gives 0.00 in the report so it is not pulling data. What i noticed is that the excel gives an error when the designer is enabled in the Add-ins " an unexpected error occurred: exception has been thrown by the target of an invocation.

Not sure what all this means anyway!!

To check the PATH:

On the Windows desktop click Start then type CMD and press Enter on the keyboard.

At the command line prompt type PATH and press Enter.

You will see some text listed, this is the PATH environment variable. There should be only one reference to the Runtime folder.

oooh that was easy! yes, runtime was only mentioned once. please see below...

Microsoft Windows [Version 6.1.7601]

Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Cathy>path

PATH=\\WIN-7GLCVIKKNA9\Sage300ERPApps\RUNTIME;C:\Program Files\Common Files\Micr

osoft Shared\Windows Live;C:\WINDOWS\SYSTEM32;C:\WINDOWS;C:\WINDOWS\SYSTEM32\WBE

M;C:\WINDOWS\SYSTEM32\WINDOWSPOWERSHELL\V1.0\;C:\Program Files\Windows Live\Shar

ed;C:\Program Files\Calibre2\;C:\Program Files\QuickTime\QTSystem\

oooh that was easy! yes, runtime was only mentioned once. please see below...

Microsoft Windows [Version 6.1.7601]

Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Cathy>path

PATH=\\WIN-7GLCVIKKNA9\Sage300ERPApps\RUNTIME;C:\Program Files\Common Files\Micr

osoft Shared\Windows Live;C:\WINDOWS\SYSTEM32;C:\WINDOWS;C:\WINDOWS\SYSTEM32\WBE

M;C:\WINDOWS\SYSTEM32\WINDOWSPOWERSHELL\V1.0\;C:\Program Files\Windows Live\Shar

ed;C:\Program Files\Calibre2\;C:\Program Files\QuickTime\QTSystem\

OK, good.

Did you run the workstation install for Sage Intelligence 2014?

If not then browse to

\\WIN-7GLCVIKKNA9\Sage300ERPApps\BX62A\WSSetup

Then right-click Setup.exe and select Run As Administrator.

ok so i did that but nothing has changed....

i will look at this with fresh eyes on monday...have a great weekend all!