Solved

Why does Sage not allow me to run a report ?

Posted on 2011-03-24
10
3,799 Views
Last Modified: 2012-08-14
We have recently installed Sage Line 50 Accounts on a Windows 7 laptop which has been working fine.  As it is coming to the end of the month we tried to run a report but when we do this we get the following error:

The report could not be generated.
Method could not be found. 'Sage.Query.Engine.IProperty
Sage.Query.Engine.Model.IJoin.get_LeftProperty()'.

We are then unable to progress with the report.

Does anyone know what would be causing this or how to fix it ?  I have attached a screenshot for reference.

Many thanks in advance
Sage-Line-50-Accounts-Error.jpg
0
Comment
Question by:PurityIT
10 Comments
 
LVL 13

Accepted Solution

by:
murgroup earned 250 total points
ID: 35208825
Two things come to mind. The user does not have access to that report or Windows 7 firewall is blocking it. Check permissions then turn off the firewall temporarily and try again.
0
 
LVL 10

Assisted Solution

by:Bruce Denney
Bruce Denney earned 250 total points
ID: 35214165
The short answer is that as per Sage KB article 24437 Sage 2007 (aka V13) has not been tested for compatibility with Windows 7 and it officially is not supported so you need to buy an upgrade V13 goes "end of life" at the end of April so this is your last chance to upgrade and you might want to take it.

Assuming you don't care about going end of life and still want to run an unsupported product on an unsupported operating system then it may still be possible to get it to work.

------------------------------------

To get older versions of Sage to install on Windows 7 you have to install to a different directory to normal.

The reason for this is because Sage used to put Data in a subdirectory of the Installation Directory and Win7 applies special permissions to the programs directory which breaks things in those earlier versions.

(Aside the 64 bit versions of Windows are fine, but you can not use Sage with the 64 Bit version of Microsoft Office)

Re-installation procedure for older copies of Sage 50 on Windows 7
================================================

Take a full backup.

Do a clean un-install as detailed here (only skip the un-installation and re-installation of .net)

http://www.makingithappen.co.uk/guides/clean_reinstall.htm

When you re-install, chose a custom reinstall and rather than installing to C:\Program Files\Sage.. install to C:\Sage

Apply all patches and get system up to date

Go to help > about and check that your version number is 13.03.36.0168 if not go to http://www.sage.co.uk/accountsupdates/ and apply all the updates to get to that version number.

Restore your backup
0
 

Author Comment

by:PurityIT
ID: 35396280
HI brucedenney,

Thanks for your post.

As we already have another version of Sage installed we chose a different directory but it was one that was in the Program files directory.

Do you think it could be permissions related ?
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 10

Expert Comment

by:Bruce Denney
ID: 35399747
Yes, you need to install somewhere where windows doesn't automatically fiddle around with permissions, I suggest C:\sage as the place to install.
0
 

Author Comment

by:PurityIT
ID: 35511802
Hi murgroup/Bruce,

We still haven't had a chance to look at this as the client isn't back from holiday yet so we haven't had the chance to take control.

Once we do this we will give you an update
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 35831356
Uninstall and do a custom reinstall to C:\Sage
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 35831357
Uninstall and do a custom reinstall to C:\Sage
0
 
LVL 11

Expert Comment

by:sparab
ID: 35900332
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
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

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

785 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