Enterprise level Accounting Solution

Posted on 2011-04-24
Last Modified: 2015-11-09
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.

Question by:Pensarc
    LVL 84
    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.
    LVL 89

    Expert Comment

    by:John Hurst
    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
    LVL 38

    Expert Comment

    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.


    Author Comment

    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.
    LVL 89

    Accepted Solution

    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

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    If your business is like most, chances are you still need to maintain a fax infrastructure for your staff. It’s hard to believe that a communication technology that was thriving in the mid-80s could still be an essential part of your team’s modern I…
    Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    746 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

    15 Experts available now in Live!

    Get 1:1 Help Now