Solved

Why does Sage not allow me to run a report ?

Posted on 2011-03-24
10
3,857 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

726 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