Solved

Sage 50 and Open Office

Posted on 2014-04-10
4
1,306 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
[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
  • 2
4 Comments
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

With the internet and the ease of information transference, many professional jobs can be done anywhere today.  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified?   Outso…
A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.

738 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