Sage 100

 View Only

  • 1.  ODBC for QB

    Posted 15 days ago

    Has anyone worked with ODBC and Quick Books?  Have a big client with 3 instances of Sage 100 looking at putting 5 more little companies on from QB on. One of them is using Job Costing.  The list of files available via ODBC has ONE file with the word "Job" in the name - JobType.  So wondering if the Job info is scattered amongst the other files (SO, and PO, etc), or if it just has a really "intuitive" name (not).



    ------------------------------
    Beth Bowers
    Dog Mom, first and foremost. The rest is all just necessary to keep the dogs in biscuits.
    (269) 358-0989
    ------------------------------


  • 2.  RE: ODBC for QB

    Posted 15 days ago
      |   view attached

    I have client that has bought some companies using QuickBooks.  One of the companies had "Job Cost".  The data related to job cost was not usable in their case for any transformation to Sage 100.  The purchase orders were especially a mess.  The parent company uses production management.  They had open jobs in an Excel spreadsheet from the company they bought.  They created work tickets in production management for open jobs.  We did a combination of imports and manual entry.  Attached is AI's response on job cost with QB.



    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Attachment(s)

    docx
    Job Costing with QB.docx   18 KB 1 version


  • 3.  RE: ODBC for QB

    Posted 14 days ago

    Thanks, @Michele Herzog - I'm mostly just trying to figure out where the data is for exporting. We actually just tried the PO file last night and it spun forever and we finally gave up. So far, vendors, GL accounts, and items have exported well. Eek.



    ------------------------------
    Beth Bowers
    Dog Mom, first and foremost. The rest is all just necessary to keep the dogs in biscuits.
    (269) 358-0989
    ------------------------------

    Original Message


  • 4.  RE: ODBC for QB

    Posted 14 days ago

    Time to dust off your copy of Monarch software and start ripping the data out of canned reports.....

    https://altair.com/monarch



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------

    Original Message


  • 5.  RE: ODBC for QB

    Posted 14 days ago

    Hi Beth,

    I have used a program call Transaction Pro now Rightworks - www.rightworks.com.

    They have good documentation and not very expensive.

     Thanks. Jacquie.



    ------------------------------
    Jacqueline Hoyte
    Director of Client Services
    Integrated Data Technology, Inc.
    ------------------------------



  • 6.  RE: ODBC for QB

    Posted 13 days ago

    I'll check it out, @Jacqueline Hoyte!



    ------------------------------
    Beth Bowers
    Dog Mom, first and foremost. The rest is all just necessary to keep the dogs in biscuits.
    (269) 358-0989
    ------------------------------

    Original Message


Related Content