Sage 100

 View Only
  • 1.  JC_90_UDF table not available to use with ODBC con

    Posted 10-13-2016 12:36
      |   view attached
    JC_90_UDF table not available to use with ODBC connection. Sage 100 2016 update 2. Add UDF to JC header. JC_90_UDF table not available for use with crystal reports.


  • 2.  RE: JC_90_UDF table not available to use with ODBC con

    Posted 10-13-2016 12:41
    Did you JUST add the UDF? Is there any data yet? File doesn't get created until data is added, I think.


  • 3.  RE: JC_90_UDF table not available to use with ODBC con

    Posted 10-13-2016 12:42
    I added a checkbox to the header. Saved the job record with the box checked.


  • 4.  RE: JC_90_UDF table not available to use with ODBC con

    Posted 10-13-2016 12:43
    Can you see the data in DFDM? Any enhancements?


  • 5.  RE: JC_90_UDF table not available to use with ODBC con

    Posted 10-13-2016 12:50
    I just checked again on my system. I have access to the table after entering the checkbox. I may have checked the box earlier and not saved the job.


  • 6.  RE: JC_90_UDF table not available to use with ODBC con

    Posted 10-13-2016 13:50
    Turn ODBC Security on and back off again? (/grasping at straws)


  • 7.  RE: JC_90_UDF table not available to use with ODBC con

    Posted 10-13-2016 13:51
    nvm, just realized you got it.


  • 8.  RE: JC_90_UDF table not available to use with ODBC con

    Posted 10-13-2016 14:32
    Thanks to all we now have a happy customer. I did not save the job after checking the check box. That was it for sure.