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…

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…

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…

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…

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…

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.

Hi I'm using Windows 8.1. Sage 50 US, installed as client/server but on the same computer. I am the only user, an administrator. I have activated Sage security and added a couple of users: Admin and anotherm on two Sage test companies and can log in…

Can someone provide a general SQL script/statement that I can use to extra basic inventory data from the Sage 50 Accounting (2016) database? All I really need are things like the part number/Item ID, description, Active/Inactive, and price levels (price…

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…

Client just upgraded to Sage50 2016. We created a new ODBC Connection and all reports work except on. It does not like the Peachtree Additional functions even though they show in Crystal reports. (One is just for the Company name) Even if I remove…

I am looking for some help connecting Sage 50 2013 to SQL Server. Inside SQL Server Management Studio I would think the best way would to make Sage 50 a linked server. The Sage database resides on another physical server from my Management studio. I have…