Solved

sage excel intergrated reporting

Posted on 2009-05-20
15
5,095 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
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hi, I've just fixed a problem with Sage 50 Accounts 2010 crashing when creating a new Company.  I've spent nearly 4 hours on it including three calls to the Sage helpdesk (they didn't work it out in the end - I did!) ... so I thought I'd share th…
Hi, I've just fixed a problem with Sage 50 Accounts 2011 crashing when creating a new Company.  I've wasted several hours on it so I thought I'd share the solution with others.  Remarkably, the same laptop had what appears to be exactly the same …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

776 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