Solved

Sage 50 and Open Office

Posted on 2014-04-10
4
1,157 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
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.
The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

743 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