Sage 100

 View Only

  • 1.  Silent ODBC connection in excel

    Posted 01-28-2020 20:05
    I have a customer who has upgraded from v2016 to v2019 and creates queries in excel to export payroll information to send the insurance company. When editing or creating new power queries to pull from the PR_Employee and other tables I always add the PR_Employeepii.wrk file. When I save and close the query most of the fields like first and last name, address and other fields display null.

    ---------------------------------
    Shannon Stanley
    Sage 100 Consultant
    Ardent Consulting LLC
    704-839-6697
    ---------------------------------


  • 2.  RE: Silent ODBC connection in excel

    Posted 01-28-2020 21:44
    You have to create a Crystal report and run it from the Sage menu.  No other way....  But you might want to reach out to @Dan Burleson for his solution.  I have it running at three clients and it fits the bill.
    ​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: Silent ODBC connection in excel

    Posted 01-29-2020 02:43
    @Jeff Schwenk I'll get that check right out to you tomorrow! :-)
    ​​​​​

    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------

    Original Message


  • 4.  RE: Silent ODBC connection in excel

    Posted 01-29-2020 08:20
    I accept ACH payments........

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 5.  RE: Silent ODBC connection in excel

    Posted 01-29-2020 08:28
    Thank you for the help!

    ------------------------------
    Shannon Stanley
    Sage 100 Consultant
    Ardent Consulting LLC
    704-839-6697
    ------------------------------

    Original Message


Related Content