Unable to use new version of Business Intelligence Software...

So we have upgraded to Sage 300 ERP 2014 version.

Business Intelligence works fine with old reports made in previous version but when i try to use the reports in the new version, i keep getting an error message saying that a Designer Licence is required.

Consultant tried re-installing the BI and i think system manager, but still, i am unable to use the new reports. Alchemex says its Sage issue, Sage says its Alchemex issue. Either way, i am stuck!

Can anyone help please?

FYI, i am running a separate server each for Sage 300 ERP software and SQL.

Many thanks!

Parents
  • 0

    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.

  • 0 in reply to VicenteG

    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!!

  • 0 in reply to KathieK

    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.

  • 0 in reply to Ettienne Schwagele

    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\

  • 0 in reply to KathieK

    If you are printing a stock report, which report is it? As for the error message, if you are logged in as user with admin rights, go back to Manage Excel Add-in. For the  report designer add-in, browse to C:\Program Files (x86)\Common Files\BIExcelFunctions1.1\32bit and select Sage.BI.ExcelFunctions1.1.xll. See if you still get an error.

  • 0 in reply to VicenteG

    :( yeah i still got error in excel....

  • 0 in reply to KathieK

    so my results thus far is that i am no longer getting the error message in BI saying Designer Licence required". this is as a result of disabling the solver add-in.

    However, i now get an error message saying: The sage intelligence report designer add-in is not responding. i checked and it is in active add-ins list.

    I will ask our consultant to delete and re-import the BI reports for the new version and see if that helps.

    Failing that and any other great suggestions form the forum, we will have to schedule an online session with the powers that be.

    You have all been great and thansk sooooo much for all your help!

  • 0 in reply to KathieK

    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.

  • 0 in reply to Ettienne Schwagele

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

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

Reply Children
No Data