Browse By Tags

Hi, I can see an ODBC connection available (default name WINFAS32) but can't connect to it. I'd like to automate some spreadsheets that can verify VIN#s on our insurance policies. I've tried integrated security and specified user names, but neither…

Hello, We currently have Windows services (written in C#, .NET) that push data out from some Sage tables to a custom API, which then stores it in a private SQL Server Database. Depending on the service, it might trigger every minute, every 5 minutes…

I am looking for instructions on how to query data from MS SQL Studio and SSRS. If needed, how to I install required ODBC drivers and where do I acquire them? We own the Sage Fixed Assets - Reporting Product, does this come with ODBC drivers? I do not…

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…

Is there a full list with all the data that can be extracted i.s.o. searching it in ODBC itself? Thank you

Hi, I have the below code but need to add in the the delivery postcode (highlighted yellow below) - how would I add this in, I'm not to sure of the joins? SELECT DocumentNo, DocumentDate, DocumentTypeID, DocumentStatusID, SOPOrderReturnLine.ItemCode…

Hi, I am trying to amend a query from Sage as needed to add in the delivery address details but doesn't seem to be working. Below is the original code that I need to amend and have highlighted in yellow in the table below what I am trying to add - any…

Good day, I am trying to create some PowerBI reports using the data from the Sage 50c Pastel Partner Data. Although there are some methods that allow me to do this by exporting data manually. I am looking for an automated solution. I have managed to set…

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)

Hi, We've been using Business Works for years and now need to integrate Order and Invoice data into our in-house proprietary external database that manages our operations. We have a few questions: Can we use SQL to set up an ODBC connection? …

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…

Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS

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…

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…

We have Sage 2022.1 on our server which is performing perfectly (on the server or through RDP with our VPN firewall). We've installed the Sage Workstation (WSSETUP), ran the Database Setup which created the ODBC and the test connection is fine. Hours…

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 am trying to export the component list for parts within Business Works. There is no way to do this through the program, but was told you can do this through a query in excel. Does anyone have experience with this? Can someone provide steps to query…

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…