• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 694
  • Last Modified:

Is there an interface for Peachtree Quatum 2009 to Access 2007?

I want to be able to analyze the information in peachtree.  I am not looking to write back into Peachtree from Access.  Is there an application to link the tables or export them access.  Is this a good way to analyze Peachtree.  

I am a financial analyst and need flexibility.  I am confused as to learn Crystal or stay with Access. with interaction of excel.  Any recommendations on that too?

I want to be able to create reports and financial analytical functions such as forecasts, unit costs, trends, financial reports, etc.

Thanks,
JP  
0
easycapital
Asked:
easycapital
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
This one appears to do it:
http://www.multiwareinc.com/pawcom.htm

As does the Peachtree SDK, if you wanna take the time to learn it:
http://www.peachtree.com/partners/addonpartners/free_sdk_download.cfm

As to Access vs Crystal:

I use both, and Crystal is a more powerful and flexible reporting program, but then you'd expect that since that's the business of Crystal. There are some drawbacks - if you need to distribute these reports to others, there can be some pretty hefty licensing fees through Crystal, and Crystal can be difficult to learn. It is, however, one of the oldest reporting engines out there and one of the best. And remember that Crystal is JUST a reporting engine, nothing more - you cannot interact with it like you could Excel, for example.

I do a good bit of work for clients in the financial industry, and have found Access, at times, to be lacking in features needed for the massive amounts of data (and calculations) required. I've always been able to work around it, but most often find myself writing unbound reports and using VBA and queries to do this. Crystal probably would have easily been able to handle this, but then it wasn't an option for these reports.

So - all in all, as with anything involving computers, it comes down to your needs. I personally don't think you can go wrong with Crystal IF it suits your needs.
0
 
jmoss111Commented:
0
 
easycapitalAuthor Commented:
LSMConsulting:

What do you mean by:  "Crystal probably would have easily been able to handle this, but then it wasn't an option for these reports."

1) I need to do a lot of variance analysis, forecasting based on assumptions & trends analysis, then graphing it, finding out unit costs, monthly averages, etc.  Is something complex in Crystal?  Is there an online educational site, of course, besides probably the one offered by BO, which is probably very expensive and not such a good bang for the buck?

2) Do you recommend that I learn a different program other than crystal?

3) I was thinking to go after the business owners and offer them consultant assistance analyzing their business right out of PeachTree, then I think I would be forced to use Crystal I supposed.  Is there another software solution that I could use instead, I have hear horrors with crystal.  I mean whatever report I used for one client, I would like to be able to use it for the next, if it applies.  Would the licenesing issue give me a problem.  I believe every PeachTree user has the crystal reader, am I right?

0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<What do you mean by:  "Crystal probably would have easily been able to handle this, but then it wasn't an option for these reports.">

I mean the client didn't have Crystal and didn't want to invest in it. This was working with SQL Server data and an Access Frontend.

First and foremost: I am no Peachtree expert. I've used it in the past, but that's as far as my experience goes with it.

1) Given your requirements, it would seem to me that Crystal would be a better platform than Access.

2) I'm only familiar with Access and Crystal, but there are plenty of other reporting platforms out there. ActiveReports is one that seems to be pretty popular, but Crystal is by far the most widely used (since it's been included in VB since the early days).

3) I wouldn't dream of trying to figure out the Crystal licensing, but so long as THE CLIENT doesn't need to make changes to the layout/format of the report, then you should be okay if Peachtree uses the Crystal viewer. I'm not so sure of that, given this link I found when searching for "peachtree crystal):

http://www.crystalforpeachtree.com/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now