• I can't establish a connection via ODBC

    Hello Colleagues, I have a problem connecting to Sage 50 from ODBC, when I try to connect to the database from excel or another program it does not validate my credentials. I have done all the processes in the documentation, I enabled the permissions…
  • Export all active customer and unpaid invoice data

    I am trying to figure out the easiest way to export current customers and unpaid invoice data. I need an excel or CSV containing a listing of all open customer invoices. My goal is to be able to share this data with a third party payment processing company…
  • ODBC (64 bit) connection to new 50c 2020.0 with Actian Zen v13 database

    FormerMember
    FormerMember
    After Upgrade to 50c 2020.0 with Actian Zen v13 database where can I find an ODBC (64bit) Driver to connect directly to the database? I can connect with the ODBC (32 bit) but it will not function with Microsoft Access 64 bit.
  • Pulling data from Sage 50 Database with ODBC at a specific time in the past to produce a trial balance

    FormerMember
    FormerMember
    The current situation : We are using ODBC to pull data from the Sage 50 database to Excel. For example, if we pull the table taccount from the database we get the table with the GL accounts list and the amount at the present time. It produces a trial…
  • Connecting to Audit Trail .DAT using SQL?

    I have been using SQL Server to connect to my .DATs without issue and today tried connecting to the AUDITTR.DAT but am getting the message that the object does does not exist. I am certain this isn't a typo or something simple like that, so I'm wondering…
  • Query/Write to and from Sage 50 Accounting database through ODBC connection

    So I have a small bit of code that shows me how to read basic sales order information (bill-to, ship-to, date of order, etc) from Sage 50 Accounting (US edition) using an ODBC connection. I have that part down, but what I need to be able to do now is…
  • Pervasive PSQL v11 - Number of users connected with Sage50 and third party software

    How many users have pervasive with Sage50 ? I noticed that pervasive shows a message that reached a maximum number of users when use third party software. I have Sage50 5 users and others third party software connected via SDK and ODBC. f