Sage 50 US

Hi, Understanding the standard ODBC connection does not allow Write permissions, however i would like to know if there is a possibility of setting/creating a user which would have the permissions to write to the JrnHdr table, specifically the Comments…

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…

I'm trying to pull invoices from JrnlHdr using ODBC and am having trouble determining if the invoice was paid by check, CC, ACH, etc...

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.

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…

The company account is accessible through the desktop Sage 50 US Edition just fine. When we try to access through our app that uses Sage API to access it gives the following message. ANyone knows what the issue is? WIndows 2012 Server R2 Sage 50…

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…

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