Software Review: Sage EIR (Excel Integrated Reporting). By David Carter

Sage released their Excel Integrated Reporting (EIR) module in version 11 of Line 50 (2005). We haven’t reviewed it yet on AccountingWEB, but it is proving very useful to some users, as reader Jeremy Hall recently pointed out in answer to his own Any Answers question.

Use SAGE EIR add-in in Excel
To answer my own question, thanks to helpful people at Sage, you need to activate the SAGE EIR add- in in Excel. This then allows you to log in to Sage through Excel.

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.

Comments

you get functions as well

garyging | | Permalink

In addition to being able to run reports you get a set of new functions which you can include in your own spreadsheets to get data directly from the Sage database.

Just insert a function and there will be a new Sage Accounts category available

Help in restoring SAGE reports in Excel

annamc | | Permalink

After uninstalling Microsoft Security Essentials on 8th April and installing Avira anti-virus software I am unable to access Sage reports in Excel.

When trying to re-stablish the connection by choosing "Find another company" once I reach the SETUP.DTA file when I try to open it I receive the following message:

"The version of the date file could not be determined.  This is required in order to access the accounts data correctly."

Can anyone help please as I feel completely lost without being able to use reports in Excel.

Thank you.