Solved

Why does Sage not allow me to run a report ?

Posted on 2011-03-24
10
3,778 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
 
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
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.

 

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
OfficeMate Freezes on login or does not load after login credentials are input.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.

895 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

20 Experts available now in Live!

Get 1:1 Help Now