Sage 50 US

I am using ODBC and want a BASIC listing of all transactions. e.g. Date, AccountId, amount. So far I have looked at the tables starting with GENERAL_ (e.g. GENERAL_GL) but have not been able to tie them back to the reports that would be run in the front…

When I query JRNLHDR for payroll entries, AccountNumber1 - AccountNumber4 look like Base64-encoded values. I tried straight Base64 decoding but that returned gibberish characters. I'm guessing they are encrypted then encoded. Are we supposed to be able…

The COM API has a GetAccountingPeriods function. Is that information available via the ODBC interface?

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…

Have an Access program that runs queries on the Pervasive/Axiom tables pulled form an ODBC connection. Since updating to 2023 the queries no longer work. ODBC connected and can see all the table in SQL Studio but none of the queries run. Can someone…

One of my bookkeepers reports that she had her client crash with null pointer error. Looking at the server, found a 0xC0000005 error for the zenengrsvr32.exe . She couldn't quit Sage or navigate off the page she was on. Rebooted her workstation couldn…

I'm on Sage50, 2019. I've connected to the ODBC driver and have found the following query gets me part way there. SELECT a.Reference, a.AmountPaid,a.Description, a.JrnlKey_Journal, a.TransactionDate, a.MainAmount, a.Reference, a.TrxName, a.* FROM…

Hello everyone I am a new IT person to involve with sage50 I want connect to database by using 3rd party application such as Excel, Access, Power bi through ODBC to create real time and interactive report by power BI, I following this article https…

Hello, I'm looking to install two instances of the Sage 50 server on one network using two different servers. We will continue using our production server (let's call it server 1) with its current set of clients but need to set up a secondary server…

I am hoping I am wrong and someone can point me in the right direction. I need a 64 bit ODBC driver to connect to Sage 50. I can't work in 64 bit Office or in Visual Studio with the 32 bit Pervasive Client driver. Surely it can't be possible that there…

How to Migrate company data from Sage 50 Premium 2015 to Sage 300. How do I extract data from .DAT file?

We are trying to retrieve Invoice line item data through the ODBC connection. We can connect to Sage and retrieve the Customers tables (and other tables) just fine. I do not see INVOICE or INVOICE_ITEM table in the list of tables. Trying to pull into…

Hello, I am trying to import my sage database to Power Bi. I am successfully able to show the tables. However I am wanting to see if there is any documentation on what each table contains (Tables Include Customers, Address, Inventory Costs, etc). There…

What is the TimeStamp field format when using MS Access to link to the AUDITTR.DAT (Audit Trail) table? I can’t determine how to convert the TimeStamp field to a usable date/time format. When running the canned Sage report, it shows the date/time correctly…

How does the jrnlrow payrollfieldnumber relate to the DefaultPayrollField table and the PayType table. Is the PayType table a new table in 2021?

We have three PC's using Sage and using ODBC to access the sage data in Excel and Access. The PC's are identical: hardward, OS, everything. Two work fine using teh 32 bit ODBC. One, which happens to be the Sage Data server, will not allow the ODBC connection…

I have created a excel pivot report using the BI report manager and connector. I have several fields used to construct an open order report by ship date I them use Vlookup to link to anoither table from our MRP system to show On Hand FG inv and current…

Hello, I am trying to get the current inventory of part numbers that meet certain criteria. What i am getting is the inventory information at the time that each transaction was posted. So I have to use excel formulas to get the row with the highest…

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...

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…

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.

Hello, I recently installed new computers and since then when trying to connect Crystal Reports to our Sage company files, I get the following error message. Failed to retrieve data from the database Details: ADO Error Code: 0x Source: Pervasive…

When we hire new employees where I work, we have to create accounts in all kinds of different programs. Plus create windows accounts and email accounts. I wrote a Information Management Program that I have connectors to all our programs (all Microsoft…

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…

Good day Fellas :) looking for anyone who can help :), i'am having a problem regarding with our companies' sage 50, my users are trying to generate crystal reports using their workstations but unfortunately it is asking for a database password which…