Solved

Sage 50 and Open Office

Posted on 2014-04-10
4
1,198 Views
Last Modified: 2014-04-21
Greetings,

I have a client running a Windows 7 desktop and I installed Open Office. They are also running Sage 50 and have run into an issue. Sage 50 wants to generate reports to Excel and doesn't recognize calc.exe.

Does any know of a work around for this? It sounds like Sage just wants the MS product end of story, but my client a small plant nursery and I would hate to see them spend any more money than is needed.

Thanks.
0
Comment
Question by:Fuwaad
  • 2
4 Comments
 
LVL 37

Expert Comment

by:Gerwin Jansen
ID: 39992955
I don't know about "Sage 50" but is it trying to send data directly to Excel? If that's the case you could try and associate .xls/xlsx with calc.exe (if that's not the case already).

Shift-Right-Click a .xlsx file and choose 'Open With', browse to 'calc.exe' and check the 'Always use the selected program ...'. Then try "Sage 50" and see if it works.
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 39998559
You used to be able to read data from Sage via odbc the data pilot had issues with the SQL as it was ambiguous so you had to do it manually.  I tried it a short while ago and it didn't seem to work at all.

There are some other work around methods.

You can save (export) a report to csv format this can then be opened in any spreadsheet.

You can save (export) a report to excel format this will then be readable with open/libre office / others this will have formatting and not be as useful as plain csv for manipulation.
0
 

Accepted Solution

by:
Fuwaad earned 0 total points
ID: 40004954
My client informed me that they have Sage support paid for :-/   So I have contacted them. For anyone else who has this issue this is what I have been told by Sage second tier support.

The only way to create spreadsheets from Sage 50 data to have MS Excel installed. Even better it has to be installed locally in the workstation, AND it can't be 64 bit.

Thanks to Gerwin and Bruce for responding.

Onward and upward.
0
 

Author Closing Comment

by:Fuwaad
ID: 40012213
I get to grade myself? Well, I get an A because while I was right about what the issue was, and while I could not resolve it I'm not a programmer at Sage.
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

Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

911 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

22 Experts available now in Live!

Get 1:1 Help Now