Browse By Tags

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…

What is the link between the OESalesOrder table and OELineItem. I'm pulling the data via ODBC and trying to identify the key between the two tables. Any insight or documentation you can direct me towards would be greatly appreciated! (BW 2019)

Does field: OEORDD.UNITPRICE hold a pre-tax value? If not, is there a field that does?

Hello everyone, if I want to retrieve Trial Balance data through the tables which table do I do to? So I would need the debits and credits as of a particular date for each account number.. Thank you! Marc

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…

Hello- I'm having trouble getting a linked server to our Sage instance working. The ODBC driver tests successfully, but the linked server always returns the same error- SQLSetConnectAttr failed. Confoundingly it does work on our Staging environment…

Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…

Hello everyone, I am using ODBC Data Source Administrator (64-bit) version 10.0.22621.1 to establish connection between Sage 50 Quantum Accounting (Release 2023.1) and Microsoft Excel 365 64bit and it works fine. When I use the ODBC to import tables…

Hello everyone, I am running Sage 50 Quantum Accounting (Release 2023.1) and ODBC Data Source Administrator (64-bit) version 10.0.22621.1. When I setup MySQL Connector/ODBC Data Source Configuration, I enter all the parameters including Data Source…

How do you pass an SSRS report parameter to Sage? It seems you can pass an explicit value in the sql where clause but cannot pass it from a parameter. The only place to further narrow the data is to add it as a filter to the report. Is there a more…

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

Microsoft Access query based on linked tables from Sage 50 through ODBC crashing. MS Access just closes with no error messages and proposes to open in save mode next time around. Safe mode also crashes. I am using Sage 50 Quantum Accounting (Release 2023…

Hello everyone, I have exported data from Sage 50 to Microsoft Access through ODBC. In Sage, whenever we produce reports, for example Project Income, we have an option to check or uncheck show "Corrections". Which field controls for this boolean switch…

I setup a 64 bit System DSN to Sage 2022. It's configured as a silent connection and the debug option always works. I'm trying to setup a linked server connection using that system DSN but it always fails. Here's the error. Cannot initialize the data…

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…

Hi all, On my Sage 300 v2023 > Database Setup, I have 2 existing System databases for testing, which is PCISYS and SAMSYS below. I wanted to create another 1 but get this error instead. I have run RVSpy & DBSpy but no error visible. Anyone know…

We're trying to set-up a workstation which would allow a 3rd party company (via Microsoft Runtime Integration, etc) to read data off our 300 CRE via the creation of 64-bit ODBC or DSN ... eventual goal is to get our Sage CRE database sending data to an…

A customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…

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…

Upgrading from 2019 to 2022 and for that purpose deploying new virtual server. Server is running Windows 2019 and SQL is running on a separate machine. I am able to convert data but when trying to run SAGE receiving error in OE and IC. PO seems to be…

Hello I Have MAS90 version 4.05, I tried to connect using ODBC driver but i don't get connect send a error could bot connected Driver keyword syntax error, I created new odbc and when i tested sad is ok don't error but i called from app send error my…

I'm installing Sage 50 Premium in a Convenience Store which has a POS system. This POS system generates a plethora of reports & data, all of which is available in Excel format. The daily sales report it generates would be the feedstock for the SAGE invoicing…

I was originally trying to do a linked table in MS Access to JC_Job, but I got an ODBC call failed. I have no problem pulling other tables, so I tried import instead of link and I get "The decimal field's precision is too small to accept the numeric you…

I am having difficulty exporting PO's from Sage 100 2021 Advanced to MS Access via the ODBC connection. I can export headers just fine but I can't seem to export lines. I know I can get the data via linked tables, but it doesn't allow me to do what I…