[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

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

Enterprise level Accounting Solution

My company has been contracted to develop a web-based solution for POS, tech checklists, and CRM for a 10 location company.

This is all within the scope of what we can do but the challenge is integrating an accounting solution with all e standard functions in Quickbooks or Peachtree so that tables can be shared in a SQL 2005 databse.

We've got a quote from a company. Tat can provide a Microsoft GP Dynamics solution, but eir proposal is very expensive and we'd like to find a more cost-effecfive solution.

Thanks in advance for ideas/ solutions.

1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
There's QODBC, which is a Quickbooks "driver" that can be used to work with QuickBooks data. It is really nothing more than a wrapper around the Quickbooks SDK, but it's generally easier to use than the SDK. It's not as complete as the SDK, and one of the drawbacks is that when changes come about in the SDK, you must wait for the company that builds QODBC to implement those changes in their product.

Be aware too that you cannot stored QB data in anything other than the QB database. In other words, you could not tell QB to store the data on an existing SQL 2005 server, for example.
John HurstBusiness Consultant (Owner)Commented:
In addition to the above advice (I agree with it), take a look in the Intuit Marketplace for add-on solutions that are applicable to your proposal.  


Also, take a look at Atandra Systems. They provide tools to move data into and out of QuickBooks. That can be very handy for integrating applications.

... Thinkpads_User
Since you already have Quickbooks, have you looked at the new Quickbooks Enterprise Version 11 and determined why it does not meet your needs?  If it meets your requirements, it potentially offers the easiest and most cost effective route for you to take.

PensarcAuthor Commented:
I do not already have Quickbooks.

The issue is data integration with a custom App via sharing SQL 2005 tables.

I don't think Quickbooks is robust enough for this application.
John HurstBusiness Consultant (Owner)Commented:
You need some accounting framwork to start with. That is why I suggested QuickBooks plus Atandra and other add-ons. QB is one of the least expensive accounting packages. You had already discounted more expensive packages in your first post. ... Thinkpads_User

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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