Solved

sage excel intergrated reporting

Posted on 2009-05-20
15
5,071 Views
Last Modified: 2012-06-27
Hi,

I have sage accounts 50 accounts 2009. I want to be able to use excel intergrated reporting I believe I have it installed but when I click on add ins it shows SAGE EIR add in but when I click browse nothing appears, Can someone help?
0
Comment
Question by:Dan560
  • 8
  • 7
15 Comments
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 24439941
What version of Excel are you using?
0
 
LVL 2

Author Comment

by:Dan560
ID: 24439948
I am using Office 2003 professional edition
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 24441665
Do you have the Sage menu option at the top of the screen in Excel and the Sage Toolbar?

If not, i suspect it has been un installed or is for a previous version of Sage so get hold of the CD and re-run the installation making sure EIR is selected.
0
 
LVL 2

Author Comment

by:Dan560
ID: 24448903
It does have it there. but it wont let me select a company, when I do nothing appears. cant get my head round this one.
0
 
LVL 2

Author Comment

by:Dan560
ID: 24449016
I have attached a pic.
Basically I can see Sage toolbar but when I select sage company or application nothing happens not even an error message.

sage.bmp
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 24449139
Does the "Select Company" option work?

Can you set it up to point to the dataset?

Have you read the Excel Integration pdf in the installation directory (normally located c:\program files\sage\accounts\Excel Integration.pdf) and followed the setup instructions?
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 24449211
Have you upgraded or is this a new installation?

if an upgrade I would un-install and reinstall, as there was a similar issue in an older version, so it might be some "left over" remnant of a previous installation.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 2

Author Comment

by:Dan560
ID: 24449227
It is a new installation. I even went through the setup on sage again and made sure EIR was selected. I found a few PDF's but nothing explaining how to set it up, I have tried forcing method by going to
C:\Program Files\Common Files\Sage SBD and clicking on  ForceEIRRegistration.exe
nothing though
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 24474796
What happens when you select the "select company" option on the sage (7th top line "word") menu in excel?
0
 
LVL 2

Author Comment

by:Dan560
ID: 24480944
When I select company from the sage menu absolutley nothing happens, it just doesnt do anything, I dont even get any error messages.
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 24482399
This is getting tough...

What level do you have macro security on?

Perhaps turn off to see if it enables things to run.
0
 
LVL 2

Author Comment

by:Dan560
ID: 24483207
It was set to high, but I have just set it to low. It didnt change anything
0
 
LVL 2

Author Comment

by:Dan560
ID: 24484052
I was reading that the EIR looks up the following directory to load its reports:
 C:\Program Files\Sage\Accounts\REPORTS\Excel
This folder does not exsist on my system, I think my reports are located in following locations:
C:\Documents and Settings\All Users\Application Data\Sage\Accounts\2009\company.000
C:\Documents and Settings\All Users\Application Data\Sage\Accounts\2009\company.001
C:\Documents and Settings\All Users\Application Data\Sage\Accounts\2009\company.003
 
Do you think it is looking in the wrong place for the reports?
0
 
LVL 10

Accepted Solution

by:
Bruce Denney earned 500 total points
ID: 24494529
Do a clean reinstall with the new security settings, that should fix things.

<installation directory>Reports is where they used to be.  I suspect the documentation you read related to an earlier version or has not been updated and is out of date.
0
 
LVL 2

Author Comment

by:Dan560
ID: 24803037
Hey
Thanks I did a complete reinstall and it worked :)
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Getting data out of MAS90 doesn’t have to be tedious or time consuming.  With any version of Excel using the included Microsoft Query function, you can access just about any data set or combination of data sets stored in your MAS90 MAS200 Software. …
As an accountant it is essential that I am able to provide accurate and timely information to management and staff.  One of the challenges that I have faced is the need to report on a time period, whether it be a month, quarter, or year, and wanting…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now