ODBC integration specs for AR

  1. installed Sage100 and want to check tables models: does Sage100 allow to sync model of tables to retrieve Account Receivable docs?
  2. if the above is not possible, could you please share a link to documentation describing tables with this info?
Parents Reply Children
  • in reply to milla k

    If you are using ODBC, ignore absolutely every reference to the BOI (which is something else entirely, although they are both available when you install the Sage workstation software on a machine).

    Open DataBase Connectivity is through the ODBC driver.  You know it is available for a machine when you can log in to Sage 100 and print (because printing works through ODBC).  For external queries you'll also see SOTAMAS90, as a reference of the connection string.

    You really should be talking with the Sage Partner for the client, who can instruct you on these things, hands-on, in minutes.

  • FormerMember
    FormerMember in reply to milla k

    BOI for most is a COM/OLE object interface. You can also access the BOI internal object framework with creative ProvideX scripting. ODBC access shouldn't have to be explained other than it's read only.